How to import customers

Moving to a new system can feel like a big step, but we’ve made it simple to bring your history with you. Our new import tool allows you to easily upload your existing customer lists from a previous platform. Get set up in just a few minutes by following the steps below.

To find these features, navigate to Settings -> Advanced and find the buttons for Import Customers.

Please note that while it is functioning on Mobile devices, we recommend you use a wide screen device for this (laptop, PC, tablet).

You can import the following fields:

NameRequiredFormatDefault value(s)
NameYesFull name or first name + last name
EmailNoNone
PhoneNoNone
TagsNoComma-separated tagsNone
Address 1NoNone
Address 2NoNone
Address 3NoNone
Postal / zip codeNoNone
Country codeNo2-letter country code, or full English name of the countryNone
NoteNoNone
Created atNoTimestamp, in YYYY-MM-DDTHH:mm:ssTime of import

Step 1: Upload Your File

How to import customers - screenshot

First, you’ll need your customer data in a CSV (Comma-Separated Values) file. Most platforms allow you to export your data in this format.

  • Click the “Upload file” button and select your CSV file, or drag and drop it from your PC.
  • To ensure a smooth import, your file must contain a column for Name.
  • Unsure about the format? You can download our template to see how your file should be structured.

Step 2: Match Your Data

How to import customers - screenshot

This is where you’ll match the columns from your file to the booking fields in our system. We call this “mapping.” Our system will try to automatically match your columns, but it’s always a good idea to double-check that everything is correct.

  1. Check the Mapped Columns: Look down the list. For each “Column name from file” (e.g., “Name”, “Email”), check that the value in the “Import as” dropdown is correct (e.g., “Name”, “Email”).
  2. Assign Missing Fields: If our system missed the required “Name” field, click the dropdown menu next to it and select “Name”. A red warning message will appear if any required mappings are missing.
  3. Verify the Format: For fields like dates, times and names, you can specify the format. For a “Date” field, ensure you’ve selected the correct format, such as YYYY-MM-DD, to match your file. For a name field, choose between “Full name” or “First name, Last name”.

Step 3: Finalize Your Import

Once you’re happy with your data mapping and there are no warnings, click “Continue” to start the import.

The system will process your file, which may take a few moments. When it’s done, you’ll see a summary showing:

  • How many customers were successfully imported.
  • How many customers failed to import.

If any customers failed, you can download a new CSV file containing only the failed rows. This file will include an extra column explaining the reason for the failure (e.g., “Invalid date format,” “Missing guest name”), making it easy for you to fix the issues and try again.

If you need to update or re-import your data, you will see an option to “Replace existing” when you upload your file.

Please be aware that this option replaces all previously imported customers with the data from your new file. Any customers you have created manually or through your booking flow within our system will not be affected.

Line from the Resos support team Support team member Support team member

Still looking for help?

Can't find what you're looking for? Our support team is happy to help.