CSV Delimiter Fixer
Convert CSV delimiters between commas, semicolons, and tabs without breaking quoted fields. Fix UTF-8 BOM encoding and normalize line breaks in your browser.
Tips
- Invisible byte order marks are cleaned or added on demand, and inconsistent line endings are standardized.
- Fields containing separators, newlines, or quotation marks are safely re-escaped with RFC 4180 compliant quotes.
- Compare the row and column counts before and after conversion to verify that no structural data was lost.
How to use it
- 1 Upload your CSV or TSV file to automatically detect its current delimiter and character encoding.
- 2 Choose your target delimiter such as comma, semicolon, or tab character.
- 3 Enable the UTF-8 BOM option if you plan to open the resulting file in regional spreadsheet software.
- 4 Review the parsed table preview and row counts, then download your corrected file.
What you should know
Regional system locales often cause CSV parsing failures across different spreadsheet applications and e-commerce platforms. While standard international APIs, Shopify, and WooCommerce expect comma-separated values, localized operating systems and regional spreadsheet versions use semicolons to prevent collision with comma decimal marks. When an application encounters the wrong separator, entire data rows collapse into a single column. Numerical columns with decimal commas, embedded line breaks in product descriptions, and unescaped quote characters further corrupt table structures during data imports and automated catalog synchronizations.
This tool inspects raw text files in your browser, auto-detects existing delimiters and character encodings, and rewrites the dataset using your chosen separator: comma, semicolon, or tab. It parses multi-line values, preserves inner commas within quoted text blocks, and optionally injects a UTF-8 byte order mark for seamless opening in regional spreadsheet software. Conversion runs entirely within your browser memory with zero server uploads, keeping customer lists and financial catalogs private while repairing structural syntax without altering underlying cell contents.
Frequently asked questions
Why does my spreadsheet open all data inside a single column?
Your software expects a different separator than the one used in the file, often occurring when regional systems expect semicolons while the file uses commas. Converting the delimiter to match your software regional settings resolves the column alignment.
Will commas or quotation marks inside text descriptions get corrupted?
No. The parser adheres to RFC 4180 standards, retaining quotes around text fields that contain commas or line breaks while updating only the active field separators.
What is a TSV file and can this tool process it?
A TSV is a tab-separated values file commonly used by data export tools and database dumps to avoid delimiter collisions with punctuation. This tool reads TSV files and converts them to standard CSV formats seamlessly.
Guides
Articles and format references related to this tool.
Related tools
- CSV and Excel Merger Merge multiple CSV and Excel spreadsheets into one table by aligning matching column headers. Export clean data to XLSX or CSV directly in your browser.
- Excel to CSV Converter Convert Excel sheets to UTF-8 CSV files instantly. Choose custom delimiters, add BOM for spreadsheet software, and export directly in your browser with privacy.
- Remove Duplicate Rows Remove duplicate rows from Excel or CSV files by SKU, barcode, or email. Choose which row to keep, normalize whitespace, and export securely in your browser.
- Excel / CSV → Shopify Converts your Excel / CSV product export into the Shopify import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- n11 → Shopify Converts your n11 product export into the Shopify import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- n11 → Hepsiburada Converts your n11 product export into the Hepsiburada import template: columns are mapped, barcodes and variants stay intact. Free, no signup.