Skip to main content

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:

Working with your CSV file

At a minimum, you should add an image URL or text to the or field respectively. You can add one concept per column to the[*].id fields. For the[*].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:

input.idA unique identifier for your input URL (web address) for your input "text" for your input[i].idYour custom concept[i].valueThe value for your custom concept (1 for true, 0 for false) additional metadata in valid JSON format for geodata 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”