QuickStatements 3.0/Documentation

QuickStatements 3.0Software collaboration for Wikidata

About Survey User storiesDocumentation Talk page

QuickStatements (QS) is a tool, written by Magnus Manske, that can edit Wikidata items based on a simple set of text commands. The tool can add and remove statements, labels, descriptions and aliases; as well as add statements with optional qualifiers and sources. The command sequence can be typed in the import window or created in a spreadsheet or text editor and pasted in. It can also be created by external code like Lua, called from a template and passed as a URL. Data edited in OpenRefine can also be exported to the QuickStatements format

How to use Quickstatements

Here is how to use QuickStatements (version 3) in basic mode:

Go to QuickStatements.
Make sure you are logged into OAuth and your name is visible in the upper-right corner. If not, then log in.
Click "New batch".
Cut and paste your commands. See the syntax in the section below. The tool will convert your commands into human-readable form.
Click the drop-down menu to select "V1" or "CSV" command syntax.
You have the option to block the Batch if a command fails
In Quickstatements 3.0, multiple commands aimed at the same Item are grouped together and executed in a single API call. Users have the option to disable this feature when executing commands by toggling on the " Do not combine commands" option.
Click create to preview the commands. Inspect them and click "save and run batch" to execute.
As your commands are being processed, double-check the results, and click "Stop execution" if you detect a problem.
Toggle between "SHOWING ALL" and "SHOWING ONLY ERRORS" to inspect the results.
The user interface will tell you when all commands have been processed.
You can search for details of a batch using the Batch ID.
You can search for all batches run by a user using their Username.
After successfully executing batch commands, you can download a report of the batch

Quickstatements3.0 in use

V1 Command Sequence Syntax

This section describes syntax used since V1 version of the tool, sometimes referred to as V1 commands.

Each statement MUST be structured with three components: an entity, a property, and a value.

Entity: This is the subject of the statement and can be an item, a property, a lexeme, a form, or a sense. For example, the entity of a statement could be an item: "Earth".

Properties: This describes a characteristic or attribute of the entity. For instance, if the entity of a statement is an item: "Earth", the properties might be include its human population, highest point, shape etc.

Values: Value provides the specific detail related to the property. it can be another entity, a string, a time, a location, or a quantity, depending on the property type. Special values like somevalue or novalue can also be used for unknown or no values. For the example above the property "highest point" will have the value "Mount Everest".

Defining The Data Elements:

Items: Represented in the form Qxx. For example, Q4115189 refers to a specific item on Wikidata. On Commons they are represented in the form Mxx. In QuickStatements version 1 one could use an article name instead of the q-code, if one filled in a xxwiki value in the input box above the text area; the correct item number (if available) was retrieved automatically.

Properties: Represented in the form Pxx. For example, P31 is a property indicating "instance of."

Values: : Values come in different forms and depend on the property type. They can be items, strings, times, locations, or quantities

How to CREATE STATEMENTS using the V1 command syntax

To create statements using the specified format, you can follow these steps:

Statements can be specified by typing into directly into the tools text area. Different parts of the statement are separated by a TAB or "|" characters.
You can also use a spreadsheet software like Microsoft Excel or LibreOffice Calc to achieve this. :*Enter your data into the cells, with each column representing one part of the statement. When your data is organized, copy and paste the cells into the tool's text area, the spreadsheet software will automatically insert TABs between the columns.
You can also use a text editor like Notepad++, it allow replacement of any symbol by the TAB character (\t).
Each command for different statements are placed on a new line or separated by "||" characters.

Note: In this documentation, please note that the Q values (e.g., Q237888, Q237893 etc.) and properties (e.g., P342) used are not accurate for the real Wikidata environment. They are only applicable to the test Wikidata environment. Users must identify the correct Q and P values that are valid in the actual Wikidata environment.

Add a Simple Statement

Example:

Q237888 | P342 | Q199378

Meaning: Add to Zoe Pantoliminion(Q237888), a Place of Birth(P342) London(Q199378).

Add simple statement using Quickstatements3.0

Add Statements with Strings

Strings should be enclosed in "double quotes." Many statements use string values, including URLs, media (such as images, videos, and signatures), page names (e.g., Commons category), and external-ID properties (e.g., VIAF ID).

Note: The media must be uploaded to wiki commons.

