Developer docs
API playgroundTry for free, no card

Search company profiles

OpenRefine

Full company profile

uuid02lqjvq

Namestring
OpenRefine
Legal namestring
OpenRefine
Websiteurl
openrefine.org
Company typeenum
Private
Founded yearint
2012
Descriptiontext

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.

Short descriptiontext

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.

Operating statusenum
Operating
Ownership categoryenum
Headcount rangeband
1–10
akta.pro rankint
Markets served

Serves global market

Keyword5 values
data cleaning software, open source ETL, data transformation tools, Wikidata reconciliation, tabular data processing
NAICS code1 code
  • Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services5182
SIC code1 code
  • Services-Prepackaged Software7372
Product category
Data Cleaning and Transformation Software
GTM motion1 record

Each record includes

Type, Description, Source

Revenue model3 records
1Individual and corporate donations
TypeOthers
Description

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.

openrefine.org
2Grants
TypeOthers
Description

OpenRefine has received multiple grants from organizations including Chan-Zuckerberg Initiative, Wikimedia Foundation, NFDI, and others to fund development and community support.

openrefine.org
3Merchandise store
TypeOthers
Description

OpenRefine operates a merchandise store at store.openrefine.org for branded items.

openrefine.org
Marketing channels8 records

Each record includes

Title, Type, Stage, Description, Source

Distribution channels4 records

Each record includes

Title, Type, Scope, Target buyer, Description, Source

Cost components5 values
Personnel, Operations, Technology or R&D, Infrastructure, Marketing or Sales
Pricing details1 tier
1Free open source download
ModelFreemiumBilling cadenceOthers
Notes

OpenRefine is completely free to download and use. No paid tiers or licensing fees. The tool is available for Windows, Mac, and Linux.

openrefine.org
GTM typeB2C
B2C
Offering typeSoftware
Software
Core offering1 text field

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.

Differentiator
Functional benefit
Problem solved
Product overview1 text field

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.

Product and service1 record
1OpenRefine
Scale indicator3 records

Each record includes

Type, Value, Description, Source

Recent move6 records

Each record includes

Date, Type, Title, Description, Source

Expansion highlight6 records

Each record includes

Type, Description

Peers10 records
1Wikidata QuickStatements
TypeDirect peer
Description

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.

TypeBroad incumbent
Description

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.

TypeBroad incumbent
Description

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.

4tidyverse (dplyr/tidyr)
TypeEmerging player
Description

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.

5pandas
TypeEmerging player
Description

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.

TypeBroad incumbent
Description

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).

TypeBroad incumbent
Description

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.

8OpenRefine fork 'Wrangler' (Stanford)
TypeDirect peer
Description

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.

TypeDirect peer
Description

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.

10Power Query (Microsoft)
TypeBroad incumbent
Description

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.

Market position
Strengths4 records

Each record includes

Headline, Details, Source

Weaknesses4 records

Each record includes

Headline, Details, Source

Competitive moat4 records

Each record includes

Type, Details

Key risks6 records

Each record includes

Headline, Details, Source

Key highlights6 records

Each record includes

Headline, Details, Source

Customer concentration

Classification, Details

Segment4 records

Each record includes

Title, Type, Primary, Description, Pain point addressed, Use case, Source

Ideal customer profile4 records

Each record includes

Profile, Firmographic size, Sales motion, Sales cycle length, Buying structure, Purchase trigger, Buyer persona, Geography, Industry vertical, Primary use case, Description, Pain points, Evidence proof points, Target buyer

Technology focused
Yes
API detail
Has APIbool
No

Docs URL, Description

Integration8 records

Each record includes

Title, Type, Description, Source

AI maturity
App detail

Has app

Feature9 records

Each record includes

Title, Differentiator, Description, Source

Core technology
Revenue estimate
Valuation estimate
Number of profiles
No data
No data
Funding overview

Funding stage, Last funding date, Total funding USD

Funding rounds

Each record includes

Round, Amount USD, Date, Pre money valuation, Total investors, Investors, News

Investors

Each record includes

Name, Type, Date of entry, Rounds participated, Website

Funding detail is available on the Subscription and Enterprise plan.Contact sales →

M&A

Each record includes

Name, Acquisition type, Announced date, Completed date, Status, Website, News

Investment

Each record includes

Name, Round, Announced date, Lead investor, Website, News

M&A and investment is available on the Subscription and Enterprise plan.Contact sales →

OpenRefine

Data Cleaning and Transformation Softwareopenrefine.org

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.

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

  1. 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.
  2. Grants: OpenRefine has received multiple grants from organizations including Chan-Zuckerberg Initiative, Wikimedia Foundation, NFDI, and others to fund development and community support.
  3. Merchandise store: OpenRefine operates a merchandise store at store.openrefine.org for branded items.

Pricing tiers

ModelBillingPrice
FreemiumOthersFree open source download

Go-to-market motion1 record

Distribution channels4 records

Marketing channels8 records

OpenRefine product offering

Product offering

Core 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 profile

Segments4 records

Ideal customer profiles4 records

OpenRefine technology and API

Technology

Technology 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 signal

Scale indicators3 records

Recent moves6 records

Expansion highlights6 records

OpenRefine competitors and assessment

Company assessment

Direct 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 presence

OpenRefine financial estimates

Financial estimate

Revenue estimate

Valuation estimate

OpenRefine leadership team

Management profile

Number of profiles

OpenRefine funding detail

Funding detail

Funding overview

Funding rounds

Investors

Funding detail is available on the Subscription and Enterprise plan.Contact sales →

OpenRefine M&A and investment

M&A and investment

M&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.

Unlock the full company data

50 free credits on sign-up, no credit card required.

Contact sales
Live signals