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.
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)"
Tips:
- 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))