Q237893	| P31 | "https://www.michaeljackson.com/"
Q237893	| P137 | "126733"
Q237893	| P109 | "Michael Jackson"
Q237893	| P185 |"Michael Jackson 1988.jpg"

Add Statements with Strings

Adding Labels, Aliases, Descriptions and Sitelinks

Each command must consist of an item, a command, and a string in double quotes.

Labels

To add a label in a specific language to an item, use "Lxx" instead of a property, with "xx" as the language code.

Example:

Q109795 | Len | "Lion Club"

Meaning: add English label "Lion Club" to item (Q340122)

Alias

To add an alias in a specific language to an item, use "Axx" instead of a property, with "xx" as the language code.

Example:

Q109795 | Afr | "Club des Lions"

Q109795 | Aen | "Leo Club"|"Panthera Club"|"Pride Club"

Meaning: add French alias "Club des Lions" to item Lion Club (Q109795) and multiple English aliases to said item.

Tip: Multiple aliases can be added at the same time by separating them with the pipe character ("|"). e.g "Leo Club"|"Panthera Club"|"Pride Club"

Descriptions

To add a description in a specific language to an item, use "Dxx" instead of a property, with "xx" as the language code.

Example:

Q109795 | Dfr | "Hommes du Lion"

Q109795 | Den | "Men of Lion"

Meaning: add English and German description to Lion Club (Q109795).

Sitelinks

To add the sitelink of a specific page to an item, use "Sxxx" instead of a property, with "xxx" as the site. Ensure that the site code corresponds to the correct Wikimedia project (e.g., enwiki for English Wikipedia) and that the sitelink title matches the exact page title on that site.

Example:

Q109795 | Senwiki | "The Lion Men""

Meaning: add sitelink to the English Wikipedia page titled "The Lion Men" to the Lion Club (Q109795).

Add Statement with Labels Descriptions, Alias and Sitelinks

Add a Statement with Time

Time values must follow this format: +1967-01-17T00:00:00Z/11, where /11 specifies the precision of the date. (i.e to the year, month, date etc.) The precision levels are: 0: Billion years, 1: Hundred million years, 2: Ten million years, 3: Million years, 4: Hundred thousand years, 5: Ten thousand years, 6: Millennium, 7: Century, 8: Decade, 9: Year (default), 10: Month, 11: Day, 12: Hour, 13: Minute, 14: Second.

Example:

Q237888 | P18 | +1990-00-00T00:00:00Z/9

Meaning: Add to Zoe Pantoliminion(Q237888) Date of Birth(P18) 1989.

Add Statement with Time

Use "+" for CE dates and "-" for BCE dates; and use at least 4 digits. Set an additional "/J" if you want to set the date in Julian Calendar.

Example:

Q238086 | P18 | -0500-05-00T00:00:00Z/10/J

Meaning: Add to test item(Q238086), Date of Birth(P18) 540BCE in the Julian Calendar.

Add Statement with Time set in BCE and in Julian Calendar

If submitting to the API, use "%09" instead of the TAB symbol, "%2B" instead of the "+" symbol, "%3A" instead of the ":" symbol, and "%2F" instead of the "/" symbol.

Add a Statement with Monolingual text

To add monolingual text, prefix the text in "double quotes" with the language code followed by a colon. For example, en:"Some text".

Example:

Q229663 | P98808 | es:"La Pulga"

Meaning: Add to Lionel Messi(Q229663) the nickname(P98808) La Pulga(spanish).

Add Statement with Monolingual Text

Add a Statement with Location Coordinates

Location coordinates must be in the form of @LAT/LON, where LAT and LON are decimal numbers representing latitude and longitude, respectively.

Example:

Q194159 | P125 | @-33.903469/18.411102

Meaning: Add to Cape Town stadium(Q194159), Location(P125) Green point(Q238087).

Add Statement with Location Coordinates

Add a Statement with Quantity

Quantity is used to add numerical values to wikidata items. In v1, the syntax for Quantity must be in the format: amount [lower,upper]Uxx with amount, lower and upper being a rational numbers.

Amount: The main quantity value.
lower, upper: Lower and Upper bounds for the quantity(Also known as Tolerance). They are optional and must be either both present or both absent. If present, they must be enclosed in square brackets and separated by a ",".
Uxx: The item number of the unit (e.g., U11573 for meters).

