Tabular data guides

Change a semicolon export into comma-separated records

·

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.

RFC 4180 — CSV format and media type

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.

Semicolon-separated shipment
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.

Related guides