Simple and free online TSV column truncator. Just paste a Tab Separated Values table into the form below, choose which columns to shorten, and set the final cell length. You can truncate values from the left or right side, add an indicator where text was removed, shorten the header row, and skip comment or empty rows before truncation. Created by programmers from team Browserling.
Simple and free online TSV column truncator. Just paste a Tab Separated Values table into the form below, choose which columns to shorten, and set the final cell length. You can truncate values from the left or right side, add an indicator where text was removed, shorten the header row, and skip comment or empty rows before truncation. Created by programmers from team Browserling.
This online tool truncates columns in Tab Separated Values (TSV) files. It is useful when long TSV fields make a table hard to view or process. Instead of editing every row by hand, the tool keeps the tabs as field separators and shortens only the TSV columns you choose. It shortens each selected cell value to the given length. If the "Truncate Right Side" mode is selected, truncation is performed at the end of cells, keeping the beginning of each value. If the "Truncate Left Side" mode is selected, truncation is performed at the beginning of cells, keeping the ending of each value. You can also place one or more symbols in place of the truncated fragment by using the "Add Truncation Indicator" option. The indicator characters count as part of the final cell length. You can apply truncation to the entire table or select specific columns. Columns can be chosen by number, using values such as "1", "2-4", "1, 3-5", or "-1" for the last column. They can also be chosen by header name, with one header entered per line. If a selected header occurs in several places, the tool can shorten all columns with that header. The header row can be truncated too, so long column titles follow the same length rule as the data rows. If the column titles should stay unchanged, disable the "Truncate Header Row" option. Before truncation runs, the cleanup options can skip comment rows and remove empty rows from the TSV input. Tsv-abulous!
This online tool truncates columns in Tab Separated Values (TSV) files. It is useful when long TSV fields make a table hard to view or process. Instead of editing every row by hand, the tool keeps the tabs as field separators and shortens only the TSV columns you choose. It shortens each selected cell value to the given length. If the "Truncate Right Side" mode is selected, truncation is performed at the end of cells, keeping the beginning of each value. If the "Truncate Left Side" mode is selected, truncation is performed at the beginning of cells, keeping the ending of each value. You can also place one or more symbols in place of the truncated fragment by using the "Add Truncation Indicator" option. The indicator characters count as part of the final cell length. You can apply truncation to the entire table or select specific columns. Columns can be chosen by number, using values such as "1", "2-4", "1, 3-5", or "-1" for the last column. They can also be chosen by header name, with one header entered per line. If a selected header occurs in several places, the tool can shorten all columns with that header. The header row can be truncated too, so long column titles follow the same length rule as the data rows. If the column titles should stay unchanged, disable the "Truncate Header Row" option. Before truncation runs, the cleanup options can skip comment rows and remove empty rows from the TSV input. Tsv-abulous!
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.
In this example, we truncate only the first and last columns in a TSV country table. We use a comma-separated list of column positions "1, -1", where the negative position selects the final column. The truncation is performed from the left, leaving four original characters. Before truncating the data, we also remove empty rows and skip the "# outdated currency data" comment row.
This example truncates TSV columns containing car make and model information and adds an ellipsis indicator for the removed characters. We select the columns by header name, using "Make" and "Model", so only these two columns are shortened. Truncation is performed on the right side, keeping the leading symbols of each value. The final length is 5 characters, including four original characters plus the ellipsis marker.
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!
Find the complexity of a TSV file.
Create an abstract drawing that shows the structure of a TSV.
Show a TSV file in a neat editor and allow easy editing.
Convert a TSV file to a double-TSV file.
Convert a double-TSV file to a regular TSV file.
Convert a Tab Separated Values file to an HTML table.
Convert an HTML table to a Tab Separated Values file.
Convert a TSV file to a Markdown table.
Convert a Markdown table to a TSV file.
Convert a Tab Separated Values file to a PDF document.
Convert a PDF document to a Tab Separated Values file.
Draw Tab Separated Values as a table and output it as an image.
Extract data in an image and format it as a TSV file.
Convert a Tab Separated Values file to an Excel spreadsheet.
Convert an Excel file to a Tab Separated Values file.
Convert a TSV file to LaTeX code that generates a table.
Convert a Tab Separated Values file to a neat ASCII table.
Convert an ASCII table to a Tab Separated Values file.
Convert a Tab Separated Values file to an SQL query.
Convert a Tab Separated Values file to an SQLite database.
Export tables from an SQLite database as TSV files.
Convert a TSV file to a PSV (Pipe Separated Values) file.
Convert a PSV (Pipe Separated Values) file to a TSV file.
Convert a TSV file to a HSV (Hash Separated Values) file.
Convert a HSV (Hash Separated Values) file to a TSV file.
Convert a TSV file to a SSV (Semicolon Separated Values) file.
Convert a SSV (Semicolon Separated Values) file to a TSV file.
Convert a TSV file to a 0SV (Null Separated Values) file.
Convert a 0SV (Null Separated Values) file to a TSV file.
Create multiple TSV files from the given TSV file.
Merge together two Tab Separated Values files.
Remove columns that have no values in a TSV file.
Remove rows that have no values in a TSV file.
Remove lines in a TSV file that are blank.
Delete TSV lines that are comments.
Filter rows and columns that match a pattern.
Find certain values in TSV cells.
Extract repeated rows in a TSV file.
Combine duplicate rows in a TSV file.
Remove repeated rows from a TSV file.
Delete duplicate rows from a TSV file.
Minify a TSV file and remove extra spaces and indentation.
Diff two TSV files and visually display the differences.
Rotate TSV columns to the left or right.
Rotate TSV rows up or down.
Cut a fragment from a TSV file.
Extract a slice (rows/columns/cells) of a TSV file.
Shuffle all data values in a TSV file.
Shuffle the order of TSV columns.
Shuffle the order of TSV rows.
Sort values in a TSV rows.
Find how many columns there are in the given TSV data.
Find how many rows there are in the given TSV data.
Find how many total entries there are in a TSV file.
Add colors to TSV data for easy visual overview of the file.
Create random errors in a TSV file for fuzz testing.
Generate a custom TSV with n rows and m columns.
Open a TSV file directly in your browser.
Subscribe to our updates. We'll let you know when we release new tools and features, and when we organize online workshops.
Enter your email here
We're Browserling — a friendly and fun cross-browser testing company powered by alien technology. At Browserling, we love to make developers' lives easier, so we created this collection of online TSV tools. Our tools have the simplest user interface that doesn't require advanced computer skills and they are used by millions of people every month. Behind the scenes, all our TSV tools are actually powered by our programming tools that we created over the last couple of years. Check them out!