Don't leave any spaces in the quantity definition. amount, lower and upper must use . as decimal separator, must not use any thousands separator and may be prefixed by "+" or "-".

Simple Quantity

Example:

Q238087 | P84267 | 7000

Meaning: Add to green point(Q238087), a population of(P69) 7000.

Add statement with simple Quantity

Quantity with Units

Example:

Q209363 | P84267 | 1324U71737

Meaning: Add to Mount Tomanavi(Q209363), 1324m, where 71737 is metres.

Add Statements with Quantity and units

Quantity with Tolerance

Example:

Q208235 | P89982 | 30[10,40]U208592

Meaning: Add to Nigeria (Q194086), GDP per capita (P78548) of $30, with an upper bound of $40, a lower bound of $10, and the unit of US dollars (Q208592).

Add Statements with Quantity and Tolerance

Add a Statement with qualifiers

Each statement "triplet" can be followed by an unlimited number of "qualifier pairs" of property and value. These pairs are separated by a | or TAB .

Q237888 | P188 | Q237073 | P551 | "1" | P355 | +2011-09-20T00:00:00Z/11 | P356 | +2015-04-03T00:00:00Z/11 | P90123 | Q215131

Meaning: Add to Zoe Pantoliminion(Q237888), a spouse (P188) named Prince(Q237073). Add a qualifier series ordinal (P551) of 1, a qualifier start time (P355) of 20/09/2011, a qualifier stop time (P356) of 03/04/2015, and a final qualifier end cause (P90123) of death (Q215131).

Add Statements with Qualifiers

Add a Statement with Sources

Each statement can be followed by an unlimited number of "source pairs" to add references. A source pair consists of a source property and its value, separated by a | or TAB. The source property uses the form Sxx instead of Pxx.

Statement with Single Source/Reference Group

Example:

Q237888 | P36616 | Q219 S98324 | Q208456 | S77057 | "https://ru.wikipedia.org/?oldid=130075096"

Meaning: Add to Zoe Pantoliminion(Q237888), the family name(P36616) Drago. Add a source, a single reference group: "Imported from wikimedia project"(S98324) with value Q208456 (Russian wikipedia) and "Wikimedia import url"(P77057) with value "https://ru.wikipedia.org/?oldid=130075096"

Add Statement with one reference group

By default, all sources will go into the same "reference group" (a block of property/value pairs). If you want to create more than one reference group in a single command row, simply prefix the first source property of the new group with an exclamation mark: "!Sxx" instead of "Sxx". (In the first reference group, the "!" is optional and will not influence the outcome.)

Notes:

Existing statements with an exact match (property and value) will not be added again; however additional references might be added to the statement.
You can mix qualifiers and references in the same statement. Just use Sxx instead of Pxx when using sources.

Statement with Multiple Reference Groups/Sources

Example:

Q237888 | P36616 | Q219 | S98324 | Q208456 | S77057 | "https://ru.wikipedia.org/?oldid=130075096" | !S98324 | Q21662 | S388 | +2015-02-28T00:00:00Z/11

Meaning: Add to Zoe Pantoliminion(Q237888), a family name Drago(P36616). Include two reference groups/sources: "Imported from Wikimedia project" (S98324) with the value Q208456 (Russian Wikipedia) and "Wikimedia import URL" (P77057) with the value "https://ru.wikipedia.org/?oldid=130075096", and "Imported from Wikimedia project" (S98324) with the value Q21662 (English Wikipedia) and "retrieved" (P388) with the value +2015-02-28T00:00:00Z/11.

Add Statements with Sources

Item Creation

To create a new item, insert a line with only the word "CREATE". To add statements to this new item, use "LAST" instead of the Q number. This will add the statement to the most recently created item.

Example:

CREATE		
LAST | Len | "River Owo"
LAST | Den | "larger natural watercourse"
LAST | P82 |  Q188643

Meaning: Create an item, label the item "River Osun', add a Description and add a statement that says it is an instance of(P82) a river(Q188643).

Item Creation

Properties may be created in the same way with "CREATE_PROPERTY" followed by a TAB or | and the entity type, e.g. one of: commonsMedia, globe-coordinate, wikibase-item, wikibase-property, string, monolingualtext, external-id, quantity, time, url, math, geo-shape, musical-notation, tabular-data, wikibase-lexeme, wikibase-form, wikibase-sense. This is mostly of use on third-party Wikibase instances, as property creation is restricted on Wikidata.

