Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

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.

Community edition

Free

DataCleaner community edition

Free

Free plan

Getting started

  1. Open the DataCleaner website
  2. Download the community edition
  3. Install it on Linux, macOS, or Windows
  4. Connect a CSV, Excel, relational, or NoSQL data source
  5. Create profiling or cleansing workflows
  6. Add validation, reference-data, or transformation rules
  7. 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

PlanPriceWhat it means
DataCleaner community editionFreeOpen 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.