CSV delimiter detector
Find out whether a CSV uses commas, semicolons, tabs or pipes, preview the table and convert it to another separator.
How to useDetect the CSV separator.
Available in: 
CSV delimiter detector: what it is for
Paste or open a CSV and the tool finds the separator by comparing comma, semicolon, tab, pipe and colon, respecting quotes. It shows each candidate's score, the number of rows and columns and a table preview, and converts the file to another separator, with a BOM so Excel shows accented characters correctly.
Everything runs in your browser: nothing you paste or open is sent to a server.
How to use
- Paste the CSV or open the file.
- Check the detected separator and preview.
- Convert and download with another separator.
When to use it
- Open a CSV in Excel without everything in one column.
- Prepare files for import.
- Check exports from other systems.
Frequently asked questions
Why does Excel open my CSV all in one column?
Because the file's separator is different from the one Excel expects. In many European countries and Brazil, Excel uses semicolons because the comma is the decimal separator. Convert the file to the separator Excel expects and it opens correctly.
How does detection work?
The tool tries each separator on the first lines, respecting quotes, and picks the one that gives the same number of columns on every line, with more than one column.
Is my file uploaded anywhere?
No. Everything happens in your browser.
Is it really free?
Yes, 100% free. No sign-up, no subscription and no usage limits. All Tools123 are free.