Importing Data with CSV and TSV Files

Enjoy the convenience of working with spreadsheet data.

You can upload your text directly from a .csv (comma separated values) or .tsv (tab separated values) file. This means you can work with your favorite spreadsheet software or text editor when preparing your data for upload. This can be especially useful when you want to upload inputs and concepts at the same time. Just use the provided "CSV template" to get started.

CSV templates

To help you get started, you can download .csv templates for images and text uploads here:

Image Upload Template Text Upload Template

Working with your CSV file

At a minimum, you should add and image URL or text to the input.data.image.url or input.data.text.raw field respectively. You can add one concept per column to the input.data.concepts[*].id fields. For the input.data.concepts[*].value column, there are two options: enter the number 1 if the concept is present in the input, enter the value 0 if the concept is not present in the input (a negative example). If no value is entered, a default value of 1 will be assigned to your input.

You can add columns for as many concepts as you like, and you can add new columns to add values for any other values supported by the API:

Field	Description
input.id	A unique identifier for your input
input.data.image.url	The URL (web address) for your input
input.data.text.raw	The "text" for your input
input.data.concepts[i].id	Your custom concept
input.data.concepts[i].value	The value for your custom concept (1 for true, 0 for false)
input.metadata	Any additional metadata in valid JSON format
input.data.geo.geo_point.latitude	Latitude for geodata
input.data.geo.geo_point.longitude	Longitude for geodata

Finally, you will need to save your work as a .csv file. If you are editing in Google Sheets, go to File >>> Download >>> Comma-separated values (.csv, current sheet). If you are using Excel, go to File >>> Save As >>> Browse >>> Save as Type >>> CSV.

Once you have downloaded the .csv file, you can then upload it by clicking on “Browse files”