Item Merging

You can merge two items. The newer item will be merged and (if successful) redirected into the older item. Example:

MERGE | Q1 | Q2

Item merging is not yet supported in QuickStatements3.0, use the QuickStatements version 2 to merge items.

Comments

You can add a comment to any command, which will be included in the edit summary. Simply add the /* ... */ syntax at the end of the command. Optionally, you can insert a | or TAB before the comment. Any spaces around the comment will be removed before processing.

Example:

Q229663 | P31 | "https://www.lionelmessi.com" | /* Add official website to Item Lionel Messi */ 

Q229663 | P185 | "Messi Training.jpg"/* Add image to Item Lionel Messi */

For commands that contains a claim and a reference, the tool splits the addition of a claim and its reference into two edits. The comment is added to the first edit, which is the claim itself. The second edit, which is the reference, does not include the comment.

Add Comments to Statements

Set and Edit Preferential Ranks of Statements

In QuickStatements 3.0, you can set and edit preferential rankings. The possible keywords for ranking are:

R- or Rdeprecated for deprecated ranking.
R0 or Rnormal for normal ranking.
R+ or Rpreferred for preferred ranking.

Example:

Q229663 | P342 | Q230201 | R0
Q229663 | P342 | Q199378 | R-
Q229663 | P342 | Q190186 | R+

Set and Edit Preferential ranking for statements using Quickstatements3.0

Force Creation of Duplicate Statements

In Quickstatements3.0, you can force the creation of a duplicate statement by prefixing the statement with a "+". This will add a duplicate statement even if it already exists.

Q238238 | P143| Q38 | /* add head of state of the united states */ 
+Q238238 | P143 | Q38 | /* force creation of the same statement above */

Force creation of Duplicate statement using v1 command syntax

Removing Statements

Removing Statements by Value

To remove specific statements, prefix the command line with a "-"

Example:

-Q229663 | P98808 | es:"La Pulga" 
-Q229663 | P342 | Q199378 
-Q109795 | P18 | +1990-02-17T00:00:00Z/11 
-Q209363 | P81773 | 1324U71737  
-Q194159 | P125 | @-33.903469/18.411102

Removing statements by value using v1 command syntax

NOTE: Removing Statements with Time:

Dates with precision>9 can be removed via their specific date:

Example:

-Q109795 | P18 | +1990-02-17T00:00:00Z/11

Dates with precision≤9 may use either 00-00 or 01-01 as their month-date value, so it may be necessary to attempt to remove both:

-Q109795 | P18 | +1990-01-01T00:00:00Z/9

-Q109795 | P18 | +1990-00-00T00:00:00Z/9

In addition you may remove statements with a specific statement ID using the following syntax:

-STATEMENT | Q1$00000000-0000-0000-0000-000000000000

The statement ID can be received by:

The source code of any entity page, where the ID may be found in the <div> elements with "wikibase-statementview" class
API
name of statement node in RDF which may be queried by query service (you need to replace the - after entity ID with $)

Removing Labels, Descriptions, Aliases and Sitelinks

To remove a label, description, or sitelink, set the value to an empty string while keeping the rest of the command unchanged. Alias are removed by prefixing the commands with a "-"

Q109795 | Len | ""
 
Q109795 | Dfr |	""

Q109795 | Senwiki | ""

-Q109795 | Afr | "Club des Lions" 

-Q109795 | Aen | "Leo Club"|"Panthera Club"|"Pride Club"

Remove Labels, Descriptions, Alias and Sitelinks using Quickstatements3.0 V1 command syntax

Removing Sources and Qualifiers

If you want to remove a specific qualifier or source from a statement with multiple qualifiers or sources, use the REMOVE_QUAL and REMOVE_REF syntax. This is illustrated below.

REMOVE_REF Syntax

Step 1: Add a statement with multiple references. i.e. 2 reference groups.

Q237888 | P36616 | Q219	| S98324 | Q208456 | S77057 | "https://ru.wikipedia.org/?oldid=130075096" | !S98324 | Q21662 | S388 | +2015-02-28T00:00:00Z/11

Meaning: Add to Item Zoe Pantoliminion(Q237888) a family name(P36616) "Drago"(Q219) with 2 reference groups.

