OpenRefine Reviews & Pricing

Key Features

• Facets and Filters: Find patterns by applying facets to columns, which filter data into specific subsets. These include text, numeric, timeline and scatterplot facets, as well as customizable facets with more specialized parameters.
• Clustering: Use comparison methods to find similar but not identical entries to clean up data at a large scale rather than editing one at a time. Implement key collision, phonetic and nearest neighbor clustering methods.
• Unlimited Undo and Redo: Undo any actions that change the data, and view a project’s change history to track past edits. Revert data to previous states on the project timeline when necessary.
• Reconciliation: Match against other datasets, locally or from external sources, to cross-reference or link different datasets. External datasets must conform to the Reconciliation Service API standards to be compatible.
• Expressions: Enter formulas in GREL (General Refine Expression Language), Jython or Clojure to manipulate data. Use a built-in expressions editor to preview formulas’ effects on data and save useful formulas to reuse.
• Wikibase Integration: Load data from Wikibases such as Wikidata and Wikimedia Commons. Upload data to these platforms in bulk using Wikidata schema.

Limitations

• No official technical support is available, and any future updates or improvements must come from the open-source community.
• Basic functionality is available without writing code, but reaching the platform’s full potential requires some programming knowledge.
• Can be limited by computer processing power and local memory when working with large data quantities.

Suite Support