Follow

How to Format Data for Uploading

To ensure that your data will 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.

Open Office Method

* You can download Open Office for free here.

  • Row 1 is your column header for the subsequent rows

Fig. 1: Column Headers shown in Row 1

  1. File – Save As

Save As

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

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

  1. Click “Keep Current Format”

Fig. 4: Keep Current (CSV) Format

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

Fig. 5: UTF-8 Selection

Google Docs Method

  1. Save your Excel file in something other than a CSV and upload it to Google Docs. Be sure to have it “convert to into the corresponding Google Docs format”

Fig. 6: Upload and Save file to Google Docs

  1. Download your file as a CSV

Fig. 7: Download as CSV

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

 


Was this article helpful?
6 out of 9 found this helpful


Have more questions? Submit a request
Powered by Zendesk