Import your existing client list
In this guide, you'll learn how to add your existing client list to Fresha all in one go.
How importing your client list works
You can easily upload multiple clients at once using a CSV file or a ready-made template. This automatically creates a profile for each client, making them recognizable as an existing client when they book online.
To keep your client list organized, Fresha will identify any duplicate profiles that can be merged.
Import your client list
- From the main menu on the left of your screen, go to Clients.
- Click on the Options button in the top right and select Import clients.
- In the Upload file step, choose one of the following options:
-
Select Upload CSV file or drag and drop the file into the box.
-
Download and fill in a ready-to-use template by selecting Download template.
-
- Once you've uploaded your client list, click the Next step button in the top right to continue.
- In the Review column step, make any adjustments to match your column names, then click the Next step button in the top right to continue.
- In the Preview client list step, review the client list to ensure all details are correct.
- Click on the Start import button in the top right to begin uploading your file.
- Once imported, click on the Done button in the top right.
Once your import is complete, the clients will appear in your client list with all their details and will be recognized as existing clients.
Client list file requirements
To upload your existing client list, the data will need to be formatted as a CSV file. If you don’t have a client list file, download our template and fill it out with the following information for each client:
- First name (mandatory)
- Last name
- Mobile phone
- Gender
- Client notes
- Birthday
We recommend including an email address and mobile phone number so your clients can receive appointment updates.
Formatting guidelines
You’ll need to use the following format when entering the date on your existing client list file:
- For most regions use: DD-MM-YYYY
- If you're in the United States, Panama, or the Philippines, use: MM-DD-YYYY
You can use the following dividers between the day, month, and year:
: (For example, 01:03:2002)
/ (For example, 01/03/2002)
*\* (For example, 01\03\2002)
- (For example, 01-03-2002)
. (For example, 01.03.2002)
Handling duplicates
Fresha automatically checks for duplicate entries based on email addresses and phone numbers. If two clients share the same email or phone number, they will be flagged as duplicates. Names are not used to detect duplicates, as multiple clients may have the same name.
See examples of duplicates below:
| Name | Email address | Mobile Number |
|---|---|---|
| John Smith | johnsmith@example.com | +44 113 496 0000 |
| John Smith | johnsmith@example.com | NA |
| Name | Email address | Mobile Number |
|---|---|---|
| John Smith | johnsmith@example.com | NA |
| John Smith | johnsmith@example.com | NA |
| Name | Email address | Mobile number |
|---|---|---|
| John Smith | johnsmith@example.com | +44 113 496 0000 |
| Jonny Smith | NA | +44 113 496 0000 |
See the example of non-duplicates below:
| Name | Email address | Mobile number |
|---|---|---|
| John Smith | NA | +44 113 496 0000 |
| John Smith | johnsmith@example.com | NA |
FAQs
Fresha will highlight any errors found in your file to help you correct them quickly. You can download a version with the issues by clicking on the Options button in the Preview client list step, make the changes, and upload it again.
Importing your existing clients’ contact details before going live on the Marketplace ensures they’re recognised as returning clients. This helps you prevent being charged a Marketplace New Client Fee when they book online through Fresha.
You can exit the process to review your file format and try again. Use the preview screen to check that the columns match correctly. If some entries still cannot be uploaded, you can manually add those clients afterward.
If you've uploaded an incorrect client list, you can delete your clients in bulk to remove those clients from your workspace. Once deleted, you can re-upload the correct file.
