OpenRefine

OpenRefine is a free, open source desktop application for cleaning, transforming, and extending messy data. Originally developed as Google Refine (formerly Freebase Gridworks), the project transitioned to a community-maintained open source initiative and has become an essential tool for data journalists, librarians, researchers, and open data advocates worldwide. OpenRefine runs locally on the user's machine, ensuring complete data privacy since no data is uploaded to external servers or cloud services. The tool excels at handling large datasets with its faceted browsing interface, which allows users to filter and explore records through multiple dimensions simultaneously. A standout feature is clustering, which uses powerful heuristic algorithms to identify and merge inconsistent or duplicate values within a column, such as variant spellings of names or addresses. The reconciliation system enables users to match their data against external knowledge bases like Wikidata, VIAF, and GeoNames, automatically linking records to authoritative identifiers and enriching datasets with additional properties. OpenRefine maintains a complete history of all operations with infinite undo and redo capabilities, and users can export their transformation pipeline as JSON for reproducible workflows on new datasets. The GREL expression language provides powerful cell-level transformations, while extensions add support for RDF, machine learning, and network analysis. The project operates under the stewardship of a community-elected governance council, receives funding from organizations including the Google Summer of Code and Investment in Open Infrastructure, and is available for Windows, macOS, and Linux.