CSV · XLSX · in your browser

Clean a messy spreadsheet in one pass.

Trim stray spaces, drop blank and duplicate rows, put every date in one format and turn $1,234.50 into a number. You see every change before you download. Your file is read by this page and never uploaded.

Free, no account. Why dates go wrong · How privacy works

Example: four input rows and what the default steps do to them
#	Customer	Order date	Signup	Amount
1	··Maria LopezMaria Lopez	Jan 17, 20242024-01-17	03/04/2023DMY or MDY?	$1,234.501234.50
2	EthannbClarkEthan Clark	1/15/20242024-01-15	05/06/2023DMY or MDY?	(45.00)-45.00
3	(blank)	(blank)	(blank)	(blank)
4	··Maria Lopez	Jan 17, 2024	03/04/2023	$1,234.50

Live output of the default steps. Row 3 is blank and row 4 repeats row 1, so both go. “Signup” could be 3 April or March 4, so it is flagged for you instead of guessed.

Step 1 · Load a file

Drop a CSV or Excel file here

Free plan: up to 3 files, 5.0 MB and 50,000 rows each. Read in your browser, never uploaded.