Description:
Tool for working with messy data (previously Google Refine)
|
|
Type: Cask
|
Latest Version: 3.10.1@0
|
Tracked Since: Dec 28, 2025
|
|
Links:
Homepage |
@OpenRefine |
formulae.brew.sh
|
|
Category: Developer tools
|
|
Tags:
data-cleaning
etl
data-wrangling
open-source
analysis
|
|
Install:
brew install --cask openrefine
|
About:
OpenRefine is a powerful, free, open-source tool for data cleaning and transformation. It allows users to explore and clean large datasets, transform them between formats, and enrich them with web services. Its interactive interface makes complex data wrangling tasks accessible without requiring programming expertise.
|
Key Features:
- Faceted browsing and filtering for data exploration
- Advanced clustering algorithms to identify and fix inconsistencies
- Transformation language (GREL) for complex data manipulation
- Reconciliation API for matching data against external services
- Extensible with a rich ecosystem of plugins
|
Use Cases:
- Cleaning messy CSV data from legacy systems or manual entry
- Standardizing and de-duplicating customer or product databases
- Transforming data between JSON, XML, and CSV formats
- Linking local datasets to external identifiers like Wikidata
|
Alternatives:
-
Trifacta Wrangler
– Commercial tool with more enterprise features but higher cost
-
Pandas
– Python library requiring programming skills, more suitable for automation
|
| Detected |
Version |
Rev |
Change |
Commit |
| Mar 4, 2026 10:18pm |
3.10.1 |
0 |
VERSION_BUMP |
3a80fb06 |
| Feb 26, 2026 7:19pm |
3.10.0 |
0 |
VERSION_BUMP |
932b6ab3 |
| Sep 3, 2025 1:42am |
3.9.5 |
0 |
VERSION_BUMP |
1fd110ca |
| Jul 8, 2024 10:10pm |
3.8.2 |
0 |
VERSION_BUMP |
9cf78370 |
| Feb 11, 2024 4:23pm |
3.7.9 |
0 |
VERSION_BUMP |
023c7e7a |
| Nov 29, 2023 12:19pm |
3.7.7 |
0 |
VERSION_BUMP |
a57b69da |
| Oct 10, 2023 12:16am |
3.7.6 |
0 |
VERSION_BUMP |
36f280e8 |
| Apr 7, 2023 9:53pm |
3.7.2 |
0 |
VERSION_BUMP |
5ef2dd87 |
| Mar 11, 2023 5:50am |
3.7.1 |
0 |
VERSION_BUMP |
a38412f4 |
| Feb 15, 2023 3:57pm |
3.7.0 |
0 |
VERSION_BUMP |
37ed708b |
| Nov 26, 2022 5:13am |
3.6.2 |
0 |
VERSION_BUMP |
c184abce |
| Oct 6, 2022 12:37am |
3.6.2 |
0 |
VERSION_BUMP |
e5c4c152 |
|