← Switching
Switching guides

Switching from Excel or Numbers to Holder

If your client list lives in a spreadsheet, you are already most of the way there: one row per person, with headings along the top. The one real job is saving it as a CSV file, because Holder can't open Excel or Numbers files directly. Google Sheets works the same way.

What comes with you

  • Clients: yes. Names, email addresses, phone numbers, dates of birth, notes and tags, plus any other column you choose to bring.
  • Permission to email (consent): no. A spreadsheet doesn't record whether people agreed to marketing emails, so nothing in the file counts as agreement. The consent box on import starts ticked, so untick it unless you know they agreed.
  • Past sessions and notes: yes, as a second step. Import your clients first, then your sessions: see “Past sessions and notes” below.

Export from Excel, Numbers or Google Sheets

Get the list into one table first: headings in the first row, then one row per person. If your spreadsheet has several sheets or tables, save each one you want as its own file.

  • Excel: File > Save As (or Save a Copy), then choose CSV UTF-8 (Comma delimited). Choose that one rather than plain CSV, so names with accents come through correctly
  • Numbers: File > Export To > CSV, and under the advanced options choose the Unicode (UTF-8) text encoding
  • Google Sheets: File > Download > Comma-separated values (.csv)

Holder reads spreadsheet file (CSV)A spreadsheet saved as a plain file — you can save one from Excel or Google Sheets. and tab-separated (TSV) files. It can't read an Excel file (XLSX)XLSX is an Excel spreadsheet file; it opens in Excel or Google Sheets. or a Numbers file, so save a copy as CSV and upload that.

If Holder says it couldn't read the text in your file, save it again as the spreadsheet file in standard text format (CSV UTF-8)UTF-8 keeps accents and symbols correct — choose it whenever you are offered a choice. and upload the new copy.

Which columns Holder reads

When you upload, Holder lines your columns up by their headings, and you can change any of them before anything is saved. It has a place for:

  • First name and Last name. A single Name column works too: Holder splits it at the first space, so "Ada Lovelace" becomes Ada and Lovelace
  • Email and Phone
  • Date of birth. Day first (31/12/1990) or year first (1990-12-31) both read correctly
  • Pronouns, Notes, Tags and Status
  • Segment or group name
  • Unsubscribed, a yes/no column. If you keep one, headed Unsubscribed, Opted out or Do not email, everyone marked yes stays off your marketing emails
  • Age group, registered date, emergency phone, GP phone, medical info and why they booked

A column Holder has no place for can be left out, or, if you're the account owner and your plan includes custom fields, turned into a client field of your own. Any column you leave unmatched is listed before you import, so nothing disappears without you seeing it.

A row needs at least a name, an email address or a phone number. A row with less than a name plus a way to contact the person is still imported, and is flagged as incomplete so you can fill it in. A row with an email address that isn't a real address is held back and listed, so you can fix it.

Import to Holder

  • Upload the CSV file. Holder tidies dates and phone numbers into one layout when you upload
  • Read the “Match your columns” step before anything is saved
  • Possible duplicates are listed before anything is saved. If one matches a client already in Holder, you can skip it, update that client or add it as a new client. A repeat of another row in your own file is listed too and skipped by default, so each person arrives once
  • Several lists? Upload them one after another. Holder spots people already in Holder by their email address, and shows you what differs, detail by detail, before anything is saved
  • If the same person is on two lists and one says they have unsubscribed, they stay unsubscribed

Past sessions and notes

  • Import your clients first, then your sessions
  • Save the file as CSV (from Excel or Numbers: export as CSV)
  • Each row needs the session date and the client’s name or email. Time, session type, note text, note title, finished status and date, and practitioner name are optional
  • Up to 5,000 rows a file. If your history is longer, split it across several files
  • In Settings → Account → Import & export, the “Download an example file” button gives you a file to copy the layout from

What you rebuild in Holder rather than import

  • Booking pages, session types, availability, packs. Holder doesn't copy these across for you; you set them up by hand
  • Under an hour, by hand

What doesn't come with you

  • Marketing consent. Decide who you have permission to email and record it yourself in Holder
  • Formulas, colours and filters. A CSV file holds the values only. Keep the original spreadsheet for anything you built on top of them
  • Payments and balances. Holder imports your clients, not amounts paid or owed. Keep the spreadsheet for your accountant, and honour anyone holding unused sessions or credit by hand

The last step

  • Update the booking link: website, bio, email signature, anywhere it appears
  • Take a test booking as a client and check the confirmation lands
  • Keep the original spreadsheet archived somewhere private and password-protected (encrypted). It holds your clients' personal details

Bringing across years of past bookings and records for you (a “deep history import”) is a paid one-off service, not part of a trial or a plan. If you want one, send us your export before you start a trial: we'll quote you for it, and tell you honestly what will and won't come with you either way.

Try it on your own terms

Every feature, free for 30 days, no card. Import your client list in one sitting and take a real booking the same afternoon.

Start free trial
Switching from Excel or Numbers to Holder · Holder