Skip to content

Import answers that a file spreads across several columns

When you import responses from a CSV or Excel file, you can map several columns to one question and SurveyRock combines them into one answer. Files often lay out a multiple-choice, ranking or matrix question this way: one column per choice, one per item, or one per row.

Importing is for Editors and above. It is on every plan.

  1. Open the survey, go to the Respondent List, and click Import.

  2. Upload your .csv or .xlsx file. The first sheet is used, and the file can be up to 10 MB. A CSV can separate its columns with commas, semicolons or tabs, which SurveyRock reads from the header row, so a file saved by a European copy of Excel works as it is.

  3. In Map Columns, give each file column a target. For a question that your file spreads across several columns, pick the same question for each of those columns. Map the column that holds when each response came in to Start Time or Completion Time (see Dates in your file).

    The Map Columns step: four file columns, one per answer choice, each mapped to the same multiple-choice question, with the count of mapped columns above them.

  4. Check the Preview. It reads every row of the file the way the import will and says how many rows will import. For the rows that will be skipped, it lists the first 20 with the row number, the column and the reason, so you can fix the file before you import. Then import.

The dates in your file decide where each response lands in your trends and comparisons, so SurveyRock does not guess them.

  • Day first or month first. A date such as 03/04/2026 is 3 April in most of the world and March 4 in the US, and nothing in the cell says which. When a column you mapped to a date holds dates like that, Map Columns asks how your file writes them, and you can’t continue until you choose. If a date in the file can only be read one way, such as 13/04/2026, SurveyRock selects that order for you and you can change it. A date that doesn’t fit the order you chose is skipped, not turned into a different date. Dates that start with the year, such as 2026-03-04, and Excel date cells need no choice.
  • Start Time and Completion Time. If your file has only one of the two, that time is used for both. If you map neither, every response is dated the day you import, and Map Columns warns you before that happens.
Question type What each column holds Result
Multiple choice, image choice A filled cell, or a mark such as 1, x or yes, under a column named for the choice The choices that are filled or marked become the answer
Ranking The item’s position (1, 2, 3 …) The items are put in that order
Matrix Each column names a row, and its cell holds that row’s answer One answer per row

Any other question type still takes a single column. Mapping several columns to a text, rating or other question is refused, because there is no single right way to join two answers.

SurveyRock reads the header and the cells. It does not know any survey tool’s export by name, so a layout it has not seen can still work if it follows these rules.

  • The header must end with the choice name, or carry it inside [ ] or ( ). For example Q2 - Starters, Q2 [Starters] or just Starters.
  • A mark under a header that does not match a choice fails the row.
  • Ranking cells must be numbers. A tie or a non-numeric cell fails the row.
  • A dropdown matrix takes one column only. Map one column to it.
  • Marks that count as picked are 1, x, y, yes, true, selected, checked, and the tick and cross symbols ✓, ✔, ☑, ✗ and ✘. A cross counts as picked, so do not use ✗ to mean “no” in a file you import.

A row that cannot be combined is skipped, and the Preview lists it before you import, with the column names joined by “ + “, for example Q2 - Starters + Q2 - Mains. The rest of the file still imports, and the error report you can download afterwards lists every skipped row. Fix the cells it names and import those rows again.

  • Text or rating questions split across columns.
  • Constant Sum, Group & Rank and Side by Side questions.
  • Importing straight from SurveyMonkey, Google Forms or Qualtrics. Export a file from them and map its columns as above. Whether a particular export imports cleanly depends on its headers, so check the Preview first.