OpenRefine

This page is a translated version of the page OpenRefine and the translation is 36% complete.

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

2022 Coolest Tool
Award Winner

in the category
Eggbeater

OpenRefine（オープンリファイン）は2018年以来、ウィキデータの一括編集に使うツールとしてよく使われています。
OpenRefine supports Wikimedia Commons batch editing and uploading, thanks to a Wikimedia grant, since 2022.
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.

General links

OpenRefine's website:
- openrefine.org
Download OpenRefine:
- openrefine.org/download.html
Download and install the Wikimedia Commons extension for OpenRefine:
- github.com/OpenRefine/CommonsExtension
General OpenRefine documentation:
- openrefine.org/docs

Bug reports and requests

On GitHub (for OpenRefine in general):
- github.com/OpenRefine/OpenRefine/issues
On Wikimedia Phabricator (mainly for Wikimedia Commons reconciliation):
- phabricator.wikimedia.org/tag/openrefine

Uploaded via OpenRefine

It is possible to track the usage of OpenRefine to upload files to Wikimedia Commons, via the Uploaded with OpenRefine category, using the Commons Uploaders in cat tool.