Cut a TSV File extracts specific columns from your tab-separated data using live input and customizable field selection. Paste, trim, export fast and clean.
How to Use:
- Paste or import your TSV data into the input box on the left.
- Enter which columns to keep using 1-based indexes (e.g.,
1,3) in the Columns to Keep field. - Toggle Trim cell whitespace to remove extra spaces from each field.
- Use Maximize output to expand the results box if needed.
- The output updates instantly on the right side.
- Click Copy Output to copy the extracted columns or Export to File to download the result.
- Hit Clear All to reset everything and start over.
What Cut a TSV File can do:
Cut a TSV File gives you an easy way to pull out only the columns you care about from a tab-separated dataset. You enter a list of columns using 1-based positions, and it slices your TSV accordingly. It’s useful when you’ve got wide datasets but only want a few fields for example, keeping just names and emails or just coordinates.
The live preview shows your result instantly, and you can trim whitespace to avoid formatting issues. It’s great for cleaning data before imports, formatting for upload, or quickly prepping fields for analysis.
Example:
Input:
name age city email
Alice 30 NY [email protected]
Bob 25 LA [email protected]Columns to Keep: 1,3Trim cell whitespace: ON
Output:
name city
Alice NY
Bob LACommon Use Cases:
This tool helps when you’re preparing TSVs for import, trimming down wide files, or exporting just what you need. It’s ideal for developers, analysts, and anyone cleaning or restructuring data on the fly.
Useful Tools & Suggestions:
After you Cut a TSV File, try TSV Column Exporter if you want more control over which fields to pull out. And once you’ve trimmed things down, Validate TSV makes sure the structure still holds up.