Troubleshooting Responses in CSV files

Troubleshooting Responses in CSV files

If the CSV downloaded has responses in different languages other than English, and those languages use special characters (French, Hebrew, etc.), this might display an issue when trying to open the CSV in Excel if this issue is presented. We recommend uploading the CSV file in Google Drive and open this file in Google Sheets.



Once the CSV is uploaded and opened in Google Sheets, the information should be displayed correctly. If the corrected file is still needed to be open in Excel, the solution is to download it from Google sheets in a .xlsx format, follow the steps below to download from Google Sheets:
 

Step 1:

Click on File.
 

Step 2: 

Click on Download.
 

Step 3:

Click on "Microsoft Excel .xlsx"

    • Related Articles

    • Exporting Responses

      A CSV file can be exported and sent to your preferred email by following the steps below:   Step 1: Go to Analytics in the survey or funnel that you want to export the responses already collected. Step 2: Once you entered in the Analytics section, ...
    • Export Responses using Safari

      A CSV file can be exported in Safari and sent to your preferred email by following the steps below:  Step 1: Go to Analytics in the survey or funnel that needs exported. Step 2: Click the Responses tab.  Step 3: In the Responses tab, click on "Export ...
    • Reading Responses

      To read responses please follow these steps.   Step 1: Click "Analytics" from the quiz cart.   Step 2: Click the Responses tab. Step 3: You can search for a particular answer or review them all.  
    • Troubleshooting Zapier Integration Issues

      The Top 3 Issues you may face: Zapier is unable to find your Segmentation Funnel or Discovery Survey.  Unable to Distinguish Between Zaps Data sent is not immediately available in your Email Service Provider portal 1. Zapier is unable to find your ...
    • Manually Input Responses

      Follow the steps below to manually input responses of your audience. Step 1: Copy your survey link and open it in a new tab in your browser.   Step 2: Go through your survey answering the questions, contact information, etc.   Step 3: Refresh the ...