openrefine
« Back to VersTracker
Description:
Tool for working with messy data (previously Google Refine)
Type: Cask  |  Latest Version: 3.9.5@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
Version History
Detected Version Rev Change Commit
Sep 3, 2025 1:42am 3.9.5 0 VERSION_BUMP 1fd110ca
Jul 8, 2024 10:10pm 3.8.2 0 VERSION_BUMP 9cf78370