Creating a TSV file with tasks

Tasks are uploaded to the pool in the TSV file. TSV (tab-separated values) is a text file format in which data is separated by a tab, and lines are separated by a newline symbol.

Download a sample file for your project by clicking File example for task uploading (tsv) on the pool page.

If you need to upload different task types to a pool, upload multiple TSV files, each file containing a different task type.

  1. Structure of the TSV file
  2. Working with the TSV file
  3. Escaping strings
  4. Escaping data in JSON format
  5. Escaping the JSON array data

Structure of the TSV file

The first line of the file contains the column headers:

  • INPUT:<name of the input data field> — Input data for tasks.

  • GOLDEN:<name of the output data field> — Responses for control tasks.

  • HINT:text — Hints for training tasks.

  • Point coordinates for field surveys:

    • Al:latitude — Latitude.

    • Al:longitude — Longitude.

Task type depends on which fields are filled in:

To create a main task, fill in the columns with the INPUT header.

Example with a simple object (string, link, and so on)
Example with a string array

The columns with required input data fields must be filled. The other columns can be deleted if they are empty.

Working with the TSV file

Popular spreadsheet editors allow you to import and export data in TSV format:

You can work with data in a spreadsheet and then save it to the desired format.
  1. Create a spreadsheet with the appropriate headings or copy them from the TSV file example.
  2. Add data for tasks.
  3. Copy the entire table and paste it into a simple text editor (such as Notepad in Windows or TextEdit in Mac).
  4. Save the file in UTF-8 encoding with the tsv extension.

The maximum file size is 100 MB.

Escaping strings

To include multiple paragraphs or tab characters in the string type field:
  • Add another quotation mark to each quotation mark of the " type in the text data.

    Don't escape other quotation marks (« » and “ ”).

  • Enclose the field in quotation marks " ".

Unescaped quotation marks are removed when processing the TSV file.

Escaping examples
Input data Result
"Task in ""Toloka"""

Task in "Toloka"
"Task in «Toloka»"

Task in «Toloka»
Input data Result
"Task in ""Toloka"""

Task in "Toloka"
"Task in «Toloka»"

Task in «Toloka»

Escaping data in JSON format

To load data in a field with the json type:

  1. Add another quotation mark to each " type of quotation mark in the JSON object.

  2. Enclose the field in quotation marks " ".

Escaping examples
Input data Result 
"[{""type"":""polygon"",""data"":[{""x"":0.24173,""y"":0.25118},{""x"":0.31327,""y"":0.24896},{""x"":0.31327,""y"":0.32453},{""x"":0.27576,""y"":0.34898},{""x"":0.23061,""y"":0.32564}]}]"
 
[{"type":"polygon","data":[{"x":0.24173,"y":0.25118},{"x":0.31327,"y":0.24896},{"x":0.31327,"y":0.32453},{"x":0.27576,"y":0.34898},{"x":0.23061,"y":0.32564}]}]
Input data Result 
"[{""type"":""polygon"",""data"":[{""x"":0.24173,""y"":0.25118},{""x"":0.31327,""y"":0.24896},{""x"":0.31327,""y"":0.32453},{""x"":0.27576,""y"":0.34898},{""x"":0.23061,""y"":0.32564}]}]"
 
[{"type":"polygon","data":[{"x":0.24173,"y":0.25118},{"x":0.31327,"y":0.24896},{"x":0.31327,"y":0.32453},{"x":0.27576,"y":0.34898},{"x":0.23061,"y":0.32564}]}]

Escaping the JSON array data

To load data in a field with the json type:

  1. Add another quotation mark to each " type of quotation mark in the JSON object.

  2. Inside the object, add \ before the comma.

  3. Enclose the field in quotation marks " ".

Escaping examples
Input data Result 
"{""url"":""https://fotki-kotikov.ru/1""\,""img"":""https://fotki-kotikov.ru/cat1.jpg""\,""description"":""Just fat cats\, because nothing can be more beautiful.""\,""title"":""Fat cats""},{""url"":""https://fotki-kotikov.ru/2""\,""img"":""https://fotki-kotikov.ru/cat2.jpg""\,""description"":""Just red cats\, as everyone knows\, that red cats bring money.""\,""title"":""Red cats""},{""url"":""https://fotki-kotikov.ru/3""\,""img"":""https://fotki-kotikov.ru/cat3.jpg""\,""description"":""Yes\, it will be just sleeping cats""\,""title"":""Sleeping cats""}"
 
{"url":"https://fotki-kotikov.ru/1", "img":"https://fotki-kotikov.ru/cat1.jpg", "description": "Just fat cats, because nothing can be more beautiful.", "title": "Fat cats"},{"url":"https://fotki-kotikov.ru/2","img":"https://fotki-kotikov.ru/cat2.jpg","description":"Just red cats, as everyone knows that red cats bring money.", "title": "Red cats"},{"url":"https://fotki-kotikov.ru/3","img":"https://fotki-kotikov.ru/cat3.jpg","description":"Yes, it will be just sleeping cats", "title": "Sleeping cats"}
Input data Result 
"{""url"":""https://fotki-kotikov.ru/1""\,""img"":""https://fotki-kotikov.ru/cat1.jpg""\,""description"":""Just fat cats\, because nothing can be more beautiful.""\,""title"":""Fat cats""},{""url"":""https://fotki-kotikov.ru/2""\,""img"":""https://fotki-kotikov.ru/cat2.jpg""\,""description"":""Just red cats\, as everyone knows\, that red cats bring money.""\,""title"":""Red cats""},{""url"":""https://fotki-kotikov.ru/3""\,""img"":""https://fotki-kotikov.ru/cat3.jpg""\,""description"":""Yes\, it will be just sleeping cats""\,""title"":""Sleeping cats""}"
 
{"url":"https://fotki-kotikov.ru/1", "img":"https://fotki-kotikov.ru/cat1.jpg", "description": "Just fat cats, because nothing can be more beautiful.", "title": "Fat cats"},{"url":"https://fotki-kotikov.ru/2","img":"https://fotki-kotikov.ru/cat2.jpg","description":"Just red cats, as everyone knows that red cats bring money.", "title": "Red cats"},{"url":"https://fotki-kotikov.ru/3","img":"https://fotki-kotikov.ru/cat3.jpg","description":"Yes, it will be just sleeping cats", "title": "Sleeping cats"}