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.

Coolest Tool Award 2022 logo

Open Refine

2022 Coolest Tool
Award Winner

in the category
Eggbeater


  1. OpenRefine is a popular tool for Wikidata batch editing since 2018.
  2. OpenRefine supports Wikimedia Commons batch editing and uploading, thanks to a Wikimedia grant, since 2022.
  3. OpenRefine can also be used to batch import and edit data items and media files in Wikibases.

OpenRefine is a community-supported open source project, licensed under the BSD license. It has a graphical user interface in more than 15 languages.

OpenRefine logo
OpenRefine logo
General links
Talk about OpenRefine with its community and with Wikimedia users
Bug reports and feature requests

OpenRefine for Wikimedians Edit

Cloud version of OpenRefine (on PAWS) for Wikimedians Edit

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): https://hub-paws.wmcloud.org/

 Launch PAWS

OpenRefine for Wikidata Edit

OpenRefine for Wikimedia Commons Edit

Related tools Edit

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

OpenRefine for Wikibase Edit

Reconciliation Edit