DataCleaner

Visit site Alternatives

Score6.9

Rank#3 of 30

PriceFree

Free planYes

Runs onLinux, macOS, Windows

Summary

DataCleaner is a free, open-source data quality tool for profiling, validating, and cleansing data. Its profiling engine can surface patterns, missing values, character sets, and other properties of data values. It works with CSV files, Excel spreadsheets, relational databases, and NoSQL databases. Users can define cleansing rules through search and replace, regular expressions, pattern matching, or custom transformations, and check values against internal or external reference data. The project lists Apache Hadoop, Apache Spark, Pentaho Data Integration, and Apache MetaModel among its integrations or connectivity options. Developers can embed DataCleaner in other applications or create plugins, while the project describes community-built extensions and shared content. It supports batch processing, visual workflows, standardization, validation, enrichment, and scheduled runs, with desktop deployment for Linux, macOS, and Windows. The code is licensed under LGPL. 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 is for

DataCleaner suits people who need to profile and clean data from files or databases, including developers who want to embed it or build plugins. It is available for Linux, macOS, and Windows.

What is good

Free and open source under LGPL.
Profiles patterns, missing values, and character sets.
Handles CSV, Excel, relational, and NoSQL sources.
Supports custom cleansing rules and reference data.
Offers scheduled runs and visual workflows.

What to know first

Latest listed release is community edition 5.9.0.
Release news lists version 5.8.1 dated February 9, 2022.

Verdict

DataCleaner provides data profiling and configurable cleansing across a range of file and database sources. Its open-source community edition is free, with extensions and integrations described by the project.

DataCleaner plans and pricing

All plans

DataCleaner community edition Free Open source · LGPL datacleaner.github.io · 30 Sept 2026

Compared on data cleansing software

Standardization rules: Yesdatacleaner.github.io
Data validation: Yesdatacleaner.github.io
Data enrichment: Yesdatacleaner.github.io
Processing mode: batchdatacleaner.github.io

Facts

Purpose: DataCleaner is an open source data quality solution with a data profiling engine for discovering and analyzing data quality.datacleaner.github.io · 30 Sept 2026
Profiling: Its profiling engine finds patterns, missing values, character sets, and other characteristics of data values.datacleaner.github.io · 30 Sept 2026
Data sources: It handles CSV files, Excel spreadsheets, relational databases, and NoSQL databases.datacleaner.github.io · 30 Sept 2026
Cleansing: Users can build cleansing rules using search and replace, regular expressions, pattern matching, or custom transformations.datacleaner.github.io · 30 Sept 2026
Reference data: It can use internal or external reference data to verify data values against the real world.datacleaner.github.io · 30 Sept 2026
Ecosystem: The project describes community driven extensions, integrations, and shared content.datacleaner.github.io · 30 Sept 2026
Integrations: The site names Apache Hadoop, Apache Spark, Pentaho Data Integration, and Apache MetaModel as supported integrations or connectivity options.datacleaner.github.io · 30 Sept 2026
Extensibility: Developers can embed DataCleaner in other applications and build plugins for specific use cases.datacleaner.github.io · 30 Sept 2026
License: The site states that the code is licensed under the Lesser General Public License (LGPL).datacleaner.github.io · 30 Sept 2026
Latest listed release: The downloads page lists DataCleaner community edition 5.9.0 as the latest release.datacleaner.github.io · 30 Sept 2026
Java support: The release news states DataCleaner 5.8.1 runs on Java versions 9 through 17.datacleaner.github.io · 30 Sept 2026
Discussion and support: Community discussion posts are powered by GitHub issues and use the Discussion or Question label.datacleaner.github.io · 30 Sept 2026
Release activity: The news page lists the DataCleaner 5.8.1 release dated February 9, 2022.datacleaner.github.io · 30 Sept 2026