CSV Escape / Unescape

CSV Escape & Unescape — RFC 4180 field quoting

A CSV field that contains the delimiter (comma), a double quote, or a line break will corrupt the table unless it is quoted and escaped. RFC 4180 defines the rule: wrap such a field in double quotes and double any embedded quote. This tool applies it (and reverses it) in your browser.

The rule

• Field has a comma, quote or newline → wrap in " ".
• Embedded " → write it as "".
• Otherwise → leave the field bare.

Example

San Francisco, CA and 6" nail become:

"San Francisco, CA"
"6"" nail"

Correct quoting is what stops a stray comma from shifting every column — the most common cause of a broken spreadsheet import.

Related tools

• String Escaper — all-format hub
• CSV Viewer — view CSV as a table
• JSON to CSV — convert JSON to CSV
• SQL Escape — escape SQL literals