Survey Exports in Non-English Languages

This article will provide a step-by-step guide of how to see the real characters that can be substituted by other characters on survey exports.

 

Having issues with your survey export where you are seeing characters that aren't part of the language your survey answers are written in? Not a problem, it is very quick and easy to fix. 

We export in Unicode but excel struggles to recognise that on default settings. Languages like Arabic contain a text direction specifier for right-to-left text, excel gets confused so here are the steps to change it:

  1. Export the survey answers csv and save it somewhere on your device
  2. Make a blank spreadsheet
  3. Go to "Data" tab and find "From text"
  4. Select the survey file
  5. Select "Delimited"
  6. on File origin, select "Unicode (UTF-8)"
  7. Click "next" and untick "Tab" and tick "Comma"
  8. Click "next" then click "finish"

This will then enable you to see the text how it was sent by your learners.