Clean a product CSV file — fast, free, no account needed. No upload.
Add a product table: safe fixes such as trimming spaces run by default, the other rules are yours to turn on, and problems such as duplicate SKUs are reported, never changed. The file is cleaned in your browser and never uploaded.
- No upload — runs in your browser
- Free, no account
- Reads CSV, TSV, and TXT files
- One file, up to 50 MB
- Safe fixes on by default, value changes opt-in
Drop a CSV file here or click to browse
Accepted: CSV, TSV, and TXT.
One file, up to 50 MB
Your file stays in this browser and is never uploaded.
Where is the cleaned file going?
Optional. It decides one thing: whether the file starts with a byte order mark (BOM). You can change it after you add the file.
With neither chosen, the BOM follows your file: written if it had one or used an older encoding.
How to clean a CSV file
Add your file
Drop in one table file of up to 50 MB. The tool works out its encoding and its delimiter and shows both, so you can choose another if the columns look wrong.
Check the fixes and findings
The safe fixes are on from the start, each with the number of cells, rows or columns it changes. Turn on the other rules you want, choose the SKU column, and look through the findings: each one lists its lines and can show its rows in the preview.
Export and download
Choose where the file is going, press Export CSV and download the cleaned table. It is written as a new file; your original file isn't changed.
What the CSV cleaner changes, and what it only reports
Product exports collect small faults: spaces around values, no-break spaces and zero-width characters copied from web pages, accents typed two different ways, empty rows, nameless empty columns and doubled spaces in column names. The safe fixes for these are on by default, and each one shows how many cells or rows it changed.
Three rules change values you might mean as they are, so they start off: collapsing repeated spaces inside cells, formatting the SKU column (no spaces, upper case) and removing rows that repeat an earlier row exactly. Turn on the ones you want; the counts and the preview follow.
Everything else is reported and never changed: duplicate SKUs, empty cells in the columns you mark as required, rows longer or shorter than the header, duplicate or empty column names, columns that mix units such as cm and in, cells a spreadsheet may run as a formula, and quote marks inside cells that aren't quoted, such as 24" for inches, which are kept as characters. Each finding lists its line numbers in your file, so you can fix it in your own data where it matters.
The export is UTF-8, keeps your file's delimiter unless you choose another, and ends every line with CRLF. Choose Open in Excel and the file starts with a byte order mark (BOM), which Excel needs to show accents correctly when you double-click the file. Choose Import into a store or marketplace and it is written without one.
Limits worth knowing
- Reads CSV, TSV, and TXT files, one at a time. Spreadsheet files such as XLSX are refused: save the sheet as CSV UTF-8 in your spreadsheet app and open that file.
- One file of up to 50 MB. Your browser holds the whole table in memory while it works.
- Units are never converted, cells are never edited one by one, and column names are never renamed or re-cased.
- UTF-8 and UTF-16 are recognised; a file that isn't valid UTF-8 is read as Windows-1252 and marked as a guess. Anything that can't be read in the encoding used shows as �, and the number of such places is shown beside the encoding. You can read the file as UTF-8, UTF-16LE, UTF-16BE, Windows-1252, ISO-8859-15, Windows-1250, and Mac OS Roman instead.
CSV cleaner FAQ
Is my file uploaded to a server?
No. Your file is read, cleaned and saved in your browser, and it is never uploaded, stored or sent anywhere. The page does fetch its own code: the part that reads and cleans tables loads from this site when you add a file. Your file is never part of that.
What does the cleaner change by default?
Only safe fixes. It trims spaces, tabs and line breaks at the start and end of cells and column names, turns no-break spaces and tabs inside cells into plain spaces, removes zero-width and control characters, makes accents typed two ways the same, removes empty rows and nameless empty columns, and turns runs of spaces in column names into one. Each rule shows its count and can be turned off. Collapsing spaces in cells, SKU formatting and removing duplicate rows start off.
Does it remove duplicate SKUs?
No. Rows that share a SKU may be a mistake or may be meant, and only you can tell which, so they are listed under Findings with their line numbers and kept in the file. Rows that repeat an earlier row exactly can be removed with the Duplicate rows rule, which is off until you turn it on.
Why do accents look wrong when I open a CSV in Excel?
When you double-click a CSV, Excel reads it as UTF-8 only if the file starts with a byte order mark (BOM). Choose Open in Excel before you export and the cleaned file gets one. If your own file was saved in an older encoding, the cleaner marks the encoding it read as a guess and shows sample text, so you can check the accents before you export.
Can I clean an Excel (XLSX) file?
Not directly: the cleaner reads CSV, TSV, and TXT files. In Excel, Numbers or another spreadsheet app, save the sheet as CSV UTF-8, then open that file here.
What is formula protection?
A cell that starts with =, +, - or @ (or their full-width forms), a tab or a line break may run as a formula when a spreadsheet opens the file. The cleaner lists such cells under Findings. Formula protection, off by default, puts an apostrophe (') before each of them, and before a column name that starts the same way, so a spreadsheet shows it as text. It changes values such as -5 or +44 20… as well, so use it for files you open in a spreadsheet.
My file uses semicolons or tabs. Does that work?
Yes. The cleaner recognises commas, semicolons, tabs and pipes, shows which one it found, and lets you choose another if the columns look wrong. The export uses your file's delimiter unless you choose another one in the export settings.
Does it convert units?
No. A column that mixes units, such as cm and in or g and lb, is reported with how many values use each unit, and every value stays as you wrote it.
What to do next
- Resize ImageGetting the product photos ready too? Resize them to the exact pixel size you need.
- Compress ImageNeed a photo under a file size limit? Compress a JPEG, PNG or WebP to a target size.
- Convert Image FormatPhotos in HEIC or WebP? Convert them to JPEG or PNG.
- Images to PDFNeed a product sheet as a PDF? Turn images into a PDF, one image per page.
Clean your CSV now
Add your file, check the fixes and findings, and download the cleaned table. Your file never leaves this device.