Survey Platform - Import Responses | Qualtrics

Import Responses

Introduction

You can use the Import Data option in the Data & Analysis module to combine responses from two identical surveys, re-upload edited data, or bring in your own data.

Preparing Your Survey

Before importing, you’ll first need a survey to import your data to. Your survey’s format and your data file format must match exactly. This can be achieved using one of these three options:

  • The survey you downloaded the data from
  • A copy of the survey you downloaded the data from
  • A survey identical to the one that collected the data you are importing.

Preparing Your Data

You will need to make sure your data file is ready for import. Your data needs to be in a format Qualtrics will understand, and it needs to exactly match the format of the survey you’re importing the data into.

There are two methods you can use to ensure your data is in the correct format:

  • Export the Example CSV Qualtrics provides for your survey, and input your data into that file (best if you want to import brand new responses)
  • Export your existing data as a CSV (best if you want to edit existing data)

With either method, the download will be in the correct format and you can enter or adjust data as necessary.

To export and edit the Example CSV

  1. Navigate to the Data tab of the Data & Analysis module and select Import Data from the Tools dropdown.image01
  2. Click Example CSV.image07
  3. Open the downloaded CSV file in Excel and input/paste your new data into the appropriate cells.image11
    Qtip: You can delete any columns in the example file that you don’t need, but be careful when adding new ones. When importing, Qualtrics will skip columns that don’t correctly align with questions or Embedded Data in your survey.
  4. Save the file as a CSV.

Once your data file is prepared, you can import it into a survey in your account.

Qtip: You can also use a Qualtrics exported data file from a survey as your import file.

To export and edit existing data

To export an existing data file, just follow the steps on our Exporting Responses page. Once you have the CSV downloaded and open in Excel, you can edit individual cells as needed.

image07

Qtip:You can delete any columns in the example file that you don’t need, but be careful when adding new ones. When importing, Qualtrics will skip columns that don’t correctly align with questions of Embedded Data in your survey.

Once your data file is prepared, you can import it into a survey in your account. Note that for importing altered responses, we recommend importing them into a copy of the original survey. If they are imported into the existing survey, you will have the original responses and the adjusted ones together in the dataset (i.e., duplicates).

Importing Your Responses

  1. Navigate to the Data tab of the Data & Analysis module and select Import Data from the Tools dropdown.image00
  2. Click Browse and select your CSV file.image01
  3. Verify that the data columns have been imported correctly.image17
  4. If desired or necessary, click More Options to access Delimiter, Enclosure, and other settings.image13
    Qtip: If the data is not formatted correctly in the preview (e.g., bunched up instead of divided into columns), your data may not be separating (or “delimiting”) correctly. To fix, choose a different Delimiter.
  5. Check that the number of responses verified is the number of responses in your CSV file.image10
    Warning: If the number of responses shown does not match the number you have in your CSV file, then do not click Import Responses. If you do, the responses will not import correctly and you will need to delete the invalid data.
  6. Click Import Responses.image16

Once the data is imported, a notice will appear detailing the number of successfully imported responses and any columns and rows that were skipped.

Qtip: Export Data files include columns that will always be skipped on import. These are responseID, responseSetID, status, recipient info fields (contact list First Name, Last Name, Email, etc.), and location fields (Longitude, Latitude, Accuracy). It is not possible to set these fields for imported responses, but if you want similar data, you can add Embedded Data fields and include your data there.

image09

More Information

  • If you are not using one of the provided Delimiters in the More Options menu, you can click into the Delimiter text box and type the symbol of the delimiter being used.image14
  • If your file is not importing, it could be due to validation in your survey. To ignore validation while importing, select More Options and click the Do not validate checkbox.image12