OpenRefine
OpenRefine is a free, open-source Java-based desktop tool for cleaning, transforming, and enriching messy tabular data, serving data professionals, researchers, Wikimedia contributors, GLAM institutions, and journalists through a local web server interface.
- Company typePrivate
- Founded2012
- Headquarters—
- Headcount1–10
- GTM typeB2C
- OfferingSoftware
What OpenRefine does
OpenRefine is a free, open-source desktop application for cleaning, transforming, and enriching messy tabular data. It was forked from Google Refine in 2012 and is maintained by a global community of volunteers with part-time staff support. The tool runs as a Java-based local web server accessible through a browser interface, with data processing occurring entirely on the user's machine. Its core feature set includes faceting for drilling through large datasets, clustering for merging similar values via heuristics, infinite undo/redo with full operation history, and a proprietary GREL expression language that supports Jython and Clojure scripting for advanced transformations. A distinctive capability is native reconciliation against Wikidata, Wikimedia Commons, and arbitrary Wikibase instances, enabling bulk editing of linked open data. The product supports imports and exports across CSV, TSV, JSON, XML, SQL, Excel, ODS, and Google Sheets/Drive formats.
The tool serves a diverse user base that includes data professionals and researchers, Wikimedia/Wikidata contributors, GLAM (Galleries, Libraries, Archives, Museums) institutions, and journalists. Distribution is fully self-serve via direct download from the project website, GitHub Releases, and Homebrew Cask across Windows, Mac, and Linux. Distribution channels include documentation, GitHub, a community forum, Twitter/X, YouTube, Mastodon, and a Weblate-based community translation effort covering 13+ languages.
OpenRefine is a community-governed open-source project, not a venture-backed company. It is a fiscally sponsored project of Code for Science & Society, a US 501(c)(3) charitable organization that handles administrative functions in exchange for a 15% fee. Revenue is generated through individual and corporate donations, grants (notably from the Chan-Zuckerberg Initiative, Wikimedia Foundation, Google News Initiative, and NFDI4Culture), and a small merchandise store. The disclosed annual operating budget is USD 50,000, and the project has historically been funded through non-dilutive grant capital rather than customer revenue.
OpenRefine firmographics
Firmographics- Name
- OpenRefine
- Legal name
- OpenRefine
- Website
- https://openrefine.org
- Company type
- Private
- Founded year
- 2012
- Operating status
- Operating
- Headcount range
- 1–10 employees
- Short description
- OpenRefine is a free, open-source Java-based desktop tool for cleaning, transforming, and enriching messy tabular data, serving data professionals, researchers, Wikimedia contributors, GLAM institutions, and journalists through a local web server interface.
- Ownership category
- akta.pro rank
OpenRefine business model
Business model- GTM type
- B2C
- Offering type
- Software
- Cost components
- Personnel, Operations, Technology or R&D, Infrastructure, Marketing or Sales
Revenue model
- Individual and corporate donations: OpenRefine accepts donations through GitHub sponsorship, online forms for credit card/PayPal/bank transfer, and through fiscal sponsor Code for Science & Society. Donations are tax-deductible in the US.
- Grants: OpenRefine has received multiple grants from organizations including Chan-Zuckerberg Initiative, Wikimedia Foundation, NFDI, and others to fund development and community support.
- Merchandise store: OpenRefine operates a merchandise store at store.openrefine.org for branded items.
Pricing tiers
| Model | Billing | Price |
|---|---|---|
| Freemium | Others | Free open source download |
Go-to-market motion1 record
Distribution channels4 records
Marketing channels8 records
OpenRefine product offering
Product offeringCore offering
OpenRefine is a free, open-source desktop application for cleaning messy data, transforming it between formats such as CSV, TSV, JSON, XML, SQL, Excel, and ODS, and extending it via web services and external data sources. It runs locally on the user's machine as a small web server accessed through a browser, offering faceting, clustering, reconciliation against external databases such as Wikidata and other Wikibase instances, and infinite undo/redo with full operation history.
Product overview
OpenRefine is a single unified open source desktop application for data cleaning and transformation. The core product provides faceting and filtering for exploring large datasets, clustering for merging similar values, reconciliation for matching data to external databases (particularly Wikidata and other Wikibase instances), and infinite undo/redo for operation history. Data is stored and processed locally on the user's machine for privacy. The tool supports import from various file formats (CSV, TSV, JSON, XML, Excel, ODS) and export to multiple formats including custom templates and SQL. Wikibase integration is built into the core application, enabling direct editing of Wikidata and Wikimedia Commons structured data through a schema editor. The application runs as a local web server accessible via browser.
Differentiator
Problem solved
Functional benefit
Products and services
- OpenRefine
Companies that use OpenRefine
Customer profileSegments4 records
Ideal customer profiles4 records
OpenRefine technology and API
TechnologyTechnology focussed Yes
API detail
- Has API
- No
- API docs
- API detail
Core technology
AI maturity
App detail
Integration8 records
Feature9 records
OpenRefine partnerships and signals
Strategic signalScale indicators3 records
Recent moves6 records
Expansion highlights6 records
OpenRefine competitors and assessment
Company assessmentDirect peers
- Wikidata QuickStatements: Web tool for batch-editing Wikidata using text commands, frequently used as a downstream complement to OpenRefine's Wikibase export. Comparable as an open tool in the Wikidata editing workflow, with overlapping user base in the Wikimedia contributor community.
- OpenRefine fork 'Wrangler' (Stanford): The academic predecessor project that informed both Trifacta and OpenRefine's interactive data transformation paradigm. Comparable as a research-grade interactive data cleaning tool, though now largely dormant.
- Trifacta (now part of Alteryx): Trifacta Wrangler was originally developed from the same Stanford/Data Wrangler research lineage that informed OpenRefine and offers an interactive data cleaning UI with columnar profiling and transformation suggestions. Directly comparable as a focused data-preparation tool for messy tabular data.
Broad incumbents
- Talend Open Studio: Long-running open-source data integration and ETL tool with data quality features. Comparable as a community/open-source alternative for data transformation and cleansing workflows, though oriented toward larger enterprise integration use cases.
- Alteryx Designer: Commercial analytics platform with deep data preparation, blending, and cleansing capabilities acquired Trifacta in 2024. Comparable to OpenRefine in addressing the same messy-data preparation problem, but at enterprise scale with a paid model.
- KNIME: Open-source analytics platform with strong data blending, transformation, and ETL capabilities via a node-based visual workflow. Comparable as a free/open-source data preparation platform, though broader in scope (full analytics rather than focused tabular cleaning).
- Dataiku: Enterprise data science and preparation platform with visual data cleaning capabilities. Comparable in addressing messy-data preparation for analysts, though positioned as a broader paid platform rather than a focused free tool.
- Power Query (Microsoft): Data transformation engine built into Excel and Power BI offering GUI-driven data cleaning, faceting, and merging. Comparable as a widely-adopted tool for cleaning messy tabular data, though embedded in Microsoft's commercial ecosystem.
Emerging players
- tidyverse (dplyr/tidyr): R ecosystem for data manipulation and tidying. Comparable to OpenRefine in spirit (free, open-source, focused on messy-data transformation) but oriented toward R users and script-based rather than GUI-based workflows.
- pandas: Python library widely used for data wrangling, cleaning, and transformation. Comparable as a free, widely-adopted data manipulation tool, though it requires programming rather than offering OpenRefine's guided UI for non-technical users.
Market position
Strengths4 records
Weaknesses4 records
Competitive moat4 records
Key risks6 records
Key highlights6 records
Customer concentration
OpenRefine social profiles
Digital presenceOpenRefine financial estimates
Financial estimateRevenue estimate
Valuation estimate
OpenRefine leadership team
Management profileNumber of profiles
OpenRefine funding detail
Funding detailFunding overview
Funding rounds
Investors
Funding detail is available on the Subscription and Enterprise plan.Contact sales →
OpenRefine M&A and investment
M&A and investmentM&A
Investments
M&A and investment is available on the Subscription and Enterprise plan.Contact sales →
Frequently asked questions about OpenRefine
What does OpenRefine do?
OpenRefine is a free, open-source desktop application for cleaning messy data, transforming it between formats such as CSV, TSV, JSON, XML, SQL, Excel, and ODS, and extending it via web services and external data sources. It runs locally on the user's machine as a small web server accessed through a browser, offering faceting, clustering, reconciliation against external databases such as Wikidata and other Wikibase instances, and infinite undo/redo with full operation history.
Is OpenRefine a public or private company?
OpenRefine is a private company. It is classified as nonprofit foundation owned and is currently operating.
When was OpenRefine founded?
OpenRefine was founded in 2012. It employs 1 to 10 people.
How does OpenRefine make money?
Three revenue lines are on record. Individual and corporate donations are the primary driver. The others are grants and merchandise store.
Who are OpenRefine's main competitors?
Direct peers on record are Wikidata QuickStatements, OpenRefine fork 'Wrangler' (Stanford) and Trifacta (now part of Alteryx). Broad incumbents are Talend Open Studio, Alteryx Designer, KNIME, Dataiku and Power Query (Microsoft). Emerging players are tidyverse (dplyr/tidyr) and pandas.
Does OpenRefine have an API?
No public API is recorded for OpenRefine.