- MROCs
- Online Qual Projects
- Open Ended Responses
- Interview Notes
Formatting your xlsx files
Double check the list of supported formats before you spend time editing your xlsx data! We support a number of providers out of the box.

Upload your xlsx files
ClickProcess community data
to select which columns to import from your xlsx file.

Choosing which sheets / columns to import
Please note at this point we only support free text answers. Multimedia participant responses (audio, video and image) are only available for Recollective and Incling projects.

Importing segments and tags
Tick the box next to any columns that contain segment information to automatically apply these as segments to your participants

Speaker merging
Speakers with the same name in different Excel sheets will be merged together make sure these are consistent if your data is spread across multiple sheets.
Examples of common formatting problems
The first row in the spreadsheet must corredpond to the column titles and be followed immediately by participant responses. Any other rows or columns e.g. Task numbers need to be deleted. The task description / stimulus or question will be used for context so these need to be merged into the column header.Task numbers in the top row


Metadata or descriptions in the spreadsheet


Question / prompt and its description spread across 2 rows

