Getting Started

Importing data

Bulk-import clients, services, products and appointments from a CSV file: including templates, a preview check, and handling duplicates.

9 min read5 sectionsAlso in 8 other languages
In Getting Started (9 articles)
On this page

Switching from another system or starting with an existing client list? With CSV import you bring a large number of clients, services, products or appointments into Salonnare at once. The import runs in four steps with a built-in preview check, so you see beforehand what will be imported and what goes wrong.

Only an admin can import. There are four types: Clients, Services (treatments), Products and Appointments of clients who are already in Salonnare. In this example we import three clients.

Importing clients from a CSV file

  1. Step 1: Choose the Salonnare source

    Go to Settings > Advanced > Import and choose Salonnare (CSV per category). The other option, Switching from other software, is the wizard for exports from another salon system; see Switching from other software.

    Import data with the Salonnare option highlighted (Enlarge image)
  2. Step 2: Choose what you import

    Click Clients (or Services, Products or Appointments).

    The four import types with Clients highlighted (Enlarge image)
  3. Step 3: Download the template and choose your file

    Don't have a file in the right format yet? Click Download template (1): you get an empty CSV file with the correct column headers. Fill it in and drag it into the box, or click the box to choose it (2). A file you save from Excel works straight away: Salonnare detects a comma, semicolon or tab as the separator on its own and reads letters such as é and ë correctly.

    The Download template button and the drop zone highlighted (Enlarge image)
  4. Step 4: Check the preview and import

    Salonnare shows per row whether it is valid, has an error (with the reason) or is a duplicate, with the counts at the top (1). Rows with an error are skipped. If you have duplicates, choose whether to skip or update them (see below). Click Import (2).

    The preview with three valid rows and the Import button highlighted (Enlarge image)
  5. Step 5: View the result

    You see how many records were imported, how many were skipped and how many errors there were. With Another import you start again.

    The Import complete summary highlighted (Enlarge image)

Your own file (with AI assistance)

If you have an export from another system with its own column names, you do not have to rebuild it into our template first. Choose Your own file (with AI assistance) as the source. You then submit an import request, which we check and approve before anything in your data changes.

This feature is not yet enabled for everyone. If you do not see the option, it is not yet available for your salon.

How it works

  1. Choose the type: products, services or clients. One file per request; if you have products and clients, submit two requests.
  2. Upload: a CSV or Excel file (.xlsx) of up to 20 MB and 100,000 rows. Columns with payment details (such as IBAN or card numbers) are never read. A file with health data (allergies, medication, treatment reports) is rejected: that belongs in the secure health vault. Want to bring health data into the vault? Use Switching from other software.
  3. Review the mapping: Salonnare first maps the columns by name; this also recognises the column names from the Salonnare templates (in all nine languages) and common headers from your own spreadsheet or till export, such as "First name", "Surname", "Zip code", "Sales price" or "In stock". Capitals and accents make no difference. Click Let AI suggest a mapping for a suggestion per column, with a short explanation why. You can then attach any column to a different field or ignore it.
  4. Update existing items (off by default): when this is off, the import only adds new items and leaves existing products, services and clients untouched. When you turn it on, existing items are updated with the values from your file. An empty cell never erases an existing value.
  5. Check: a dry run shows how many items are new, how many will be updated and which rows are skipped, with the reason. Nothing is saved yet.
  6. Submit: your import is checked and approved within 24 hours. Until then nothing changes in your data. Want to change something after all? Click Withdraw; the request goes back to draft.

After approval the data is written and you receive an email and an in-app notification. If the request is not approved, you see the reason with the request (and in the email). Nothing has changed; you can adjust the mapping and submit again.

What is sent to the AI?

  • Optional: nothing is sent to the AI unless you click Let the AI suggest a mapping yourself. Without that click you map the columns yourself or by name, and everything stays within Salonnare.
  • Clients: only the column names and a type profile per column (for example "email address", "date in the form DD-MM-YYYY", "partly empty"). The sample rows the AI sees are entirely made up. No value from your client file leaves Salonnare.
  • Products and services: column names, the type profile and three sample rows. Email addresses, phone numbers, IBANs, postcodes and old dates are replaced first, and free text longer than 40 characters (such as a long description) is left out. If one column holds several email addresses, phone numbers or IBANs, the AI is not used.
  • File without a header row: if the first line is not a row of column names but straight away a client or product, the file is not sent to the AI. Add a line with column names at the top, or map the columns yourself.
  • The AI only suggests the mapping. Converting the rows themselves is done by Salonnare, not by the AI.
  • Who provides the AI: Anthropic (Claude), in the United States. Anthropic does not use this data to train models and deletes it within 30 days; only a request flagged by their automated safety checks may be kept for up to 2 years. More in our privacy policy, the data processing agreement (article 16) and the list of sub-processors.

