Best practice for importing participants

Your participant library is where almost everything downstream comes from. Reporting lines decide who can see which report. Demographics decide what you can filter and compare. A survey can only be as good as the list it was sent to. It is worth twenty minutes on the file before you upload it.

Before you build the file

Starting out? Start from your template. Download it from the Participant Library when you select Import. It already has a column for every demographic in your library, spelled the way your library spells them, so you are not guessing at headings.

Updating people who are already there? Start from your library instead. Export it with the Export button on the Participants page, make your changes in that file, and import it back. This is the better route for an update, because the file you upload already holds:

  • the exact spelling of every demographic option, so nothing is split in two
  • the ID of every participant, so everyone is matched rather than added again
  • every current value, so nothing is cleared by an empty cell you did not mean

Decide what this import is for. A full refresh of everybody is a different file from a handful of new starters. If you only want to update some people, a file containing only those people is safer than a full file you have edited.

Use an ID if you have one. A payroll or HR number identifies the same person across imports even when their name or email changes. Without one, the match is made on email or mobile, so somebody who changes both arrives as a new person.

The things that most often go wrong

Blank cells delete. This is the single most common surprise. An empty cell in a column that is present clears that value in your library. If you only want to update three columns, your file should have three columns, not twenty with seventeen left empty.

Leaving a column out is how you protect it. This is the opposite instinct to most systems, and it is worth saying to yourself once before every import.

Spell demographic values the way your library already spells them. Your template gives you the right column headings, but not the values inside them, so this is the one thing you have to bring yourself. It matters most with accents: "Māori" and "Maori" are two different options.

Include People Leader if you want automated report access. Reporting lines are built from that column, and automated report viewer permissions use them to work out which leader sees which report. Without it the import still succeeds, and you set report access up by hand instead.

Groups smaller than your reporting threshold cannot be reported on. If you have five people in a department and your threshold is five, that group is visible. Four and it is not. This is worth checking before a survey rather than after, because it changes how you should structure a demographic.

A sensible routine

  1. For a first import, download your template fresh. For an update, export your library and work in that file. Either way, start from something current: your demographics may have changed since last time.
  2. If you used the template, delete the example row.
  3. Delete any column you do not intend to change.
  4. Upload it and read the Check step properly, including the warnings. Warnings do not stop you, which is exactly why they get skipped.
  5. Download the full list if there are more than twenty rows to look at.
  6. On Review, check the numbers match what you expected. "840 participants will be added" on a file of 850 people you thought were already there means your IDs are not matching.
  7. Import, and look at the Done summary.

After the import

Read the Done step. It says what actually happened: how many participants were added, how many updated, how many kept because they were not in your file, and how many removed. That is the record of the import, and it is worth a look even when everything went to plan.

If your file changed People Leader, your reporting lines are rebuilt as part of the import, so the Org Hierarchy tab on the Participants page shows the new structure straight away. Open it and check the shape looks right, particularly at the top: one person with no leader above them is normal, three usually means a typo in an ID.

The Participants page shows the last bulk update and who ran it, so you can always see whether the library is as recent as you think. This do not indicate the manual changes you have done manually in the UI.

Correcting something small? Edit it straight in the library. One person's email or one wrong department is a double-click, and that is what the library is for.

For anything bigger, a column, a batch of people, a restructure, import again rather than working through the table.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact us Contact us