Change CSV Separator
Swap a CSV file from commas to semicolons, tabs, pipes, or any character you choose.
Runs entirely in your browser.
Change the Delimiter in a CSV File
About Change CSV Separator
Changing the delimiter is not a search and replace. A comma inside a quoted field is part of the data, not a separator, so the file has to be parsed properly and written out again - which is what this does. Fields are re-quoted only where the new delimiter makes it necessary.
The usual reason to do this is Excel. In locales that use a comma as the decimal separator, Excel expects semicolon-separated files and will drop a comma-separated one into a single column. Converting to semicolons fixes that without touching the data.
Other CSV Tools
- Transpose CSV — swap rows and columns
- Find Incomplete CSV Records — rows with missing or extra fields
- Insert a CSV Column — add a column at any position
- Swap CSV Columns — exchange two column positions
- CSV to TSV — and back
- CSV to XML — and back
- CSV to YAML — and back
- TSV to JSON — and back
- JSON to CSV — and back
- CSV Viewer — browse a CSV as a sortable table
- CSV to Markdown — build a Markdown table
