Side by side
DataCleaner vs OpenRefine
Both stand on data cleansing software. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Free plan Open source APILinuxMac+2
DataCleaner combines data profiling with cleansing rules, reference-data checks, and multiple input types. It is free and open source, with the latest listed download release identified as community edition 5.9.0.
Visit DataCleaner Free plan LinuxMacSelf-hosted+2
OpenRefine offers local data cleaning and enrichment with a wide range of import formats and an operation history. Users should account for the Java requirement and the lack of default data encryption.
Visit OpenRefineThe facts
| DataCleaner | OpenRefine | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Yes | Not published |
| Runs on | API, Linux, Mac, Self-hosted, Windows | Linux, Mac, Self-hosted, Web, Windows |
| Lowest paid plan | Free or on request | Free or on request |
| Plans published | 2 | 1 |
| Maker | Not published | Not published |
| Website | datacleaner.github.io | openrefine.org |
| On data cleansing software | #1 of 31 | #4 of 31 |
DataCleaner: what it does well
- Profiles patterns and missing values
- Works with CSV and Excel files
- Supports relational and NoSQL databases
- Cleansing rules include custom transformations
- Desktop versions for Linux, macOS, and Windows
What to know first
- The listed 5.8.1 release news is dated February 9, 2022
- Code is licensed under LGPL
OpenRefine: what it does well
- Processes data locally rather than in a cloud service.
- Basic functions work offline.
- Includes faceting, clustering, and reconciliation tools.
- Imports a wide range of data formats.
What to know first
- Java must be installed and configured.
- Data is not encrypted by default.
- It is desktop software, not a mobile app.
Alternatives to DataCleaner Alternatives to OpenRefine The whole list
