Change CSV Delimiter
Quickly change the CSV column delimiter to a new symbol. Runs entirely in your browser, so your data never leaves your device.
0 chars · 0 lines
Output
The result appears here as you type.
How to use Change CSV Delimiter
- 1. Paste the delimited data. Put the file contents into the input pane. It does not have to use commas; semicolon, pipe and tab files are all fine as long as you tell the tool what to look for.
- 2. Declare the current delimiter. In 'Current delimiter (\t for tab)' enter the character the file uses now, typing \t if it is tab-separated. Getting this right matters because quoted fields containing that character are kept whole.
- 3. Set the new delimiter. In 'New delimiter (\t for tab)' enter the separator the destination system wants, such as ; for a German Excel export or | for a pipe-delimited feed. Fields containing it get quoted automatically.
- 4. Copy the converted file. Copy the result and hand it to the importer that was rejecting the original. Every value is untouched; only the separators between them, and any quoting they now require, have changed.
When to use Change CSV Delimiter
Change CSV Delimiter converts between the many dialects that all call themselves CSV. European Excel writes semicolons, database feeds use pipes, Unix tools like tabs, and importers are rarely flexible about it. This tool swaps the separator with real parsing, so a find-and-replace never corrupts a quoted value.
- Fixing a semicolon file from European Excel. A colleague in Berlin exports CSV and every row lands in one column of your tool. Their locale used semicolons; convert them to commas and the import works on the first try.
- Producing a pipe-delimited feed. A data warehouse ingestion job specifies pipe-separated files. Convert your comma export to | delimiters here instead of writing a script that would break on values containing commas.
- Escaping the comma-in-values trap. Your address column is full of commas and downstream parsing keeps splitting it. Switching the delimiter to tab makes the file unambiguous for the naive splitter you cannot change.
Examples
Switch from commas to semicolons
Input
name,age Ada,36
Output
name;age Ada;36
About the Change CSV Delimiter tool
Change CSV Delimiter runs as plain JavaScript in your browser tab, with no server behind it. Quickly change the CSV column delimiter to a new symbol. Whatever you put in stays on your device from start to finish.
The tool is part of EditSafely's CSV Tools section, 133 single-purpose utilities built around the same idea: open the page, get the result, keep your data to yourself.
You can shape the output with 2 settings, including Current delimiter (\t for tab) and New delimiter (\t for tab), and the result refreshes the moment you change one. A worked example further down the page shows exactly what the tool produces for a real input.
That local-first design has practical benefits beyond privacy. The tool keeps working on a flaky connection once the page has loaded, results are instant because nothing round-trips to a server, and it is safe to use with confidential material.
Frequently asked questions
Does Change CSV Delimiter cost anything?
Yes, it is completely free. All 2,658 tools on EditSafely work without an account, a subscription or usage limits.
Is it safe to paste sensitive or confidential data?
No data leaves your device. The whole tool is JavaScript that runs inside your browser tab, so there is no upload, no server-side processing and no log of what you did. If you disconnect from the internet after the page loads, it keeps working.
How much text can I process at once?
There is no fixed limit. Because the work happens on your own device rather than on a shared server, the practical ceiling is your machine's memory, which comfortably handles inputs far larger than typical online tools allow.
Do I need to sign up or install anything?
Nothing to install and no account needed. Open the page in any up-to-date browser, including on a phone or tablet, and the tool is ready.
How do I use the result?
The output panel has a one-click copy button, and you can keep refining the input while you work; the result updates in place as you type.