CSV Engine vs DataCleaner

CSV Engine is a web tool for cleaning and validating uploaded spreadsheets before export. It maps source columns to reusable templates, sanitizes values, detects duplicates, previews row-level failures, and can export only records that pass configured rules. Uploads use drag and drop, with automatic detection of delimiters, encodings, and headers. Column mapping supports aliases and fuzzy matching, and mappings can be saved per template. Listed cleanup includes whitespace trimming, casing normalization, email checks, phone parsing, and date fixes. Duplicate matching can use multiple fields and merge strategies, with conflicts reviewed before commit. Templates preserve schemas, field types, and validation rules for reuse. One credit processes up to 1,000 rows, including validation, deduplication, and export. The Free plan provides five credits per month and three active templates; the Starter plan is $15 a month billed annually. One-off credit packs are also available, beginning at $8, paid once, with credits that never expire. Pro includes email support with a 24-hour response; its developer API is listed as coming soon.

DataCleaner is an open-source data quality application for profiling, validating, and cleansing data. 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 create cleansing rules with search and replace, regular expressions, pattern matching, or custom transformations, and use internal or external reference data to check values. DataCleaner supports batch processing, visual workflows, standardization, validation, enrichment, scheduled runs, and desktop deployment on Linux, macOS, and Windows. 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; the project also describes community extensions, integrations, and shared content. The code is licensed under LGPL. The community edition is free at free. The downloads page lists 5.9.0 as the latest release; release news says version 5.8.1 runs on Java 9 through 17 and is dated February 9, 2022.