onlinetsvtools logo

Tsv column truncator

World's simplest tsv tool

World's simplest online Tab Separated Values column truncator. Just paste your existing TSV in the form below, adjust the length option, select columns to truncate, and they will instantly get shortened to this length. Free, quick and very powerful. Paste TSV – truncate its columns. Created by programmers from team Browserling.
announcement a new project!
Super exciting news! We just launched MATHURLS – a fun math news reader. Check it out!
Truncation Side
Crop TSV columns on the right side.
Crop TSV columns on the left side.
Truncate the titles of TSV columns.
Length and Indicator
The new TSV cell length.
Use this (or these) symbols in place of truncated fragments.
Columns to Truncate
List the column numbers you want to truncate.
Column numbers can be entered as comma-separated or as a range. To truncate all TSV columns, enter the asterisk symbol.
Tsv column truncator tool What is a tsv column truncator?
This browser-based utility truncates columns of Tab Separated Values (TSV) files. It shortens each value in each cell to the given length. If the "Truncate Right Side" mode is selected, truncation is performed at the end of cells; if the "Truncate Left Side" mode is selected, truncation is performed at the beginning of cells. By default, it truncates all tab-delimited values except the first line, which is usually the title line. If you also want to make the titles shorter, then enable the "Truncate First Row" option. You can truncate all TSV columns or only the specified ones. To list the columns that need to be truncated, use the comma-separated format: "1, 2, 3, ...", the range format: "1-3", or combine them: "1, 3-5, 8". To cut all columns at once, enter the asterisk symbol "*". You can also place one or more symbols in place the truncated fragment by using the "Truncation Indicator" option. Simple and easy!
Tsv column truncator examples Click to use
Months of the Year
In this example, we truncate the month names in tab-separated lists of seasons. There are four lists and they are formatted as four TSV columns, one for each season of the year, and four rows. The first row is the title row and we leave it unchanged. All other rows contain full month names and they are reduced to abbreviations with 3 characters in each month's name.
Spring Summer Autumn Winter March June September December April July October January May August November February
Spring Summer Autumn Winter Mar Jun Sep Dec Apr Jul Oct Jan May Aug Nov Feb
Required options
These options will be used automatically if you select this example.
Crop TSV columns on the right side.
Truncate the titles of TSV columns.
The new TSV cell length.
Use this (or these) symbols in place of truncated fragments.
List the column numbers you want to truncate.
TSV Countries
In this example, we use an option that shortens only two columns (out of four) and another option that also applies the truncation operation to the titles. To indicate which columns will be truncated, we use a comma-separated list of column position numbers. By writing "1, 4" in this option, only the first and fourth columns get truncated. The cells are truncated on the left side, leaving only four characters.
Country Name Capital Language Currency Note Angola AGO Luanda Portuguese kwanza AOA Armenia ARM Yerevan Armenian dram AMD Croatia HRV Zagreb Croatian kuna HRK Estonia EST Tallinn Estonian euro EUR Japan JPN Tokyo Japanese yen JPY
Name Capital Language Note AGO Luanda Portuguese AOA ARM Yerevan Armenian AMD HRV Zagreb Croatian HRK EST Tallinn Estonian EUR JPN Tokyo Japanese JPY
Required options
These options will be used automatically if you select this example.
Crop TSV columns on the left side.
Truncate the titles of TSV columns.
The new TSV cell length.
Use this (or these) symbols in place of truncated fragments.
List the column numbers you want to truncate.
Car Make-model-year
This example truncates TSV columns with car information and adds an ellipsis indicator in place of truncated characters. It cuts characters only from the 1st and 2nd columns the cutting is performed on the right side. The range format "1-2" specifies an inclusive range of columns to cut. The truncation length is 5 and that includes four text characters plus the specified postfix.
Make Model Year Honda Accord 2009 Toyota Camry 2012 Hyundai Elantra 2010 Ford Escape 2015 Nissan Altima 2015
Make Model Year Hond… Acco… 2009 Toyo… Camr… 2012 Hyun… Elan… 2010 Ford… Esca… 2015 Niss… Alti… 2015
Required options
These options will be used automatically if you select this example.
Crop TSV columns on the right side.
Truncate the titles of TSV columns.
The new TSV cell length.
Use this (or these) symbols in place of truncated fragments.
List the column numbers you want to truncate.
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/truncate-tsv-columns?input=Spring%09Summer%09Autumn%09Winter%0AMarch%09June%09September%09December%0AApril%09July%09October%09January%0AMay%09August%09November%09February&truncate-right=true&truncate-first-row=false&length=3&use-truncate-char=false&truncate-char=&truncate-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.