Skip to content

Updated on

Clients

How do I import my clients from a file?

Your client list from Excel or another spreadsheet, with first name, last name and an email or a phone number. Napiro flags duplicates before writing anything.

In this article

The import is under Settings, then Import clients. It is reserved to the salon owner: an employee does not see this page, and neither does support.

Your client list comes from a spreadsheet: Excel, Numbers or Google Sheets. In that spreadsheet, choose “Save as” and the “CSV” format: it is the only format Napiro reads. One file can hold up to 500 clients; beyond that, make several.

The Import clients page, with the template to download and the file picker

Prepare the file

The easiest way: download the template from the import page, open it in your spreadsheet and fill it in, the columns are ready. One row per client: first name, last name, and at least an email or a phone number. A “notes” column is there for anything you want to keep.

If an email or a number is badly written, the row is rejected: fix it in the file, or leave it aside when checking.

Check before confirming

  1. Choose the file and start the analysis.
  2. Read the flagged rows: “possible duplicate” when an email or phone number already exists in your records or higher up in the file, “to fix” when something is missing.
  3. For each duplicate, decide: merge with the existing record, create a separate record, or do not import the row. Nothing is chosen in advance.
  4. Confirm the import. The summary lists the records created and merged, with a link to each.

What a merge does

The existing record keeps its name and current contact details. Empty fields are filled in, notes from the file are added, and previous emails or phone numbers stay in the record’s history. Appointments and blocks do not move.

No message is sent to your clients during the import, and the file is not kept.

A question before you start? Napiro is free during the trial.

Create my Napiro page →14 days free, no credit card.