Preview 0
Only the first 100 rows are shown. The downloaded file contains every row.
Turn a semicolon-separated CSV into a comma-separated one, or the reverse. Your file never leaves this computer.
Only the first 100 rows are shown. The downloaded file contains every row.
CSV stands for "comma-separated values", but not every country uses commas. In languages where the decimal separator is a comma, such as German, French and Turkish, Excel saves CSV files with semicolons so amounts like 1.250,50 stay in one cell.
The trouble starts when you hand that file to a system that expects commas. Upload a semicolon-separated CSV to Google Sheets, an online shop, an email marketing tool or an English-language Excel and every row shows up in a single column. The same happens the other way round when a comma-separated file is double-clicked in a German or French Excel.
It detects the file's current delimiter automatically and rewrites the file with the one you choose. If a cell contains the delimiter character, such as a comma in an address field, the cell is wrapped in quotes so the columns do not shift. The row and column counts appear in the preview, so you can check before you download.
You can also convert to tab-separated files if needed; some older systems and database tools prefer that format.
Instead of double-clicking the file, use Data > From Text/CSV in Excel and choose the delimiter yourself. But if you are giving the file to someone else or to another system, setting the right delimiter up front is simpler.
Conversion happens in your browser. Your file is never uploaded to a server or stored.
In languages where the decimal separator is a comma, Excel uses a semicolon as the CSV delimiter. For programs that expect comma-separated CSV you can change it here.
The tool wraps such cells in quotes automatically, so columns do not shift.
Yes. You can convert in any direction between tab, semicolon, comma and pipe.