Follow

How to Format Data for Uploading

To ensure that your data will successfully upload to the platform, it's a best practice to upload a UTF-8 encoded CSV. Microsoft Excel does not easily allow you to save with UTF-8 encoding but this article describes how to save your dataset properly using Apache Open Office* or Google Docs. If you work in TSV, please apply the same practices but change your separator.

Libre Office Method

* You can download Libre Office for free here.

  • Row 1 is your column header for the subsequent rows.
  • All columns must have a valid column header with alphanumeric characters in order to upload successfully.

Screen_Shot_2019-10-01_at_4.16.08_PM.png

Fig. 1: Column Headers shown in Row 1

  1. File – Save As

Screen_Shot_2019-10-01_at_4.16.47_PM.png

Fig. 2: Save As

  1. File type: Text CSV (.csv)
  2. Enable “Edit filter settings”
  3. Click Save

 

Fig. 3: File Type, Edit Filter Settings, Save

  1. Confirm File Format by clicking "Use Text CSV Format"

Screen_Shot_2019-10-09_at_1.14.39_PM.png

Fig. 4: Confirm File (CSV) Format

  1. Select Character set - “Unicode (UTF-8)”
  2. Click OK

Screen_Shot_2019-10-09_at_1.18.03_PM.png

Fig. 5: UTF-8 Selection

That's it! Once your data is saved as a UTF-8 encoded CSV with valid column headers for each column, you can upload the data to your job in the Upload Data page.

 


Was this article helpful?
8 out of 12 found this helpful


Have more questions? Submit a request
Powered by Zendesk