CSV Cleaner + Change Log
Free CSV/TSV cleaner by TORIX (AI-assisted). Trims whitespace, converts date columns to ISO YYYY-MM-DD, normalizes number columns, optional Title Case, drops empty rows/columns and duplicates. Outputs cleaned CSV, a before/after change log and an issues list. Review results before use.
Overview
A CSV cleaning Actor that ingests CSV/TSV text or a public CSV link and normalizes tabular data for consistent downstream use: it trims and collapses whitespace, converts dates to ISO YYYY-MM-DD (configurable day/month order), normalizes numeric formats and currencies into numeric values (handles thousands separators, decimal separators, currency symbols, and parentheses for negatives), applies title case to selected columns, removes empty rows and empty columns, repairs headers to unique names, and removes duplicate rows after cleaning. The Actor auto-detects delimiter and encoding heuristics, protects identifier-like columns (preserving leading zeros for phone/ZIP/ID/SKU/IBAN-like names), records every change with a before/after audit entry tied to the original record number, reports values that could not be cleaned and were left unchanged, and provides a summary of input/output row counts and change statistics.
Use cases
- Clean and standardize messy CSV exports for import or analysis (consistent dates, numeric types, header normalization).
- Normalize international number and currency formats into numeric values for calculation.
- Convert heterogeneous date formats into ISO YYYY-MM-DD for uniform storage and querying.
- Apply title case to name or label columns for presentation consistency.
- Remove empty rows/columns and deduplicate identical records after normalization.
- Repair and uniquify broken or repeated header names.
- Generate an audit/change log of every modified cell and a list of problematic values requiring manual review.
- Prepare customer/contact lists for deduplication and consolidation by key columns (e.g., email).
How to use
Open on Apify Store
Sign in to Apify or create a free account.
Configure the input
Fill in the input form; each field is documented on the Apify page.
Run and export
Start the run and download results as JSON, CSV or Excel, or use the API.
