Free tool · CSV in · CSV out
CSV delimiter converter
Change the separator of a delimited file. This is the fix for a CSV that opens with everything crammed into column A, which happens when Excel expects a semicolon but the file uses commas, or the other way round.
Paste the data instead
No file yet. Choose one to see how it splits into columns with the detected delimiter.
Preview
How it works
- DetectThe existing delimiter is worked out from the file itself; the grid beside the options shows the result, so a wrong guess is visible immediately.
- RewriteEvery field is re-quoted only where the new delimiter or a line break requires it, so nothing is lost.
- SaveChoose the delimiter your program expects and download the rewritten file.
Questions
Why does Excel put all my columns into column A?
Excel splits CSV rows on the list separator of the Windows region, which is a comma in the United States and a semicolon in many European countries. A file written with the other character lands in a single column. Converting the delimiter to the one your copy of Excel expects fixes it.
Comma or semicolon: which should I choose?
Match the list separator of the machine that will open the file. If decimal numbers use a comma (1,5) the list separator is usually a semicolon; if decimals use a point (1.5) it is usually a comma.
What does the sep= option do?
It writes “sep=;” (or the delimiter you chose) as the first line, which Excel honors when opening the file. Spreadsheet programs other than Excel treat that line as an ordinary data row, so leave it off unless you are feeding Excel directly.
Does this change my values?
No. Only the separators and quoting are rewritten; the text of every field is copied unchanged, including leading zeros.
Keep going
Related tools, and the longer explanations behind them.