DataCleaner
datacleaner.github.io
- Free plan
- Open source
- Windows
- macOS
- Linux
- API
- Self-hosted
What DataCleaner is
DataCleaner is an open-source data quality tool for profiling, validating, and cleansing data on desktop systems. Its profiling engine identifies patterns, missing values, character sets, and other traits in data values. It works with CSV files, Excel spreadsheets, relational databases, and NoSQL databases. Users can build cleansing rules with search and replace, regular expressions, pattern matching, or custom transformations, and can compare values against internal or external reference data. DataCleaner supports batch processing, visual workflows, standardization, validation, enrichment, and scheduled runs. Named integrations and connectivity options include Apache Hadoop, Apache Spark, Pentaho Data Integration, and Apache MetaModel. Developers can embed it in other applications or build plugins, while the project describes community-driven extensions, integrations, and shared content. Its code is licensed under LGPL. DataCleaner is available for Linux, macOS, and Windows. The downloads page lists community edition 5.9.0 as the latest release; release news lists version 5.8.1, dated February 9, 2022, and says it runs on Java versions 9 through 17.
Who it suits
DataCleaner suits people who need to inspect and transform data from files or databases using a desktop tool. Developers can also embed it in applications or build plugins for specific use cases.
Good to know, and what to watch
- Profiles patterns, missing values, and character sets.
- Handles CSV, Excel, relational, and NoSQL data sources.
- Supports custom transformations and reference data checks.
- Offers batch workflows, scheduled runs, and visual workflows.
- The latest listed release is community edition 5.9.0.
- Release news lists version 5.8.1 from February 9, 2022.
Plans
Every plan and priceCommunity edition
DataCleaner community edition
Free plan
Getting started
- Open the DataCleaner website
- Download the community edition
- Install it on Linux, macOS, or Windows
- Connect a CSV, Excel, relational, or NoSQL data source
- Create profiling or cleansing workflows
- Add validation, reference-data, or transformation rules
- Schedule batch runs when needed
The Club's review
DataCleaner is a desktop application for examining and improving data across files and databases. It suits teams that need repeatable, rule-based batch processing with room for custom extensions. Its free community edition is most attractive when local control matters more than a cloud service or a rapidly updated product.
Overview
DataCleaner brings profiling and cleanup into one workflow. The profiling engine exposes patterns, missing values, character sets, and other value characteristics, so teams can identify defects before deciding how to correct them. That makes it useful for exploratory quality work as well as for repeatable preparation jobs.
The project is open source under the Lesser General Public License (LGPL), with community extensions, integrations, and shared content forming its wider ecosystem. The downloads page names community edition 5.9.0 as the latest release, while the news page records version 5.8.1 on February 9, 2022. Organizations that require a visibly active release cadence should weigh that history before standardizing on it. Release notes state that DataCleaner 5.8.1 runs on Java 9 through 17.
Key features
Sources include CSV files, Excel spreadsheets, relational databases, and NoSQL databases. That mix is valuable when a quality process must move between analyst-owned spreadsheets and production data stores instead of being limited to one connector type.
Cleaning rules can use search and replace, regular expressions, pattern matching, or custom transformations. In practice, this gives both straightforward corrections and more specialized logic, although teams will need to define and maintain those rules themselves. Standardization and data validation support consistent formats and checks, while enrichment can add context to existing records.
Reference data, whether internal or external, can verify values against real-world data. That is a stronger approach than checking syntax alone when correctness depends on a known list or authority. Visual workflows provide a way to assemble processing steps, but the processing model is batch-oriented and deployment is desktop-based, so this is a better fit for scheduled jobs than for always-on, cloud-native pipelines.
Scheduled runs support recurring quality operations. Developers can embed DataCleaner in other applications and create plugins for specific requirements, extending its usefulness for organizations with engineering resources. Named integration and connectivity options include Apache Hadoop, Apache Spark, Pentaho Data Integration, and Apache MetaModel. Community discussion uses GitHub issues with Discussion or Question labels, which is a practical channel for users prepared to work in an open-source support model.
Pricing
| Plan | Price | What it means |
|---|---|---|
| DataCleaner community edition | Free | Open source under LGPL, with the profiling, cleansing, validation, enrichment, visual workflow, batch, desktop, and scheduled-run capabilities described above. |
There is no paid tier or seat, record, or trial term to compare. The free edition is therefore a straightforward choice for individuals, technical teams, and organizations able to operate desktop software and support their own rules and extensions. Its trade-off is not a higher subscription bill, but the responsibility that comes with a community-led open-source project and its dated release history.
Platforms
DataCleaner runs on Linux, macOS, and Windows. It is designed for desktop deployment, with batch processing and scheduled runs rather than a browser-first service. Java compatibility stated for version 5.8.1 covers Java 9 through 17.
Who it's for
Choose DataCleaner when your work spans files and heterogeneous databases, needs profiling before transformation, and benefits from explicit cleansing rules or reference-data checks. It is particularly suitable for data engineers, analysts, and developers who want to automate recurring desktop batch jobs or embed the engine and write plugins.
Look elsewhere if nontechnical users need a hosted, collaborative interface, if processing must be continuously available as a cloud service, or if a frequent vendor release cycle is a hard requirement. DataCleaner’s desktop and community-supported model places more operational and maintenance work on your organization.
Pros and cons
Pros
- Broad source coverage: CSV, Excel, relational, and NoSQL support accommodates mixed estates.
- Deep rule options: Regular expressions, pattern matching, custom transformations, and standardization handle more than simple find-and-replace jobs.
- Quality checks with context: Reference data, validation, and enrichment can test and improve records against real-world values.
- Extensible and free: LGPL licensing, plugins, embedding, and named ecosystem integrations give technical teams room to adapt the tool without a subscription.
Cons
- Desktop, batch orientation: It is less suitable for cloud-first, continuously running, or browser-based collaboration.
- Release cadence concern: The dated 5.8.1 release news may trouble teams that prioritize frequent updates.
- Self-managed complexity: Building rules, scheduled jobs, plugins, and integrations requires technical ownership rather than a turnkey managed service.
Alternatives
For a wider shortlist, see Data Cleansing Software and Data Preparation Software.
- Melissa Data Quality is a paid platform with a free plan and trial, broad web, API, desktop, and self-hosted coverage, and a GAV Free tier at no cost for 250 records per month.
- BlueData is a freemium web and Android option whose free tier allows one web user, one mobile user, 1 GB of storage, and 500 submissions per month.
- Plauti Deduplicate offers a free Salesforce version, with full-edition features requiring a trial or custom pricing.
- OpenRefine is another free, open-source desktop choice under a BSD 3-clause license, with Linux, macOS, Windows, self-hosted, and web availability.
- DQE One Unify is a paid, trial-based option for hosted curative processing in DQE’s cloud.
- Experian Data Quality Solutions is a paid, trial-based service tailored to budget and requirements.
- Firstlogic Data Quality IQ Suite provides a yearly license with unlimited records and pricing dependent on products, features, platform, and country coverage.
- SAS Visual Statistics targets enterprise-scale statistical modeling on SAS Viya and has no free plan.
Verdict
DataCleaner is a strong fit for technical users who need free, extensible profiling and cleansing across files and databases, especially when batch processing and local deployment are acceptable. Choose it for its combination of broad inputs, configurable rules, reference-data checks, and LGPL flexibility. Choose another platform when hosted collaboration, continuous cloud processing, or a more current release rhythm matters more than control and zero license cost.
The verdict
DataCleaner brings profiling and cleansing features together for file and database sources, with options to extend it through plugins and integrations. It is free, open source, and licensed under LGPL.
Questions people ask
Is DataCleaner free?
Yes. DataCleaner lists a free community edition and uses the LGPL open source license.
Which operating systems are supported?
DataCleaner is available for Linux, macOS, and Windows.
What data sources can it handle?
It handles CSV files, Excel spreadsheets, relational databases, and NoSQL databases.
Can developers extend DataCleaner?
Yes. Developers can embed it in applications and build plugins for specific use cases.
Which integrations are listed?
Named integrations or connectivity options include Apache Hadoop, Apache Spark, Pentaho Data Integration, and Apache MetaModel.
What the maker publishes
- Analyzers
- Reference documentation lists completeness, character-set, date/time, number, pattern, referential-integrity, uniqueness, value-distribution and machine-learning analyzers. source
- Cleansing
- Users can build cleansing rules using search and replace, regular expressions, pattern matching, or custom transformations. source
- Code execution
- Developer documentation explains how to configure, build, execute and retrieve results from DataCleaner jobs through code. source
- Command line
- The reference manual documents command-line execution, parameterized jobs and runtime configuration overrides. source
- Company ownership history
- The survey states that DataCleaner was developed by Human Inference, later moved through Neopost and Quadient, and from 2019 was associated with EDM Media Group. source
- Data profiling
- Its profiling engine identifies patterns, missing values, character sets and other characteristics of data. source
- Data sources
- It handles CSV files, Excel spreadsheets, relational databases, and NoSQL databases. source
- Datastore connectors
- Documentation covers JDBC databases, CSV, fixed-width files, Excel, XML, Elasticsearch, MongoDB and CouchDB datastores. source
- Data wrangling
- The application supports cleansing workflows using reference data, search-and-replace rules, regular expressions, pattern matching and custom transformations. source
- Deployment model
- Downloads are supplied as desktop archives for Windows, macOS and Linux, with source tags also available. source
- Discussion and support
- Community discussion posts are powered by GitHub issues and use the Discussion or Question label. source
- Documentation depth
- The documentation archive includes reference versions 5.7.0, 5.4.0 and 5.2, covering end-user, configuration, CLI, integration and developer topics. source
- Ecosystem
- The project describes community driven extensions, integrations, and shared content. source
- Extensibility
- Developers can embed DataCleaner in other applications and build plugins for specific use cases. source
- Extensibility
- The developer guide covers extension tutorials, packaging, annotated components, single-JAR extensions and embedding DataCleaner. source
- File and database inputs
- The official site says it handles CSV, Excel, relational databases and NoSQL databases. source
- Integrations
- The site names Apache Hadoop, Apache Spark, Pentaho Data Integration, and Apache MetaModel as supported integrations or connectivity options. source
- Integrations
- The project advertises Apache Hadoop, Apache Spark, Pentaho Data Integration and Apache MetaModel integrations. source
- Java compatibility
- The 5.8.1 release announcement says the software runs on Java versions 9 through 17. source
- Java support
- The release news states DataCleaner 5.8.1 runs on Java versions 9 through 17. source
- Latest listed release
- The downloads page lists DataCleaner community edition 5.9.0 as the latest release. source
- Latest listed release
- The downloads page identifies DataCleaner community edition 5.9.0 as the latest release. source
- Licence
- The community edition code is licensed under the GNU Lesser General Public License. source
- License
- The site states that the code is licensed under the Lesser General Public License (LGPL). source
Checked against the maker's pages on 15 Oct 2026.