Clean a CSV
Clean a CSV file
An export has stray spaces, blank lines and repeated rows. Open it, choose the steps, and save a clean copy; the original stays as it was.
Open workspaceWhen this helps
Use this before importing a list into another system, or before sharing it. Every step is shown with what it changes and can be undone.
For example
A task you can finish here
A contact export of 14,250 rows: Trim spaces fixes 214 cells, Drop empty rows removes 31 blank records, Remove duplicates removes 12 repeats, and Remove drops an unused column. Save a copy makes a CSV that opens with its accents in Excel.
The workflow
Three clear steps
- 01
Open the file
Choose or drop a CSV, TSV, JSON or Excel file. Files shows how it was read: encoding, separator and the first lines.
- 02
Choose the steps
Trim spaces, Drop empty rows, Remove duplicates, rename, move or remove columns, and write dates as YYYY-MM-DD. Each says what it changes.
- 03
Save a copy
Choose CSV, TSV, JSON or Excel. The copy is read back and checked before it is offered to download.
Your files and the public site
Open files only in the separate Table workspace. Its processing runs in your browser; this public site does not receive your files, their names, what they contain or any setting.Read the privacy information.
Questions
Is my original file changed?
No. Table makes a new file. The one you opened is never written to.
Can it fix values inside cells, such as phone numbers?
No. It trims spaces, removes rows and columns, renames headings and writes dates as YYYY-MM-DD. It does not edit or reformat other values.
Ready to make the copy?
Your files stay unchanged.
Open workspace