Change a semicolon export into comma-separated records
Admin ·
A delimiter belongs to the structure of a table. Replacing each semicolon in the source can also change a semicolon that belongs to someone’s note.
CSV Delimiter Detector and Converter
Convert a quoted note
Start with name;note on the first line and Ada;"red;blue" on the second. Choose Comma for output. The result is name,note followed by Ada,red;blue. Switching the output back to semicolon puts quotes around red;blue again.
Inspect an ambiguous header
The rows a,b;c and x,y;z form two columns under either comma or semicolon. If the real header is a and b;c, choose Comma as the input separator. Inspect the parsed table before downloading.
Preserve the punctuation in a quoted delivery note
Choose semicolon as input and comma as output. This delivery note contains both punctuation marks as data. After conversion, reopen the result using Comma.
order;note
17;"ring, wait; leave parcel"- The second field should still read ring, wait; leave parcel. The generated CSV quotes that field because its comma would otherwise begin a third column. A global replace of semicolons would change the note itself.
Common questions
Can I convert a one-column list?
Yes. Choose a known input separator manually so detection does not guess from punctuation in the text.
Does a tab-delimited export use a TSV extension?
Yes. Comma output uses .csv, tab output uses .tsv, and pipe or semicolon output uses .txt.
Sources
Put it into practice.
- CSV Delimiter Detector and Converter
- CSV and TSV Validator
- CSV Viewer and HTML Table Exporter
- JSON and CSV Converter