ProcedureScreenshot


If you’re having issues with your downloaded data (e.g., appearing incorrectly formatted and is difficult to read), it may be due to how the file delimiters are formatted.

There are two options to resolve this issue:

  • Using Google Sheets to change the file format. This option can also be used if special characters are not downloading correctly (for example, 是 or ñ).
  • Using Excel to change the delimiter value (helpful if you don’t have access to Google Sheets).

 First solution: TO CHANGE THE FILE FORMAT WITH GOOGLE SHEETS

 

  1. Download your CSV file from Qualtrics.
  2. Open the CSV file in Google Sheets.
  3. Save your file in Google Sheets as an XLS file.
  4. Download the file to your computer and proceed as normal in Excel.
 

 Second solution: TO CHANGE THE DELIMITER IN EXCEL

 

  1. Download your CSV file from Qualtrics.
  2. Open the file in Excel.
  3. Select all the data in the spreadsheet.
  4. Select the Data tab.
 

 5. Click Text to Columns.

 

 

6. Click Next

7. Change the delimiter value to the value that is being used in the Excel document (e.g., the data he

8. Click Finish and then continue working with your file as normal.