Skip to content

Importing rating items

Bring items in three ways, type them one at a time in the Ratings tab, paste rows as text, or upload a spreadsheet.

Spreadsheet upload (CSV or XLSX)

The bulk-import dialog accepts a CSV or Excel file. The first row is treated as headers.

Reserved headers

Columns named Title, Body, External ID, or Skip (in any casing) map to the built-in item columns rather than becoming data fields. External ID is yours for cross-referencing items with outside datasets.

Everything else extends the schema

Any other header becomes an item data field. If a field with that name already exists in the rating task's schema, values flow into it, if not, the import adds the field to the schema, additively and without ever modifying or removing fields you already have. Header names are normalized into clean field names (lowercased, punctuation collapsed), empty headers become indexed column names rather than being dropped, and duplicate names get numeric suffixes so no column silently collides with another.

Preview before commit

The import shows a preview first, the parsed headers, how each maps to existing or new fields, which schema fields would be added, and the first rows of data. Nothing changes until you confirm. This matters because schema additions are permanent from the import's perspective, review the field list before committing.

Files referenced by items

If your items reference images, upload the images to Assets and put their URLs or asset references in an item field your display template renders. Spreadsheets imported through Assets are recorded as used by the surveys that imported them, so the Assets page can always tell you where a file's data went.

After importing

Items appear in the Ratings tab list, where each can be edited, skipped, or deleted individually. Imports can be repeated, subsequent files only add fields that are genuinely new.