Importing records from a spreadsheet

You can add or update records of any record type you created, such as People, Sessions or Sites, from a CSV file. Participants and team members can’t be imported. They get their records when they join.

Project owners, admins and members who can manage records can import.

1. Get your file in the right format

Open the record type’s list under Records and choose Import CSV. The page lists the columns the type takes and what each one accepts. Download a blank file gives you a CSV with the right headings and an example row.

  • The first row holds the column names. Use Name, then the field names, such as Email or Organisation. Capitals and spaces don’t matter.
  • Columns can be in any order. Columns that don’t match a field are left out, and the check tells you which.
  • Choices: write the choice as it appears, such as NHS or Charity. For a field that takes several, separate them with a semicolon.
  • Yes or no: Yes, No, Y, N, True or False.
  • Dates: day/month/year, such as 31/01/2026. Dates with times look like 31/01/2026 14:30.
  • Links to other records: the name of the record, such as the session’s name. Separate several with a semicolon.
  • Fields that fill themselves, such as generated IDs, aren’t imported.

Most systems can export a list as CSV. In Excel or Google Sheets, choose Save as or Download and pick CSV.

2. Upload and check

Choose your file and Check the file. Nothing is saved yet. You see how many records will be added, how many updated, and every row with a problem and why.

A row updates an existing record when its name matches exactly one record of that type, or when it has an ID column holding the record’s ID. Every other row makes a new record. If two records share a name, add the ID to say which one you mean.

3. Import

Choose Import. Rows with problems are skipped and everything else is saved. Fix the skipped rows in your file and upload it again to add them. Rows already imported match by name, so they update rather than duplicate.

You can import up to 1,000 rows at a time. Imported records count towards your plan’s record allowance, and while a project is being built it holds up to the building limit of test records.

Each new or changed record appears in the project’s activity log, the same as records added by hand.