Wikimedian in Residence

How to use OpenRefine

Open source software for easily processing and reconciling data in bulk into Wikidata.


OpenRefine is a tool which can be used to clean up data.  It is an open source software used to edit spreadsheets and upload data easily to Wikidata. 

This is a video from Emma Carroll, Data Visualisation student intern at the University of Edinburgh, on how to use OpenRefine using the Survey of Scottish Witchcraft database as her example dataset.

Further resources 

© Ewan McAndrew and Hannah Rothmann, University of Edinburgh, 2020, CC BY-SA 4.0, unless otherwise indicated.