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”

Last updated