CSV Unescape
Turn one quoted CSV field back into its value: strip the surrounding quotes and un-double the inner ones.
What unescaping a CSV field does
A quoted field loses its surrounding quotes and each doubled quote becomes one. A trailing line break is ignored, because a field copied out of a spreadsheet cell usually brings one. A quote inside a quoted field that is not doubled is reported rather than guessed, and a field that would need quoting but is not quoted is refused with a pointer to the escape page.
How to use it
CSV Unescape: paste the CSV field into the box above, and press Run to get the value below.
Worked example
Input:
"Smith, ""J"""
Output:
Smith, "J"
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads CSV field and returns value; reloading the page discards both.
A quoted field loses its surrounding quotes and each doubled quote becomes one. A trailing line break is ignored, because a field copied out of a spreadsheet cell usually brings one. A quote inside a quoted field that is not doubled is reported rather than guessed, and a field that would need quoting but is not quoted is refused with a pointer to the escape page.
Turn one quoted CSV field back into its value: strip the surrounding quotes and un-double the inner ones.
How to use it
CSV Unescape: paste the CSV field into the box above, and press Run to get the value below.
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads CSV field and returns value; reloading the page discards both.
What to Expect
Best for
- Converting CSV field to value when the data is already on screen.
What this tool keeps
- Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere.
Sample input
"Smith, ""J"""
Sample output
Smith, "J"
Frequently asked questions
How do I use the csv unescape?
CSV Unescape: paste the CSV field into the box above, and press Run to get the value below.
Is my input uploaded?
No. The text is parsed on this page with JavaScript and is never posted to a server.
Is there a size limit?
Yes: 5 MB per run. Larger input is refused with a message rather than freezing the tab.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.