How to format your Form Response export

Having trouble getting your Excel sheet to display your language in the correct format? Try this:

1. Download the responses as a CSV file instead of XLS. 
2. Open Excel and click File > Import, and then select the CSV file you've downloaded.
3. Select Delimited and select a File Origin that makes the text legible to you (you might have to try a few of these).
4. Click next and click Comma as the separator.
5. Finish and add to your sheet.

Note: If the responses to any of your form questions start with a 0, Excel might try to remove the 0 from the data. To prevent this from happening, please follow these steps:

1. Open Excel and click File > Import 
2. Select CSV File in the first panel 
3. Select Delimited in the next panel 
4. Make sure Comma is checked in the next panel 
5. In the final panel, navigate to the column for which you are having this issue and click it. Then click Text under column data format. 
6. Click finish and the data should be added correctly.