CSV cleanup landing page

Standardize Number Formats in CSV

Normalize currency symbols, thousands separators, and inconsistent numeric strings before importing data into BI or ops tools.

Upload a messy spreadsheet

Supports CSV, TSV, XLSX, and XLS. Current plan: Free with files up to 1 MB and 5 analyses per day.

Mixed number formats break sorting, numeric imports, and spreadsheet formulas.
CleanCSV can detect columns that mix currency strings, commas, and plain numbers.
Automatic normalization helps downstream tools treat values as numeric data again.

The current fix removes currency symbols, commas, spaces, and accounting-style negatives from numeric strings.

Not automatically. Percent values are skipped to avoid changing their meaning.

Upload a messy CSV, detect duplicate rows instantly, and export a cleaner file without rewriting formulas or scripts.

Standardize mixed date formats like YYYY-MM-DD and MM/DD/YYYY into one clean export-ready format.

Detect empty cells, understand which columns are affected, and fill missing values before you export clean data.

Trim leading and trailing whitespace that silently breaks joins, lookups, deduplication, and imports.