From QualtricsWiki

Items you will need

1. A survey in your account to import into (it is best if it is identical to the survey you are getting the data from).
2. Example Response Import file.
   • Go to View Results -> Responses (for the survey you will import into).
   • Click the Advanced Options drop-down menu and then select Import Responses.
     • Then click the Example Document button to get the Example Response Import File (save to your computer).
3. Make sure you have your data file available and ready for import (containing the original data).
   • In Qualtrics, get the data file by going to View Results -> Download Data and downloading the CSV file for the survey currently containing the data. Make sure you download answers as values rather then labels.
   • In other survey systems, follow directions for downloading survey data from the results area. The data needs to be in CSV (Comma Separated Values) format, which is a “.csv” file extension.

Process

1. Open the Example Response Import file and the data file in separate Microsoft Excel windows, or an equivalent spreadsheet program.
2. Using the Example Response Import file as your template, make sure your data file's columns match up to the Example Response Import file's columns.
   • Remove the first six columns (columns A-F) from the data file, as well as the Finished column (originally column I before changes).
   • You'll notice the Example Response Import file starts at the Start Time column. Response IDs will change upon import, while Response Sets, Names, External Data References, and Email Addresses cannot be imported. #**If you want to keep any of this data, add an Embedded Data item into the destination survey's survey flow for each item of data you're saving. You will then need to re-download the Example Response Import file, as it will now contain columns for importing the embedded data fields.
   • Note: If the survey you get the data from is equivalent to the one you are importing the data into, then after you remove the columns mentioned above, you can just copy and paste the row headers from the Example Response Import file (the first two rows) over the first two rows of your data file.
   • Make sure you save your data file with the changes you have made. It must have the “.csv” file extension.
3. Import your data into the survey.
   1. For the survey you're importing into, go to View Results -> Responses page.
   2. Click the Advanced Options drop-down menu and select Import Responses.
   3. Using the Browse button, find the data file on your computer.
   4. Once the file is selected, it will work to interpret the file and determine how many responses you are importing.
      • If the file is not interpreted or parsed correctly the first time, click "Import Options" and select a different Delimiter.
        • If not using one of the provided delimiters, click into the Delimiter text box and type the symbol of the delimiter being used.
        • 
   • If the number of responses shown does not match the number you have in your data file, then do not click the Import button. It will not import correctly and you will need to Delete the bad data from the Edit Results section.
   • Try deleting the contents of the first row (the one that contains the question text), but leave the row itself there. Try importing again.
     • A CSV file is a text file, and your question text in the first header row could be causing problems with the import because of all the characters possible from the question text.
4. Click Import.