Importing Your Client List

FOR:OwnerAdmin

Updated:

Moving from another booking system or a spreadsheet? Import your client list in one go instead of typing it in. You see every row before anything is saved, and you can undo the import for 30 days.

Importing is for owners and administrators, and it works on a computer only. On a phone, the page says Importing customers works on a computer.

Getting the file ready

WellDesk reads a CSV file of up to 5 MB.

  • Wix, Google Contacts and Outlook: export your contacts as CSV and upload the file as it is.
  • Excel: save the sheet as a CSV file first.

WellDesk finds the columns by their names. Other columns are ignored.

FieldNeededColumn names it recognises
NameRequiredFirst Name, Name or Given Name. If a row only has a last name, that’s used as the name.
PhoneRequiredPhone, Mobile, Phone 1 or Telephone
EmailOptionalEmail, E-mail or Email 1
Last nameOptionalLast Name, Surname or Family Name

If the file has no name or no phone column, WellDesk says which one it couldn’t find. Rename that column to one of the names above and upload the file again.

Importing

  1. Go to Customers → Import in the sidebar.
  2. Drag your file onto Choose your file, or click Choose CSV File. WellDesk checks it straight away. Nothing is saved until you confirm.
  3. Look through the review (below).
  4. Click Import with the number of clients, for example Import 7 customers.
  5. Confirm import sums up what will happen and until when you can undo it. Click the import button again to start.

Import customers, Choose your file: the upload box, what the file needs, and Recent imports

The review

Every row lands in one of five sections. Click a section to see its rows, and search them by name, phone or email.

The review on the Cleaned up section: emails tidied, country codes added and a name taken from Last name, with Import 7 customers at the bottom

SectionWhat it means
NewClients who will be added.
Cleaned upRows WellDesk tidied before saving: a country code added to a phone number, an email tidied up, or the name taken from Last name. Excel’s ' before phone numbers is removed from every row. These rows are imported with the cleaned values.
DuplicatesRows that match a client you already have, by phone or by email, or repeat another row in the file. They’re skipped, and your existing client stays as it is.
Needs a lookRows that will be imported but are worth checking: an email that isn’t valid is left out, and a phone number that doesn’t look right is saved as typed.
Won’t importRows that can’t be imported, with the reason: no phone number, no name, a phone that isn’t a number, or a value that’s too long.

Under Won’t import, Download these rows as CSV gives you those rows with your own columns and a Problem column. Fix them and import that file on its own.

If the file isn’t right, click Choose another file and start again. Nothing has been saved yet.

Confirm import: 7 customers will be added, 2 duplicates skipped, 2 rows won't be imported, and the date until which the import can be undone

While it runs

You can leave the page. The import keeps running, and the Customers list shows its progress in a bar at the bottom. When it’s done, the bar shows the result with View, Undo and, if some rows weren’t imported, a link to download them.

Only one import runs at a time in a shop. If another is running, you can start yours when it finishes.

The result

The result: 7 customers added, 2 skipped duplicates and 2 not imported, with links to download the rows that weren't imported and to undo, and the import under Recent imports

The result shows how many were Added, how many Skipped duplicates and how many were Not imported. Download rows that weren’t imported (CSV) gives you the rows that need fixing.

Undoing an import

Changed your mind, or imported the wrong file? You can undo an import for 30 days.

  1. Click Undo this import on the result, or Undo next to it under Recent imports on the import page.
  2. Undo this import? says how many clients will be removed. Click Remove with the number, for example Remove 7 customers.

Clients who have had a booking, a payment or an edit since the import are kept, and the result says who they are. Everyone else from that import is removed.

Recent imports lists your imports from the last 60 days, who ran them, and whether each can still be undone.

What an import brings across

Names, phone numbers and emails only. Bookings, payments and notes from another system can’t be imported. They start fresh in WellDesk.

Tips

  • Try ten rows first. A small file shows that your columns are recognised before you bring in the whole list.
  • Read the Duplicates and Needs a look sections. They’re where a messy export shows up.
  • Keep the original file. If something went wrong, undo the import, fix the file and run it again.