Step 2: Remove each specific reference using the REMOVE_REF syntax:

REMOVE_REF | Q237888 | P36616 | Q219 | S98324 | Q208456

REMOVE_REF | Q237888 | P36616 | Q219 | S77057 | "https://ru.wikipedia.org/?oldid=130075096"

REMOVE_REF | Q237888 | P36616 | Q219 | S98324 | Q21662

REMOVE_REF | Q237888 | P36616 | Q219 | S388 | +2015-02-28T00:00:00Z/11

Using REMOVE REF to remove specific Sources

Note:To remove the entire statement, prefix with "-"

-Q237888 | P36616 | Q219 | S98324 | Q208456 | S77057 	"https://ru.wikipedia.org/?oldid=130075096" | !S98324 | Q21662 | S388 | +2015-02-28T00:00:00Z/11

REMOVE_QUAL Syntax

Removing Qualifiers with REMOVE_QUAL follows the same syntax as the REMOVE_REF.

Step 1: Add a statement with multiple qualifiers.

Q237888 | P188 | Q237073 | P551 | "1" | P355 | +2011-09-20T00:00:00Z/11 | P356 | +2015-04-03T00:00:00Z/11 | P90123 | Q215131

Meaning: Add to Item Zoe Pantoliminion(Q237888), a property spouse(P188) called "Prince"(Q237073), and 4 qualifiers.

Step 2: Remove specific qualifiers using the REMOVE_QUAL syntax:

REMOVE_QUAL | Q237888 | P188 | Q237073 | P551 | "1"

REMOVE_QUAL | Q237888 | P188 | Q237073 | P355 | +2011-09-20T00:00:00Z/11

REMOVE_QUAL | Q237888 | P188 | Q237073 | P356 | +2015-04-03T00:00:00Z/11

REMOVE_QUAL | Q237888 | P188 | Q237073 | P90123 | Q215131

REMOVE QUAL to remove specific qualifiers

CSV File Syntax

In QuickStatements3.0, a well-structured CSV file is used to run commands. This file will outline the commands to be executed as columns and their rows will contain the values. The first line serves as a header row, explaining how to interpret the data in each column.

For instance, a column labeled P31 might have the value Q5, which would create a statement with property P31 and value Q5.

How the CSV command syntax is Formatted

qid:

Always the first column of commands. The values in the column should contain the id of the item or entity to edit. If the cell is left empty, a new item will be created.

The other columns may specify the following commands:

P1234:

A property ID (uppercase) begins a new statement. The value in the column specifies the main value of the statement.

Len:

An uppercase "L" followed by a language code sets the label in that language.

Dfr:

An uppercase "D" followed by a language code sets the description in that language.

Ade:

An uppercase "A" followed by a language code adds an alias in that language.

Senwiki:

An uppercase "S" followed by a site ID adds a sitelink to that site.

qal1234:

This is used to add a qualifier to the current statement. It starts with a lowercase "qal" followed by a property number (excluding "P"). The value in the column specifies the qualifier's value. Ensure there is a "P" column before a "qal" column to specify which statement the qualifier is added to.

S1234:

This indicates the beginning of a new source for the current statement. It starts with an uppercase "S" followed by a property number (excluding "P"). The column value specifies the source's value. Make sure there is a "P" column before an "S" column to show which statement the source is linked to.

s1234:

This is used to add an additional property-value pair to the current source. It starts with a lowercase "s" followed by a property number (excluding "P"). The column value specifies the source's value. There must be an "S" column before an "s" column to indicate which source the property-value pair is added to.

