convert-csv.com logo convert-csv.com

Convert CSV to Delimited / Excel

Change delimiters, quoting, and encoding, or re-export CSV to Excel. Auto-detects the input field separator.

100% Secure - your files are processed in your browser and never sent to a server.
Drop your file hereor click to browseSupports CSV, TSV, or TXT files (.csv, .tsv, .txt) (Max 100MB)

Sometimes you need to change the delimiter of a CSV file without altering the data itself. European CSV files often use semicolons instead of commas because the comma serves as a decimal separator in many locales. Other systems use tabs, pipes, or custom delimiters. This re-delimiter tool reads your CSV and writes it back with a new delimiter, handling all RFC 4180 edge cases: quoted fields containing the delimiter character, escaped quotes, and multi-line values. The parser auto-detects the input delimiter if you are unsure, and you can select from comma, semicolon, tab, or pipe as the output delimiter. You can also toggle whether to include or exclude the header row. The tool is useful for preparing CSV data for import into systems that expect a specific delimiter, such as MySQL (which uses LOAD DATA INFILE with configurable delimiters), European ERP systems, or legacy data pipelines. All processing runs locally in your browser using PapaParse, ensuring your data stays private.

How to use the Convert CSV to Delimited tool

  1. Load your CSV data: Drag and drop your CSV file, choose a file from your file explorer, or paste CSV data directly into the paste area.
  2. Configure delimiters: Select the input delimiter (auto-detect, comma, semicolon, tab, or pipe) and the output delimiter you want to convert to.
  3. Toggle header row: Choose whether to include or exclude the header row in the output.
  4. Convert data: Click the "Convert Data" button to re-delimit your CSV with the new separator.
  5. Export results: Copy the results to your clipboard, download as a local file, or export to Excel format.

Frequently asked questions

Can the tool auto-detect my CSV delimiter?
Yes. When you select the auto-detect option, the parser analyzes the first few rows to identify whether the delimiter is a comma, semicolon, tab, or pipe based on column consistency.
Will this tool corrupt my data during re-delimiting?
No. The parser correctly handles RFC 4180 edge cases including quoted fields containing the delimiter character, escaped double quotes, and multi-line values. Data integrity is preserved.
Can I change from comma-delimited to semicolon-delimited for European systems?
Yes. Select the input delimiter (or auto-detect) and choose semicolon as the output delimiter. This is the most common use case for European locale compatibility.
Does the tool preserve the header row?
You can choose to include or exclude the header row in the output. When included, the first row is treated as column names and is not quoted.
Can I use this to convert CSV to TSV (tab-separated)?
Yes. Select tab as the output delimiter to convert your CSV to TSV format, which is useful for pasting into applications that handle tab-separated data.

Related tools