> ## Documentation Index
> Fetch the complete documentation index at: https://docs.uplifter.app/llms.txt
> Use this file to discover all available pages before exploring further.

# How do I import my register from a spreadsheet?

> Upload your member spreadsheet, check how Uplifter reads it, accept the report and start the import, or cancel it before anything is filed.

> [!NOTE]
>
> **Must know**
>
> * **Nothing is written to your register until you accept the report and select Start import.**
> * **You start spreadsheet imports yourself.** An import of your old database is started for you.
> * **A cancelled import files nothing.** It stays on your list of imports as **Cancelled**.
> * **You need the Manage memberships permission.**

**Where to find it.** Go to **Athletes > Directory**, open the **Members** tab if you see one, then select **More actions** (the three dots) and **Register import**. It lists your newest 50 imports for the period you choose at the top. Tiles show **Imports** and **Waiting on you** (imports nobody has accepted yet, or whose report changed). If you have the **Export member claim links** permission, it also has a **Claim links** section.

**1. Upload your file**

Select **Import a spreadsheet**. Under **Your register file**, add a .xlsx, .xls or .csv up to 50 MB, with one row per member, per season.

**2. Confirm how it reads**

Check **Sheet**, **Header row** (rows above it are ignored) and **Dates read as**: dates read **Day first (31/12/2010)** unless you choose **Month first (12/31/2010)**. Under **What each column holds**, check every **Holds** choice against **Your first rows**: they are only a starting point. Map the name (**Full name**, or **First name** and **Last name**) and **Date of birth**, or the import cannot start.

**3. Date your seasons**

If you map a column to **Season**, give each season its **Starts** and **Ends**. A season left blank takes the dates you give when you accept. Map **Email** too, or a member listed in two seasons reads as two people and goes to your review queue with no membership.

**4. Read the list**

Select **Read list**. You see "Your register has been read. Check the report before anything is written." and land on the **Import report**.

**5. Check the report**

On **Summary**, tiles show **Rows**, **Can be matched** and **Cannot be matched** (imported and numbered, never matched). **Member numbers** says where new numbers start. Other tabs: **Duplicates**, **Your organizations**, **Memberships** and **Field map**.

**6. Accept the report**

Select **Accept report** and answer the sheet (below). Until you start, **Edit answers** reopens it.

**7. Start the import**

Select **Start import**. You see "The import has started." On your list of imports, **Status** reads **Importing**, then **Finished**. Select **Review matches** to work any held rows.

**What you choose when you accept.**

| Field | Your choice |
| - | - |
| **Review owner** | The administrator who works held rows. Required. |
| **Decide held rows by** | After this date nothing is merged, and any row still waiting stays held with no number until you answer it. Required. |
| **When two of your rows are one person** | Keep the lowest or the highest number and retire the rest. A retired number still finds the person. |
| **When a number is not in your format** | Issue a new number, and keep the old one searchable or drop it. |
| **Rows without a purchase hold** | **Nothing, a number only**, or a membership with **Covered from** and **Covered to**. Required, with no default. A spreadsheet carries no purchases, so this covers every row. |
| **Accounts with no matching organization** | Shown when a **Club** in your file matches none of your organizations. Pick the organization those rows belong to, or keep **Leave under your name**. |
| **Already paid in the old system, don't bill these organizations** | When shown, tick it so the report does not offer to bill them. |

**If a column is wrong.** On **Field map**, select **Remap columns** and read your file again. This drops your acceptance. A report that changes after you accept it shows "This report has changed since it was accepted" and must be accepted again.

**Cancel an import.** Until it starts, select **Cancel import** at the foot of **Summary**, then confirm, or choose **Keep it**.

**Old database imports.** You accept the report, but **Start import** is not offered to you; the import is started for you.

**Related:** [How do I review held rows from an import?](https://docs.uplifter.app/governing-bodies/member-register/review-import-matches.md) · [How do I send members their claim links?](https://docs.uplifter.app/governing-bodies/member-register/send-claim-links.md) · [How do I review a member list a club sent me?](https://docs.uplifter.app/governing-bodies/member-register/review-a-club-member-list.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.