onlinetsvtools logo

Tsv column dequoter

World's simplest tsv tool

World's simplest online Tab Separated Values column unquoter. Just paste your existing TSV file in the form below, adjust the character that surrounds TSV values and select columns to unquote in the options, and they will instantly get cleaned of quotes. Free, quick and very powerful. Paste TSV – dequote TSV values. Created by programmers from team Browserling.
announcement a new site!
We just launched a new site – Online Unicode Tools – utilities for working with Unicode. Check it out!
Quotes and Recursion
Enter quote characters you want to remove.
Remove multiple layers of quotation marks.
Trim Cells
Delete extra spaces before unquoting.
Delete extra spaces after unquoting.
Columns to Unquote
The column numbers you want to unquote or the * character (matches all columns).
Indicate column positions individually: 1, 2, 5; or using a range: 1-4; or both: 1, 2, 4-6.
Tsv column dequoter tool What is a tsv column dequoter?
This browser-based utility dequotes TSV cells. It can remove multiple quote types at once in one or more columns. For example, if the first column uses double quotation marks " and the second column uses single quotation marks ', then just enter both quotes in the "Unquote Marks" option and they'll both get deleted. If you want to clean only certain columns, specify their ordinal numbers in the "Columns to Unquote" option. Supported formats are individual columns, such as "1, 3, 5", a range of adjacent columns, such as "1-6", or a combination of both formats, such as "2, 4, 6-8". If you want to unquote all input columns at once, simply enter the asterisk symbol "*". To get rid of unwanted spaces in the TSV cells, use the trimming options. The "Trim Input" mode removes spaces before unquoting and the "Trim Output" option removes spaces after a cell has been unquoted. If your TSV columns contain multiple layers of quotation marks, activate the "Recursive Unquote" option. It applies the unquoting algorithm several times until all quotes that you specified are removed. TSVabulous!
Tsv column dequoter examples Click to use
Periodic Table Elements
In this example, we unquote a TSV file with the periodic table of elements. The tab-separated values use regular double quotes, so we enter the symbol " in the "Unquote Marks" field. To clean all the columns at once, we enter the star symbol * in the "Columns to Unquote" option, which matches all columns of the input file.
Element Phase Symbol Sodium "solid" "Na" "Argon" "gas" "Ar" "Iron" "solid" "Fe" Mercury liquid "Hg" Carbon "solid" "C" "Neon" "gas" "Ne" Bromine liquid "Br"
Element Phase Symbol Sodium solid Na Argon gas Ar Iron solid Fe Mercury liquid Hg Carbon solid C Neon gas Ne Bromine liquid Br
Required options
These options will be used automatically if you select this example.
Enter quote characters you want to remove.
Remove multiple layers of quotation marks.
Delete extra spaces before unquoting.
Delete extra spaces after unquoting.
The column numbers you want to unquote or the * character (matches all columns).
Cat Breeds
This example uses two different quote characters in TSV cells. In the second column, it's the asterisk symbol and in the third column, it's the single quote symbol. To dequote the 2nd and 3rd columns, we enter their numbers in the columns field and specify both characters * and ' in the quote marks field. We also activate the trim input option to remove unwanted spaces before unquoting.
Breed Origin Eyes Siamese *China* 'blue' Bombay *U.S.* 'green' Sphynx Ontario 'blue' Birman France 'blue' Ragdoll *U.S.* 'blue'
Breed Origin Eyes Siamese China blue Bombay U.S. green Sphynx Ontario blue Birman France blue Ragdoll U.S. blue
Required options
These options will be used automatically if you select this example.
Enter quote characters you want to remove.
Remove multiple layers of quotation marks.
Delete extra spaces before unquoting.
Delete extra spaces after unquoting.
The column numbers you want to unquote or the * character (matches all columns).
Cosmic Ray Damage
The sales table in this example was damaged by cosmic rays and the third column got several layers of extra quotation marks added around it. The second column got hit too and double quotes changed to the ~ symbol in the last row. To undo the damage and clean up the file and remove both external and internal layer quotation marks, we activated the "Recursive Unquote" option and entered all quote symbols in the options. We also cleared the values from extra spaces before and after dequoting. To do the job, we specified the range of columns 2-3 in the options and left the first column unchanged as it wasn't damaged.
Product sold % of sales "chair" "4320" '~40% ~' "table" "2102" '~ 30% ~' "sofa" ~1286~ '~22%~'
Product sold % of sales "chair" 4320 40% "table" 2102 30% "sofa" 1286 22%
Required options
These options will be used automatically if you select this example.
Enter quote characters you want to remove.
Remove multiple layers of quotation marks.
Delete extra spaces before unquoting.
Delete extra spaces after unquoting.
The column numbers you want to unquote or the * character (matches all columns).
Pro tips Master online tsv tools
You can pass input to this tool via ?input query argument and it will automatically compute output. Here's how to type it in your browser's address bar. Click to try!
https://onlinetsvtools.com/unquote-tsv-columns?input=Element%09Phase%09Symbol%0ASodium%09%22solid%22%09%22Na%22%0A%22Argon%22%09%22gas%22%09%22Ar%22%0A%22Iron%22%09%22solid%22%09%22Fe%22%0AMercury%09liquid%09%22Hg%22%0ACarbon%09%22solid%22%09%22C%22%0A%22Neon%22%09%22gas%22%09%22Ne%22%0ABromine%09liquid%09%22Br%22&unquote-chars=%22&recursive=false&trim-input=false&trim-output=false&unquote-column=%2A
All tsv tools
Didn't find the tool you were looking for? Let us know what tool we are missing and we'll build it!
Quickly convert a TSV file to a JSON data structure.
Quickly convert a JSON data structure to TSV format.
Quickly convert a TSV file to XML markup.
Quickly convert XML markup to a TSV file.
Quickly convert a TSV file to YAML markup.
Quickly convert YAML data to a TSV file.
Quickly convert TSV data to CSV data.
Quickly convert CSV data to TSV data.
Quickly convert TSV data to nicely aligned text columns.
Quickly convert text columns to TSV columns.
Quickly convert TSV data to base64 encoding.
Quickly convert base64-encoded TSV data to TSV data.
Quickly convert a TSV file to URL-encoding.
Quickly convert a URL-encoded TSV file back to TSV.
Quickly change TSV delimiter to a new one.
Quickly prepend new columns at the start of a TSV file.
Quickly append new columns at the end of a TSV file.
Quickly insert new columns anywhere in a TSV file.
Quickly extract columns from a TSV file.
Quickly replace columns in a TSV file.
Quickly delete columns in a TSV file.
Quickly swap columns in a TSV file.
Quickly remove extra spaces around TSV columns.
Quickly truncate the contents of TSV cells to any length.
Quickly add quotes around TSV columns.
Quickly remove quotes that surround TSV columns.
Quickly exchange TSV columns with rows.
Quickly exchange TSV rows with columns.
Quickly transpose a TSV file.
Quickly generate random TSV data.
Coming soon These tsv tools are on the way
Display TSV Statistics
Print information about a TSV file.
Convert TSV to HTML
Convert a Tab Separated Values file to an HTML table.
Convert TSV to PDF
Convert a Tab Separated Values file to a PDF document.
Convert TSV to an Image
Draw Tab Separated Values as a table and output it as an image.
Convert TSV to Excel
Convert a Tab Separated Values file to an Excel spreadsheet.
Preview and Edit TSV
Show a Tab Separated Values file in the browser and allow easy editing.
Convert TSV to LaTeX
Convert a Tab Separated Values file to LaTeX code that generates a table.
Convert TSV to an ASCII Table
Convert a Tab Separated Values file to a neat ASCII table.
Convert TSV to SQL
Convert a Tab Separated Values file to an SQL query.
Merge TSV Files
Merge together two Tab Separated Values files.
Delete Empty TSV Columns
Delete columns that have no values in a Tab Separated Values file.
Delete Empty TSV Rows
Delete rows that have no values in a Tab Separated Values file.
Compress TSV
Minify a Tab Separated Values file. Remove extra spaces and indentation.
Diff Two TSV Files
Compare two Tab Separated Values files and visually display the differences.
Randomize TSV Columns
Shuffle the order of TSV columns.
Randomize TSV Rows
Shuffle the order of TSV rows.
Sort TSV Columns
Sort values in a TSV column.
Sort TSV Rows
Sort values in a TSV rows.