OpenRefine is a free data wrangling tool that can be used to process, manipulate and clean tabular (spreadsheet) data and connect it with knowledge bases ("spreadsheets on steroids" / "a swiss army knife for data"). It is widely used by librarians, in the cultural sector, by journalists and scientists, and is taught in many curricula and workshops around the world.

OpenRefine for Wikidata

OpenRefine for Wikimedia Commons

OpenRefine edits on Wikidata and Wikimedia Commons can be undone with the EditGroups tool.

Cloud version of OpenRefine (on PAWS) for Wikimedians

Is it difficult for you to run OpenRefine on your own computer?

Run OpenRefine in PAWS on Wikimedia’s Cloud Services (you need a Wikimedia account and an internet connection):

 Launch PAWS

OpenRefine for Wikibase

Reconciliation