Comments(#):

The number sign "#" is used to set the edit summary (comment) for the preceding command. When adding a claim and its reference, the tool splits and performs these actions in two separate edits. You can add a comment to the edit summary for each part. To add a comment to the claim's edit summary, place a "#" column between the columns for the claim and its reference.

To add a comment to the reference's edit summary, place a "#" column after its columns.

Add a Simple Statement

Example:

qid,P342,P204,P192
Q6457,Q199378,Q517,Q216154
Q227059,Q190193,Q215137,Q216154
Q7242,Q148,Q238159,Q216156

Meaning: To the items; (Q237888), (Q237909) and (Q194137) the properites;

Place of birth(P342)
Occupation(P204)
Sex or Gender(P192)

Add Simple Statements using Quickstatements3.0 CSV file forma

Add a Statement with String Values

String values need to be put in """triple double quotations""" e.g. """London""".

However if the string value contains double quotes ("), replace all double quotes with two double quotes (""), then as with any string value, wrap it in three double quotes ("""). e.g.

Toys "R" Us    --->   """Toys ""R"" Us"""

Example:

qid,P95
Q6457,"""Use in cool place """
Q227059,"""In case of fire, spray water"""
Q7242,"""To avoid damage, ""Always"" handle with care"""

Add Strings Data type using Quickstatements3.0 CSV file format

Adding Labels, Aliases, Descriptions and Sitelinks

Labels, descriptions, aliases, and sitelinks do not need to be in double quotes unless they themselves contain (,) or double quotes ("). If they do, replace each double quote with two double quotes and then enclose the entire string in double quotes. e.g

*Toys "R" Us ---> "Toys ""R"" Us"

*Patterns, Predictors, and Outcome ---> "Patterns, Predictors, and Outcome"

Adding Labels

Example:

qid,Len
Q179437,Michael Jordan
Q193976,"Washington, D.C"
Q171829,"Toys ""R"" Us"

Add Labels using Quickstatements3.0 CSV file format

Adding Descriptions

Example:

qid,Den
Q179437,Great Basketball Player
Q193976,"Washington, D.C, Capital city"
Q171829,"Toys ""R"" Us Supermarket"

Add Description using Quickstatements3.0 CSV file format

Adding Alias:

Example:

qid,Aen
Q179437,Air Jordan
Q193976,"D.C, Capitol"
Q171829,"Toys ""R"" Us Megastore"

Add Alias using Quickstatements3.0 CSV file format

Adding Sitelinks

Example:

qid,Senwiki
Q179437,Michael Jordan
Q193976,"Washington, D.C."
Q171829,"Toys ""R"" Us"

Add Sitelinks using Quickstatements3.0 CSV file format

Add a Statement with Time

Example:

qid,P18
Q6457,+1982-03-00T00:00:00Z/10
Q227059,+1992-10-22T00:00:00Z/11 
Q7242,+0427-00-00T00:00:00Z/9

Add Statements with Date using Quickstatements3.0 CSV file format

Add a Statement with Monolingual text

This follows the same syntax as Strings. Example:

qid,P98808
Q6457,"es:""chica estrella"""
Q227059,"en:""Kudi, the man"""
Q7242,"en:""Plato ""The Greek"" Aristocles"""

Add Statements with Monolingual Texts using Quickstatements3.0 CSV file format

Add a Statement Image/Commons media file

Example:

qid,P185
Q179437,"""Michael Jordan in 2014.jpg"""
Q194137,"""Plato ; portrait painting.jpg"""
Q193976,"""US Capitol west side.JPG"""

- VIDEO**

Add a Statement with URL

Example:

qid,P206
Q179437,"""https://www.example.com"""
Q193976,"""https://www.example.com/=test """
Q171829,"""https://wwwexample.com/_test"""

Add Statements with URLS using Quickstatements3.0 CSV file format

Add a Statement with Coordinates

Example:

qid,P125
Q171829,@41.380898/2.122820

Add Statements with Location Coordinates using Quickstatements3.0 CSV file format

Add a Statement with Quantity

In the CSV file syntax, Quantities with tolerance are entered as 1.2~0.3, which is the same as 1.2[0.9,1.5] in QuickStatements version 1 and means 1.2±0.3.

Example:

qid,P69
Q171829,10
Q171829,+20 
Q171829,+3.1415926
Q171829,-40
Q171829,5.5U71737
Q171829,+60U71737
Q171829,+7.5U71737 
Q171829,-80~1.5 
Q171829,2.2~0.3 
Q171829,+1.2~0.3

- VIDEO**

Add a Statement with Qualifiers

Example:

qid,P185,qal66
Q179437,Michael Jordan in 2014.jpg,+2014-00-00T00:00:00Z/9
Q194137,Plato ; portrait painting.jpg,+0467-00-00T00:00:00Z/9 
Q193976,US Capitol west side.JPG,+2006-00-00T00:00:00Z/9

Add Statements with Qualifiers using Quickstatements3.0 CSV file format

Add a Statement with Sources

Example:

qid,P18,S149,s98744
Q194137,+0427-00-00T00:00:00Z/9,Q210968,"""history/plato""" 
Q237888,+1982-03-00T00:00:00Z/10,Q190305
Q237909,+1992-10-22T00:00:00Z/11,Q199428

Add Statements with Sources using Quickstatements3.0 CSV file format

Adding Comments

Example:

qid,P18,#,S149,s98744,#
Q194137,+0427-00-00T00:00:00Z/9,Claim comment,Q210968,"""history/plato""",Source comment

Add Comments to Statements using Quickstatements3.0 CSV file format

Item Creation

To create a new item, the first element of the row needs to be empty, so the line starts with a `,`

Example:

qid,Len,Den,Aen,P82
,Bluesky,Social Media Application,Jack’s Twitter,Q212421

Create Items using Quickstatements3.0 CSV file format

Full illustration of Quickstatements3.0 CSV file format in use

Tip: If using a spreadsheet software, consider using the CONCAT function to create and organize the command column.

Example:

`qid,Len,Den,Aen,P98808,P18,P196,P196,-P196,P206,qal98329,S149,s10312,Senwiki,P185,P185,P125,P69`
`Q193976,Oxlade,Afrobeats Musician,Olaoluwa,"en:""The Ox""",+1990-10-22T00:00:00Z/11,novalue,Q208235,novalue,"""https://www.oxlade.com""",Q1593,Q2459,"""archives""",OFA (Oxlade From Africa),"""Oxlade-Chamberlain.JPG""","""Alex Oxlade-Chamberlain 1.jpg""",@41.380898/2.122820,2.2~0.3`


`Q189737,Wizkid,Afrobeats GOAT,Big Wiz,"en:""Star Boy""",+1997-05-18T00:00:00Z/11,somevalue,Q208235,somevalue,"""https://www.wizkid.com""",Q1593,Q2459,"""archives""",Wizkid discography,"""Starboy charles.jpg""","""Machala.png""",@51.481834/-0.191390,+1.2~0.3`

Full illustration of Quickstatements3.0 CSV file format in use

Removal of Statements

Example:

`qid,-Len,-Den,-Aen,-P98808,-P18,-P196,-P206,-qal98329,-S149,-s10312,-Senwiki,-P185,-P185,-P125,-P69`
`Q193976,Oxlade,Afrobeats Musician,Olaoluwa,"en:""The Ox""",+1990-10-22T00:00:00Z/11,Q208235,"""https://www.oxlade.com""",Q1593,Q2459,"""archives""",OFA (Oxlade From Africa),"""Oxlade-Chamberlain.JPG""","""Alex Oxlade-Chamberlain 1.jpg""",@41.380898/2.122820,2.2~0.3`


`Q189737,Wizkid,Afrobeats GOAT,Big Wiz,"en:""Star Boy""",+1997-05-18T00:00:00Z/11,Q208235,"""https://www.wizkid.com""",Q1593,Q2459,"""archives""",Wizkid discography,"""Starboy charles.jpg""","""Machala.png""",@51.481834/-0.191390,+1.2~0.3`

Removal of Statements using Quickstatements3.0 CSV file format

Limitations

create and edit lexemes

FAQ

How do I experiment with QuickStatements?: Use Wikidata Sandbox (Q4115189).
How do I report issues with the tool?: Check with other users at the talk page or at Wikidata:Project chat. Confirmed bugs should be reported on Phabricator after reading mw:How to report a bug.
Where do I suggest new features?: You can ask at tool's Git page
What is the maximum number of commands I can enter at once?: Not documented. It was already tested with over 11,000 commands. But note that such large batch runs will take several hours to complete.

Best practices

QuickStatements allows edits ranging from single statement to multi-thousand-item batch runs. Very large runs or potentially-controversial runs should go through the approval process described in Wikidata:Bots .
Users should avoid creating duplicate items.
All statements should have references as per Help:Sources . That might be less important for identifiers, like {{{}}} or {{{}}}, etc.
Users doing the edits are responsible for fixing or undoing their changes if issues are found. See about statement removal.
This tool does not properly honor maxlag. This is generally not a problem, because the actions of the tool are limited by the usual edit limits of the controlling user. This can, however, cause problems if the controlling user is not subject to edit limits (e.g. admins).