Your data is cleaned in this browser tab and never uploaded.
What each fix does
Trim spaces removes spaces at the start and end of every cell and turns double spaces into single ones, so “Ana Diaz ” and “Ana Diaz” match. Remove duplicates keeps the first of any rows that are the same, across all columns or by one column such as email. Split turns one column into several, and merge joins two into one. Every step can be undone, and the original stays one click away.
Fixing dates
Fix dates reads dates written in many ways, such as 3/14/24, 14.03.2024, 3 March 2024 or March 3rd, 2024, and writes them all the same way. When a date like 03/04/2024 could mean either March or April, the order is worked out from the other dates in the column. If it cannot be, those cells are left as they were and counted, so you can pick day first or month first yourself.
Opening and saving
Open a CSV or TSV file, or copy cells straight from Excel, Numbers or Google Sheets and paste them in. Commas, tabs and semicolons are detected for you. Save as CSV for other apps, or as an Excel file. The preview shows the first 200 rows, and every row is cleaned and saved.