Importing your clients

Add the clients you already look after in one go, from a spreadsheet, instead of one at a time.

Last reviewed

Bring your client list in from a spreadsheet

Where to start

Open your client list and choose Import clients beside Export. The same import is offered at the top of the Add client form. Each imported client is added to your practice exactly as if you had added them through that form with no will attached.

Screenshot, for illustration only

The Import clients dialog opened from the client list, at its first step, choosing a spreadsheet to uploadThe Import clients dialog opened from the client list, at its first step, choosing a spreadsheet to upload
The Import clients dialog opened from the client list, at its first step, choosing a spreadsheet to uploadThe Import clients dialog opened from the client list, at its first step, choosing a spreadsheet to upload
Import clients, opened from the client list, at its Upload step: choose your spreadsheet, then match its columns and check the rows.

What goes in the spreadsheet

Each row is one client. Your own column names are matched to ours in the import; the CSV column mapping guide walks through that step.

  • First name and Last name (needed)
  • Title: checked on every row, as on the Add client form, so a row without one is marked to fix
  • Email (optional): a client can be imported without one
  • Middle name, Date of birth, Phone and its country code, Address, Country, Client reference and Notes (optional)
  • How the client received your privacy information (optional): one of By email from your firm, In person, By post or In our client-care letter
  • Any client fields your practice has added in Client record settings, each checked by its own type. A field your practice marked as needed is needed on every new client

Each row is checked by the same rules as the Add client form: a phone number needs its country code and the other way round, a date of birth that makes the client a minor is marked to fix, and your own email address cannot be used for a client.

How privacy information is recorded

Every new client records how your firm gave them its privacy information, just as the Add client form asks. For each row the import uses:

  1. The row’s own privacy column, when your file has one
  2. Otherwise, your practice default from Practice settings, Client record settings

By email from your firm only counts while the client has an email on file, so a row that names it with no email is marked to fix. A new client with no method from either place is not added, and its row says why.

Clients already on file

  • A row is matched to an existing client of your practice by the same email address
  • With no email match, a row is matched when first name, last name and date of birth are all the same
  • A matched client is filled in, never overwritten: only fields that are blank on file take the value from your file
  • A matched client with no privacy method on file takes the one from your file

Check the rows, then import

  1. Choose your file, match your columns, then check the preview. Each row is labelled, and a row with a problem shows what to fix
  2. Tick I have written authorisation from every client listed in this file. The import cannot finish without it
  3. Choose Import. Your client list refreshes with the new clients
  • One import takes up to 100 rows. For a longer list, split the file and import each part
  • Each new client counts towards the clients your plan includes. Once that is reached, the remaining rows are reported on their row rather than added
  • Nothing is emailed to your clients by this import
Nothing is added until you choose Import. Choose Download failed rows afterwards to get the rows that could not be added, with the reason beside each, fix them and import again.

Can’t find what you’re looking for?

Our support team is here to help. Contact us and we’ll get back to you as soon as possible.

Contact us

We use cookies to improve your experience. See our Cookie policy (opens in a new tab) for details.