Mass edits on Wikidata - how to use Google spreadsheets and Quickstatements to add mass edits to Wikidata

views comments

Wikidata is a free linked database of secondary data that can be read and edited by both humans and machines. Wikidata acts as central storage for the structured data of its Wikimedia sister projects including Wikipedia, Wikivoyage, Wikisource, and others.

Essential tools for mass editing Wikidata:

Quickstatements v.2

For importing data from a spreadsheet into Wikidata. The syntax you need to use is explained in QuickStatements v.1

Wikipedia and Wikidata Tools for Google sheets (Demo)

Google sheets add-on for pulling data from Wikidata and Wikipedia directly into a spreadsheet (Note: you need a Google account to install this)

This video tutorial by Navino Evans (Histropedia) demos how to add UNESCO data to Wikidata in bulk using the Quickstatements tool (version 2) as follows:

Practical - mass editing using QuickStatements

1.Go to the batches spreadsheet, then click the link with your selected batch number

2.Select all cells highlighted orange (the QuickStatements commands), then copy them to your clipboard ( click edit then copy

3.Go to QuickStatements and click

4.Click 'Import commands' -> 'Version 1 format'

5.Paste in the commands copied in step 2, then click ‘import’

6.Check a selection of the commands to make sure they have imported correctly

7.Click the “RUN” button at the bottom to launch your first mass edit!

Tags

the university of edinburgh

The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336, VAT Registration Number GB 592 9507 00, and is acknowledged by the UK authorities as a “Recognised body” which has been granted degree awarding powers.

Any views expressed within media held on this service are those of the contributors, should not be taken as approved or endorsed by the University, and do not necessarily reflect the views of the University in respect of any particular issue.

Mass edits on Wikidata - how to use Google spreadsheets and Quickstatements to add mass edits to Wikidata

Related Media

the university of edinburgh