TextArray
100% local

Change CSV delimiter

Swap the column separator in CSV data between comma, semicolon, tab and pipe.

Input
Output

Change CSV delimiter

A CSV file is only as portable as its separator. Excel on a Slovak, Czech, German or Polish system expects a semicolon and drops a comma-separated file into one useless column, while most APIs, databases and English-locale spreadsheets expect a comma. This tool rewrites the character between columns so the same data opens correctly wherever it lands: comma to semicolon for a colleague's Excel, semicolon back to comma for an import script, or either one to a tab for a clean paste into Google Sheets.

Choose the separator your data uses and the one you want, from comma, semicolon, tab, pipe or your own. A custom delimiter may be more than one character, and \t stands for a tab when you need to type one. With quote handling on, the input is read as real CSV rather than as plain text: a value wrapped in double quotes keeps the separator, doubled "" quotes and line breaks inside it, and still counts as a single field.

That matters most on the way out. When you switch to semicolons, a value that already contains a semicolon has to be re-quoted or the row silently gains a phantom column. The tool quotes exactly those values, leaves the rest bare, and drops quotes the new separator no longer requires. Trimming removes the spaces around each value.

Everything runs in your browser, so exports full of customer names, prices or internal IDs are never uploaded. The tally under the output reports the rows, the widest row's column count and how many values had to be quoted — if that column count suddenly reads 1, the input delimiter is set wrong.

FAQ

Why does my CSV open in one column in Excel?
Excel follows your system list separator. On Slovak, Czech, German and Polish installs that is a semicolon, so a comma-separated file lands in a single column. Convert commas to semicolons here and the file opens with proper columns on a double click.
What happens to values that contain the new delimiter?
They get wrapped in double quotes, following RFC 4180. Switching a,"b;c",d to semicolons produces a;"b;c";d, so the value stays one field. Quotes that the new delimiter no longer needs are dropped again.
Can I use a delimiter that is not in the list?
Yes. Pick Custom and type it in — it can be several characters, such as :: or a comma followed by a space. Write \t for a tab and \n for a line break.
When should I turn quote handling off?
Only when your data uses double quotes as ordinary characters and never to wrap fields. With the option off the text is split strictly on the delimiter and quotes are passed through untouched, which corrupts genuine quoted CSV.
Is my file uploaded anywhere?
No. The conversion runs entirely in your browser and your data never leaves your device.