Import or invite many customers at once

Press Import in Customers to bring in a spreadsheet or a CRM export. You see what every row will do before anything is saved. To invite customers to their portal, tick them in the list and press Invite…. The invitations go out from your own domain while you get on with something else.

Step by step11 stepsUpdated 21 Nov 2026

Bringing a whole book of clients over? Import them from a spreadsheet, see what each row will do before anything is saved, then invite them to their portal in one go.

Import a spreadsheet

  1. Open Customers and press Import.

  2. Choose your file: an Excel workbook (.xlsx), a CSV, a tab-separated file or a CRM export, up to 25 MB. Or paste cells copied straight from your spreadsheet. Download the columns gives you a file with every heading it reads, ready to fill in.

  3. Check the columns. They're matched by their headings, in the words people use (Business name for Company, Mobile for Phone). Tap a column's name to set it yourself.

  4. If the file doesn't say how a new customer will use the platform, choose Self-serve or Managed campaigns for them.

  5. Leave Email each new customer an invite to sign in ticked to invite them as they're added. Off, nobody is emailed, and you can invite them later.

  6. Read the preview. Each row says what importing it does, and its result: New, Brought back, Updated, No change or Left out. Tap a result above the rows to see only those.

  7. Press Import with the number, such as Import 240 customers. Keep the window open until it finishes.

It ends on Import finished, with what it did: Added 238 customers, brought back 1 and updated 4.

Rows that didn't import are listed with the reason. Download them gives you those rows in a file: put them right and import that file.

Tip

Importing the same file twice changes nothing the second time. If an import stops part way, import the file again to finish it.

What a file can hold

ColumnWhat it does
EmailFinds the customer the row is about. With no email, a company name only one of your customers has.
First name, Last nameA new customer needs both, and an email. A single name column is split in two.
Company, Phone, AddressThe customer's details
Your word for a branchPuts the customer in that branch. A branch you don't have yet is added, if you can set up branches. none takes them out of their branch.
Account manager, Backup, ProductionTheir account team, by email or full name. Production can also be a pool. none takes the place off their team.
AccessManaged or Self-serve

A customer you'd archived comes back with their data, as Brought back. A row that asks for something that can't be done is left out whole, so nothing is ever half done.

Up to 5,000 customers a file. Split a bigger list into files of 5,000 or fewer.

Note

A Numbers file can't be read: in Numbers, choose File › Export To › Excel, then choose that file. An OpenDocument sheet or an old binary .xls file: save it as an Excel workbook (.xlsx) or a CSV first.

Owners can import, and managers who look after every customer or a set of branches. A manager who looks after only their own customers adds them one at a time: Add a customer.

Invite many customers to their portal

  1. In Customers, tick the customers you want to invite. On a computer or a tablet, a bar opens at the foot of the list.

  2. To take everyone the list shows, tick them all on screen, then press Select all with the number. It takes up to 10,000.

  3. Press Invite….

  4. Press Send invitations.

Owners, managers and account managers can invite, for the customers they can change. Each one gets an email from your own domain, with a link to set up their sign-in. The link works for 7 days.

Left out: anyone already signed in, invited in the last day, archived, or with no email.

You can leave the page: the invitations keep going. A banner above the list follows them, such as 312 of 1,240 done and About 4 minutes to go, with Stop. When it's finished, it says how many were invited and who was left out. Owners and managers see every run on the team, with who started it.

Important

Invitations go out from your own domain, so Invite… shows once it's set up. Customers you import or add before then are still added, with no invite: once your domain is set up, tick them and press Invite….

The same bar changes the ticked customers in one go: Account manager…, Production… and Move… to another branch. Clear unticks them.

Next in Your customersRun a customer's email for them