By default each salon can request 10 AI suggestions per month; how many you have left is shown next to the button. When they are used up, you map the columns yourself; submitting still works.

If your file has a column with consent for newsletters or offers (yes/no), it is taken over, with the import recorded as the source. No means the client is unsubscribed from marketing email. Yes never lifts an existing unsubscribe: if a client unsubscribed themselves, that stays.

An import never sends email to your clients: no welcome email, no birthday email and no review request.

CSV format and columns

The column headers on the first line are in Dutch and must match exactly. Preferably use the downloadable template. The fields per type:

Clients

ColumnRequiredNote
naamYesClient name
emailNoValid email address
telefoonNoPhone number
notitiesNoFree-text note
geboortedatumNoFormat YYYY-MM-DD

Services

ColumnRequiredNote
naamYesTreatment name
duur_minNoDuration in minutes (default 30)
prijsNoPrice (comma or dot)
categorieNoName of the service category. An existing category with that name is reused (capitals and spaces at the start or end don't count), otherwise it is created. Empty = the service goes into the category Geïmporteerd
btw_percentageNoVAT percentage

Products

ColumnRequiredNote
naamYesProduct name
prijsNoSale price
inkoopprijsNoPurchase price
voorraadNoStock quantity
categorieNoName of the product category. An existing category with that name is reused (capitals and spaces at the start or end don't count), otherwise it is created. Empty = the new product goes into the category Geïmporteerd; an existing product keeps its own category
skuNoArticle code. Empty = Salonnare creates one from the product name, as in the product form; if that code already exists, -2, -3 and so on is added. If Auto-generate SKU is switched off, the SKU stays empty

Appointments

ColumnRequiredNote
klant_emailYesEmail address of a client who is already in Salonnare
startYesDate and time as YYYY-MM-DD HH:MM, in your salon's time
duur_minNoDuration in minutes; empty = the duration of the services
medewerkerNoStaff member's name; empty = your only or first active staff member
dienstenNoService names separated by commas; an unknown service is created in the service category Geïmporteerd
statusNoscheduled, completed, no_show or cancelled (default scheduled)
notitiesNoFree-text note

Import your clients first: an appointment with an email address Salonnare doesn't know is skipped as an error. Imported appointments never send a confirmation, review request or other automatic email to clients. Only when Send reminders for upcoming appointments is on (on by default) do clients get the usual reminder for an appointment that is still to come, at the time set in your settings. If that moment has already passed (for example an appointment tomorrow morning), no reminder is sent afterwards. If you later complete an imported appointment that was still to come, the usual follow-up applies, just like for an appointment you made in Salonnare: the review request, the rebook email (if it's on) and, for a no-show, the recovery email if you choose it. Nothing is ever sent for appointments in the past.

If a given category does not exist yet, the import creates it automatically. Services and products get the default VAT rate if you don't specify one. If you leave prijs or inkoopprijs empty, that price stays empty: it is not turned into 0.00.

How are duplicates handled?

Duplicates are detected on a unique field: for clients on the email address, for products on the SKU and for appointments on the combination of client and start time. (Services have no duplicate check.) A duplicate appointment is always skipped. When a client or product row matches an existing record, you choose in the preview step what happens:

  • Skip: leave the existing record unchanged.
  • Update: update the existing record with the data from the CSV file.

With Update, an empty cell means: leave it alone. For a client, phone, notes and date of birth then stay as they are; for a product, the price, purchase price, stock and category. Salonnare always takes the name from the file.

A product without a SKU in your file has nothing to compare against, so it is always added as a new product. If you import the same file twice, give your products a SKU.

Common errors

  • Name is required: every row must have a name.
  • Invalid email address: the email is not in the correct format.
  • Invalid date of birth: use YYYY-MM-DD.
  • Invalid price or duration: use a number; for prices a comma or dot is allowed.

This per-category import covers clients, services, products and appointments. Switching from other salon software and want to bring absences along too, or do you have the export files of your old system? Then use the migration wizard: see Switching from other software. Receipts or gift cards cannot be imported via CSV: you create those in the app or keep them in your previous bookkeeping.

Want to grow your client list further afterwards? See Managing clients. For your service offering, see Services.

Was this helpful?

Your answer helps us improve the guides.

Still stuck?

Support: Mon-Fri reply within 24 to 48 hours (Pro: within 24 hours) · weekends and public holidays: within 24 hours if urgent, otherwise on the next business day

Contact us