# Importing customers

Category: [Customers & Player Protection](https://basecomp.io/help/customers)
Updated: 2026-11-18

> Upload a CSV from Customers > All Customers > Import, map its columns, and choose to create new customers, update existing ones, or both.

You can bring customers in from a spreadsheet with the CSV import: go to [Customers > All Customers](https://basecomp.io/dashboard/go/customers) and press **Import**. Upload your file, match its columns to customer fields, pick what the import should do, and Basecomp creates or updates one customer per row.

### Before you start

Press **Download CSV template** at the top of the import page for a file with the right headings and two example rows. Your CSV must have headings in its first row. Test with a small batch first before importing your whole list. There is no need to split a big list into smaller files: tens of thousands of customers import in one upload, in seconds.

The fields you can import are:

| Field | Notes |

| Email | Required on every row. Must be a valid address. |

| First Name, Last Name | A single "Name" or "Full Name" column is split into first and last name for you. |

| Phone | |

| Status | "active" or "enabled" imports as Active; "blocked", "suspended" or "disabled" imports as Blocked. Anything else, or blank, is Active. |

| Notes | Saved as the customer's internal notes. |

| Spend Limit | In pounds, for example 500.00. |

| Website Credit Balance | In pounds, for example 25.00. |

| Accepts Marketing | "yes", "true", "1" or "subscribed" opts the customer in to your email campaigns. "no", "false", "0" or "unsubscribed" opts them out. Blank, or anything else, leaves a new customer opted out. For customers already in your store the import can opt them out but never back in, so it cannot undo someone's own unsubscribe. |

| Customer ID | Only for updating customers already in your store. |

Common heading names are recognised automatically, so a column called "Surname", "Mobile", "Credit Balance" or "Marketing Opt-in" is mapped without you doing anything.

### Running the import

- Under **Select CSV file**, choose your file.

- Under **Import settings**, answer **What do you want to do?**: **Import all customers**: update customers who already exist and create the rest.

- **Only update existing customers**: change matching customers and skip anyone not found.

- **Only create new customers**: add new customers and skip anyone who already exists.

- If you are updating, choose **Match customers by**: Email or Customer ID.

- Under **Map CSV columns**, check each of your columns is matched to the right field, or skipped. Highlighted fields still need a decision. The **How your import will work** box sums up what will happen.

- Press **Start import**. The **Import progress** card shows how many rows were processed, created, updated and failed.

Any row that fails is listed under **Row errors** with its row number and the reason, for example "Email is required", "Invalid email format" or "Email already exists". Fix those rows in your file and import them again.

### What imported customers need to know

Imported customers get an account on your store, but no password they know. The first time they try to sign in with a password they are told their account needs a password reset, and they use the forgot password link to set one. If your store uses passwordless sign-in, they simply request a sign-in code.

Order history, tickets and wins from your previous platform are not created by a customer import, so their statistics start from zero on Basecomp. The customer page marks imported customers with a note that their earlier history may be incomplete.

### Marketing consent

Imported customers only receive your email campaigns if your CSV says they agreed to. Without an **Accepts Marketing** column, every new customer is imported opted out. Only mark someone yes if they agreed to hear from you, or from the brand they signed up with.

Include the column the first time you import. For customers already in your store, a later import can opt them out but never opts them back in, because their current setting may be their own choice to stop hearing from you. A customer can always opt in themselves from their account or at checkout.

### See also

- [Managing customers](https://basecomp.io/help/customers/managing-customers)

- [Moving to Basecomp from another platform](https://basecomp.io/help/getting-started/moving-to-basecomp-from-another-platform)

- [Customer accounts on your store](https://basecomp.io/help/customers/customer-accounts-on-your-store)
