CSV to QuickStatements

This tool converts a properly formated CSV file into a series of commands you can pass to the QuickStatements tool for Wikidata.

[Click to show/hide HOWTO]


You can find a sample CSV file here.

The order of the columns must be as follow:

  • qid
  • Sources, prefixed with "S" instead of "P" (for example, the label of the column for "P143 (imported from)" must start with "S143")
  • Labels, descriptions, aliases, prefixed with "L(lang), d(lang), A(lang)... You can put several aliases for one language, separated by "|".
  • Properties
  • Qualifiers, prefixed with "qal" instead of "P".
  • Site links, prefixed with "S(lang)"


  • For most columns titles and values, you can add human-readable comments after a "|", if it helps (see the sample file.)
  • If you create your csv from a SPARQL query, you can leave the full URL for Qids, this tool will remove them (ie, "http://www.wikidata.org/entity/Q1" will be interpreted as "Q1")
  • The tool performs some basic dates conversions, assuming the precision is the correct one (ie, "-4" will be interpreted as year 4 BCE or -0004-00-00T00:00:00Z/9, "+43-03" as March of year 43 CE (+0043-03-00T00:00:00Z/10) and "2005-03-15" as the 15 of March, 2015 (+2005-03-15T00:00:00Z/11))

Upload CSV file

Download sample CSV