How to fix "unreadable contents" in the analytics CSV export

The analytic exports for spaces and desks can be downloaded as a CSV file from the Robin dashboard. However, if your data includes "non-latin language" you may experience an encoding problem when trying to open & view the CSV export.  For the most common spreadsheet clients, like Excel, you may see a warning message that says "unreadable contents" or the data may appear garbled, making it difficult to read and analyze the report.   

This can be fixed in a few simple steps by importing CSV files in spreadsheet apps.  This guide outlines how to import a file using the "Text import wizard" in Excel. Other spreadsheet clients should work similarly. 

1
Open Excel and open the File menu in the top tool bar, select Import
Screen_Shot_2020-04-02_at_15.02.55Excel_mport_export.png
2
Select the CSV file option as the type of file you want to import and select import. 

Screen_Shot_2020-04-02_at_15.03.03Excel_mport_export.png

3
Select the CSV export from your saved files.

Screen_Shot_2020-04-02_at_15.04.36Excel_mport_export.png

4
Now follow the prompted steps from the "Text import wizard".
- Choose the Data type that best describes your data: select Delimited.
- Select the File Origin: Unicode (UTF-8)
Click next. 
import_wizard_step_1.png
5
Set the delimiters your data contains, select the Comma option. Click next

import_wizard_step_2.png

6
Select the column data format to general. Click finish.
import_wizard-_step_3.png
Did this article help?