Download the CSV template to get started

With the CSV import tool, it is possible to import papers in bulk to the ORKG. After uploading the CSV file, you will be able to see how to data will be imported (in step 3). Before starting the actual import it is possible to first preview the data to ensure it is read and formatted correctly.

After importing a CSV file, it is possible to create a comparison using the imported papers.

Formatting rules

The extracted table should be formatted in such a way that it adheres to the following rules:

1. First row labels. Only the first row should contain the header labels (transpose the table if necessary, reformat the table if necessary)
2. One paper per row. Each row should contain a single paper. It is not possible to use multiple rows to describe the same paper. Merge information in the same cells if necessary
3. Special cell values. By default each cell value is considered a literal. It is possible to prepend resource: to a cell value to create a resource instead. Also, it is possible to use an existing ORKG resource. Use as cell value orkg: followed by the resource ID to do this (e.g. orkg:R100). See the CSV example below for more details.

Header labels

Some predefined column labels are used to correctly add paper related data. The column labels are case sensitive.

Required columns

• paper:title Title of the paper -- or -- paper:doi DOI of the paper (the values for 'paper:title' are ignored is a resolvable DOI is provided)

Optional columns

• paper:authors Paper authors, separated by a semicolon (e.g., Author 1; Author 2)
• paper:publication_month Numeric value of the publication month (e.g., 6 for June)
• paper:publication_year Numeric value of the publication year (e.g., 2020)
• paper:research_field Research field ID (e.g., R11 for the most general field: 'Research field'). Only existing fields can be used: view fields. Click on a field to find out it's ID.
• paper:doi The DOI of the paper (e.g. 10.1145/3360901.3364435)
• paper:url The URL of the paper (in case no DOI is provided, the URL is displayed instead)
• paper:published_in The venue of the paper
• contribution:research_problem A research problem (e.g., Graph visualization)

Other columns

Additional paper data can be added in additional columns to the CSV. The label of the column will be used as predicate in the ORKG. Also it is possible to use existing ORKG properties, by prefixing the property ID with orkg: For example orkg:P100

Data types

Literal values are automatically parsed to assign an appropriate data type to the value. You can overwrite the automatic parsing by manually providing a data type. This can done both in the cell and header. Data types in cells have priority over data types in headers (i.e. the header data type is ignored when a cell data type is provided). Data types are assigned as follows:

• In cell: 213<integer>
• In header: Number of participants<integer>
• Automatic: http://google.com (considered a <url> automatically)

List of data types

• <text>
• <decimal>
• <integer>
• <boolean>
• <date>
• <url>

Data types always have to be appended to the value. Also make sure there are no trailing white spaces are the data type specification.

*In this example, Location property in the second paper will take two values (Hannover and Dresden)*