OpenRefine

From Wikimedia Belgium
Jump to navigation Jump to search

OpenRefine is a powerful tool to manipulate and prepare data to be uploaded to Wikidata.

Multiple plugins exist. You can import and export data from and to multiple formats.

It is more powerful than Excel, but a bit more difficult to use.

Install[edit]

Download the zip file. Unzip. Install the JRE (Java Run-tine Environment).

Run[edit]

Run openrefine.exe

Stop[edit]

Close the DOS window.

Functionality[edit]

Presentation OpenRefine
  • Data import (multiple targets)
  • Cleanup: merge data, detect and correct outliers
  • Transform: split strings into columns
  • Reconcile: get ID data from e.g. Wikidata
  • Enrich: get additional data by ID from external databases
  • Data export (multiple targets)
  • Extensions

See also[edit]

Documentation[edit]