Exporting your client list
Download your clients as a spreadsheet (CSV) with their contact details, birthday, notes, marketing choices, last visit and spend.
You can download your whole client list as one spreadsheet at any time: names, contact details, birthdays, notes, marketing choices, last visit and spend. It opens in Excel, Numbers or Google Sheets.
Downloading your client list
- Open Clients and press Export (on a phone, the download icon), or open Settings → Import & export and press Download all clients (CSV) under Client list.
- The file downloads straight away, named "clients-" with today's date.
Exporting needs two permissions: "Import, export, merge and remove clients" and "See clients’ phone numbers and email addresses". Owners have every permission. On a shared device set to Front desk, it asks for your password first (shared devices).
What's in the client list export
One row a client, sorted by last name, then first name. Clients you've removed aren't included.
| Column | What it holds |
|---|---|
| id | FullColumn's number for the client |
| first_name, last_name | Their names |
| email, phone | Their email and mobile, as entered |
| birthday | Year-month-day (2026-03-14); a birthday without a year is month and day (--03-14) |
| address, tags, alert, notes | As on their card. notes is the Notes box, not the dated notes on Formulas & notes |
| marketing_email | 1 if they get marketing emails, 0 if not |
| marketing_sms | 1 if they get marketing texts, 0 if not |
| feedback_requests | 1 if they're asked for feedback after a visit, 0 if they've said no |
| created_at | When they were added, in UTC (universal time, so near midnight it can show the next or previous day) |
| last_visit | The date and time of their last visit |
| spend_cents | Everything they've spent, in cents (12550 is $125.50), less tips, with imported past visits |
Names with accents show properly in Excel, and anything typed in that looks like a spreadsheet formula starts with an apostrophe, so it can't run when the file is opened.
Getting more than the client list
The client list export is just your clients. For everything else, use Download everything in Settings → Import & export: every client (removed ones too) with their patch test, reminder choices, usual stylist, visits and next appointment, plus appointments, sales, notes and colour formulas, messages and photos (downloading everything). It's the owner's by default.
Common questions
Why can't I see the Export button?
It needs two permissions: "Import, export, merge and remove clients", and "See clients’ phone numbers and email addresses", since the file has every client's contact details. Without the second, Clients has no Export, and Settings → Import & export says which permission is missing under Client list. Ask your salon's owner (roles and permissions).
Can I use the export as a mailing list?
It has everyone's email and mobile, with marketing_email and marketing_sms saying who agreed to marketing. To send marketing from FullColumn, use a campaign instead: it only goes to clients who've agreed, and skips anyone who's opted out (marketing campaigns).