CSV Unescape

Unescape CSV strings back to plain text.

Local Your input is processed locally in your browser. Found a problem? Report an issue

What CSV Unescape does

CSV Unescape reverses CSV escaping, turning escape sequences back into the characters they stand for, so you can read text copied from source code, logs or data files.

CSV Unescape examples

The built-in sample

Input

"say ""hello"" & <b>bye</b>"

Output

say "hello" & <b>bye</b>

This is the input that the Load sample button fills in.

One quoted field

Input

"Lovelace, Ada said ""hi"""

Output

Lovelace, Ada said "hi"

The outer quotes are removed and each doubled quote becomes one.

Each output was produced by running this tool on the input above it.

How it works

Unescaping applies these rules in reverse:

Escaped formCharacter
"""""
"'"'
"\"\
"<"<
">">
"&"&
" "line break
" "tab
"␁"control character U+0001

Details and limits

  • One leading and one trailing quote are removed. A whole row such as "a","b" is not split into fields; use CSV to JSON to parse rows.
  • A field without quotes is returned unchanged.
  • A line break inside the quoted field is kept, since a quoted CSV field may span several lines.
  • Some spreadsheet exports put an apostrophe or an equals sign in front of a value to force it to be read as text. Those characters are data as far as CSV is concerned and are not removed.

Questions

Is my data uploaded when I use CSV Unescape?

No. The tool runs in your browser, so what you paste or open is processed on your own device and is not sent to a server.

What does CSV Unescape do?

CSV Unescape reverses CSV escaping, turning escape sequences back into the characters they stand for, so you can read text copied from source code, logs or data files.

Are there any limits I should know about?

One leading and one trailing quote are removed. A whole row such as "a","b" is not split into fields; use CSV to JSON to parse rows. A field without quotes is returned unchanged.

Is there a size limit?

There is no fixed size limit. Everything happens on your device, so very large inputs depend on its memory and can take longer on a phone than on a computer.

Does it work on phones, and is it free?

Yes. It works in any current browser on Android phones, iPhones, tablets and computers. It is free and needs no account or sign-up.