Unquote TSV Columns

strip surrounding quotes · doubled quotes collapsed

Remove the double quotes that wrap cell values, collapsing any doubled quotes inside them back to single characters. Useful when a producer quoted everything defensively and the quotes are now in your way — a database load that treats them as part of the value, a diff that shows spurious changes, or a file that's simply harder to read than it needs to be.

How to use

1. Paste or drop the file.
2. Copy or download. Quotes wrapping a value are removed; quotes inside a value are left alone.
3. Check the column count afterwards with the validator if any field might have contained a tab.

The one case where this breaks a file

If a quoted field genuinely contains a tab or a newline, the quotes were the only thing marking where that field ended. Remove them and the tab becomes a delimiter — the row silently gains a column, and every value after it shifts. The validator will show it as ragged; fix ragged rows can make it rectangular again but cannot put the data back in the right columns.

So: unquote freely when the quoting was cosmetic, and use escape tabs and newlines instead when fields have real tabs in them. That converts the quoting into \t escapes, which is unquoted and safe.

What it does precisely

A value wrapped in matching double quotes has them removed, and "" inside becomes ". A value with a quote only at one end, or quotes in the middle, is left exactly as it is — a lone quote is more likely to be data than broken syntax, and guessing would corrupt it.

FAQ

Privacy

100% client-side. No upload. See the privacy policy.