Skip to content

Problem: Unable to save to Excel file when performing Convert Responses action

Try changing the default Excel file format in the application preferences:
  1. Select Help in the SurveyGold application.
  2. Select Change Application Preferences.
  3. In the Features tab, locate the Microsoft Excel setting and change the default file format to .xlsx.
  4. Select OK to save your preference.
Try performing the Convert Responses action again. If it doesn't work, try repeating the process and changing the default file format to .xls to see if this helps.

Occasionally, Excel has issues converting online survey responses into Excel format because the respondent pasted/entered unprintable characters into the online survey form response field. While the online survey form has no issue processing those characters, Excel is less forgiving.

One way to try to resolve this is to do the following:
  1. In Analyze Results, perform the Convert Responses action and select the Text data format. Make a note of where you save the file.
  2. Then, open Excel and perform the File-->Open action. Change the file type from "All Excel Files" to "Text Files" in the bottom right-hand side of the Open dialog. Then navigate to the folder to open the file you created in step 1.

Feedback and Knowledge Base