Sunrise over a sea of clouds in the Himalaya

Import customers from a spreadsheet

Bring past travellers into TripNerve from Excel, Google Sheets or a CSV file. Match columns, check every row and merge people you already have.

Enquiries and bookings · Updated 8 November 2026

If you keep past travellers in Excel, Google Sheets or an old booking system's export, you can bring them into Customers in one go. This article covers the columns TripNerve accepts and each step of the import.

Get your spreadsheet ready

Save the sheet as CSV (File, then Download or Save as, in most spreadsheet apps). The first row must name each column. Commas, semicolons and tabs all work as separators, so files from European versions of Excel are fine.

You can import up to 2,000 customers at a time, from a file of up to 5 MB. Split larger lists into several files.

The columns TripNerve accepts

Each column in your file can be imported as one of these:

  • Name: required on every row. Headers like "Full name", "Customer", "Traveller", "Client" or "Lead name" are recognised.
  • Email: must be a real email address, or the row can't be imported.
  • Phone: any format, up to 40 characters. "Mobile" and "WhatsApp" headers are recognised.
  • Country: a country name such as "Germany", or a 2-letter code such as "DE". "Nationality" is recognised too. A country TripNerve doesn't recognise is left blank, with a warning.
  • Heard about us from: up to 120 characters, for example "Tripadvisor" or "Referred by Okafor family".
  • Notes: up to 4,000 characters.
  • Tags: several tags separated by commas, for example "Repeat client, Agent".
  • Any custom field you've set up under Tags and fields. Number fields need a number, date fields a date like 2026-10-12, and choice fields one of their options.

A column you don't need can be set to Don't import.

Import the file

  1. Open Customers and click Import.
  2. Under Your spreadsheet, drop in your .csv file, or copy the cells from your spreadsheet (header row included), paste them into Or paste the rows and click Use pasted rows.
  3. TripNerve guesses what each column holds from its header. Check the Import as list next to each column, using the First value to see what's in it. Each choice can be used once.
  4. Make sure one column is set to Name, then click Check rows.

Check the rows

Nothing is saved yet. Check the rows shows every line of your file with a status:

  • New: a customer you don't have yet.
  • Already a customer: matched by email or phone to someone in TripNerve, with a link to them.
  • Same as line followed by a number: the line repeats an earlier line in the file.
  • Can't import: something needs fixing, explained under Problems, such as "Name is missing."

Under People you already have, choose what to do with matches:

  • Merge into the existing customer fills in what the customer is missing, adds the tags and empty custom fields, and adds the notes to theirs. Nothing they already have is overwritten.
  • Skip them leaves existing customers as they are.

Then click Import with the number of customers, for example Import 312 customers.

After the import

Import finished shows how many were Added, Merged into existing customers, Skipped as already customers and Not imported, with the reason for each line left out. Fix those lines in your file and import them on their own later.

Good to know

  • Tags that don't exist yet are added if you can manage tags. Otherwise they're left off, with a warning, until someone who manages tags adds them.
  • Merging needs permission to edit customers. Without it, matches are skipped.
  • Import is for customers only. Past bookings and enquiries aren't imported.
  • Customers who booked or enquired through your website are already in Customers. You don't need to import them.

Import a small test file of 10 rows first. It's quicker to fix the column choices before the full list.

See also Customers and Move from another website.

Can't find what you need?

Email us and a person on our team will answer, usually the same day in Nepal time.

Email support