Skip to content

Wiki Data How to upload collection data

Jump to bottom
adamrmor edited this page Mar 26, 2018 · 3 revisions

To bulk upload data into WikiData we use the Quick Statments tool. This uses a simple set of text command to add, edit and remove data. The tool uses the format of "semantic triples" to import data:

subject predicate object

Which means

<this thing> <has some relationship to> <that thing>

For example…

Q33817 P27 Q664

In plain English

Edmund Hillary has a country of citizenship which is New Zealand.

Quick Statements (no longer supported)

Quick Statements V2

Quick Statements help guide

Each statement must consist of an item, a property, and a value. A value can be another item, a string, a time, a location, or a quantity, depending on the property type.

  • Items are always in the form Qxx.
  • Properties in the form Pxx.
  • Strings (including URLs, and numerical values of text fields, for example external-ID property values) must be in "double quotes".
  • Time values must be in format eg +1967-01-17T00:00:00Z/11, where /11 designates the precision. The precision is: 0 - billion years, 1 - hundred million years, ..., 6 - millennium, 7 - century, 8 - decade, 9 - year (default), 10 - month, 11 - day, 12 - hour, 13 - minute, 14 - second.

Format your CSV

  • Different parts of the statement are separated by a TAB character, or in QuickStatements version 2 may also by "|". Each command is on a new line, or in QuickStatements version 2 may also be separated by "||". Hint: You can also use a spreadsheet software such as Excel or LibreOffice Calc; copying/pasting the cells should automatically insert TABs.
  • The first row is a header describing how the columns are interpreted.
  • You can create new items by inserting a line consisting only of the word "CREATE". To add statements to the newly created item, use the word "LAST" instead of the Q number, and the statement will be added to the last created item.
  • An uppercase "S" followed by a property number (without "P") begins a new source for the current statement.
  • A lowercase "s" followed by a property number (without "P") adds another property-value pair to the current source.
  • A lowercase "qal" followed by a property number (without "P") adds a qualifier to the current statement.

Excel format

Property Subject/Value
Title (P1476) View in the Valley of the River Nairne, Chatham Islands, June 1840
inventory number (P217) Print H43(5)
collection (P195) Auckland War Memorial Museum (Q758657)
location (P276) Auckland War Memorial Museum (Q758657)
described at URL (P973) http://www.aucklandmuseum.com/collections-research/collections/record/am_library-paintinganddrawings-1124`
creator (P170) Charles Heaphy (Q1064767)
instance of (P31) sketchbook (Q60520)
Len (Label in English) Heaphy sketchbook no. 3
Den (Description in English) Artwork by Charles Heaphy (Auckland War Memorial Museum, PD-1952-2-3 )
height (P2048) 255 millimetre
width (P2049) 360 millimetre
Clone this wiki locally