Fix common CSV problems
- Remove duplicate rows from a CSV fileRemove duplicate rows from a CSV file online, free. Preview what gets removed, then download CSV or Excel. Your file never leaves your browser.
- Remove empty rows from a CSV fileDelete blank rows and rows of only commas from a CSV file. Preview the changes and download a clean CSV or Excel file, privately in your browser.
- Trim extra spaces in a CSV fileRemove leading, trailing and repeated spaces from every cell of a CSV file. Preview the cleaned cells and download CSV or Excel, privately in your browser.
- Remove non-breaking spaces from a CSVText copied from the web often hides non-breaking spaces that break matches. Remove them from your CSV, privately in your browser.
- Fix the delimiter in a CSV fileYour CSV opens in one column? Detect and change the delimiter (comma, semicolon, tab, pipe) and download a corrected CSV or Excel file.
- CSV opens in one column in Excel: how to fix itAll your CSV data lands in column A in Excel? Fix the delimiter in seconds, privately in your browser, and download a file that opens correctly.
- Fix garbled characters in a CSV fileSeeing odd symbols instead of accents in your CSV? Fix UTF-8 and Windows-1252 encoding problems and download a file that opens correctly in Excel.
- Save a CSV as UTF-8 with BOM for ExcelAccents turning into strange symbols in Excel? Save your CSV as UTF-8 with BOM so Excel reads it correctly. Free, in your browser.
- Keep leading zeros when opening a CSV in ExcelZip codes and IDs like 00123 lose their zeros in Excel. Convert your CSV to an Excel file that keeps them, privately in your browser.
Convert your CSV
- Convert a CSV file to ExcelConvert a CSV file to Excel online without uploading it. Fix delimiter and encoding problems first, then download a real .xlsx file.
- Convert a CSV from comma to semicolonChange a CSV from comma-separated to semicolon-separated online. Values that contain commas are handled safely. Files stay in your browser.
- Convert a CSV from semicolon to commaChange a semicolon-separated CSV to a comma-separated one online. Safe with quoted values, private, and free in your browser.
- Convert a CSV to tab-delimited (TSV)Convert a CSV file to a tab-separated file online. Quoted values are handled correctly and your file stays in your browser.
- Convert a pasted table to CSVCopy cells from Excel or Google Sheets, paste them and download a CSV. No need to save a file first. Free and private in your browser.
Learn and prepare
- How to clean a CSV before importing itA step-by-step checklist to clean a CSV before importing it into a CRM, online shop, email tool or database. Free and private in your browser.
- What is a CSV file?CSV stands for comma-separated values. Learn what a CSV file is, how it works, why it breaks and how to fix common problems.
- CSV vs Excel (XLSX): which should you use?CSV or XLSX? Learn the differences, when to use each and how to convert between them. Free CSV to Excel converter in your browser.