Preview 0
Only the first 100 rows are shown. The downloaded file contains every row.
Drop your CSV, set the cleanup options and download the fixed file. Your file never leaves this computer.
Only the first 100 rows are shown. The downloaded file contains every row.
CSV is a simple format that stores data as plain text separated by commas or semicolons. Accounting software, online shop dashboards, CRMs and bank statements usually export data as CSV. But these files often arrive with problems: spaces at the start and end of cells, empty rows, empty columns nobody uses and the same record repeated several times.
These problems cause errors when you import the file into another system: "Ann " and "Ann" count as different customers, empty rows stop an import halfway and duplicate orders inflate reports.
Cleanup: trim spaces at the start and end of cells, collapse extra spaces inside cells, drop empty rows and completely empty columns, and remove duplicate rows by the whole row or by the columns you choose.
Columns: remove the columns you do not need and change their order. Find and replace: change a value across the whole file at once. Output: set the delimiter, line endings and quoting for the target system, and add a UTF-8 BOM for Excel.
The preview table updates after every step, so you see the result before you download.
Fixing a product list from one online shop before uploading it to another marketplace, removing duplicates from an event sign-up list, dropping empty columns from an accounting export so only the needed fields remain, or trimming spaces before importing customers into a CRM.
CSV files often hold customer names, phone numbers, emails and sales data. This tool opens and processes the file in your browser and never uploads it to a server. It handles files up to 30 MB, and a 50,000-row file is processed in under a second.
Turn on Add UTF-8 BOM for Excel in the Output section. Excel then opens the file with the right encoding.
Files up to 30 MB work as long as the browser has enough memory. A file with 50,000 rows is processed in under a second.
Yes. Pick a column such as email in the Compare by list under Clean up, and the first row for each value is kept.