Insert a TSV column into existing tab-separated data. Paste your table and new column, choose the position, and get merged output instantly.
How to Use:
- Paste your base table into the Original TSV box.
- Paste the values for the new column into the New Column Data box (top-to-bottom, one per row).
- Use the Insert at index field to choose where the new column should appear (starting from 0).
- Toggle Trim each cell to clean extra whitespace from the values.
- Enable Maximize Output if you need more space to view the result.
- Click Insert to merge the column into the table.
- Use Copy Output to copy the result or Export to File to download it.
- Press Clear All to reset the input, output, and toggles.
What Insert a TSV Column can do:
Insert a TSV Column helps you add a new column of data into an existing TSV dataset without needing a spreadsheet or script. Just paste your table, define the new column values, and choose where to place them. It handles different row lengths, trims cells cleanly, and updates live in your browser. You can export the result immediately for use elsewhere.
Example:
Original TSV:
id name age
1 Alice 30
2 Bob 25
3 Charlie 35
New Column:
country
US
US
CA
Insert at index: 1
Output:
id country name age
1 US Alice 30
2 US Bob 25
3 CA Charlie 35
Common Use Cases:
Use Insert a TSV Column to add metadata, notes, tags, country codes, or additional values to exported TSV files. It’s perfect for editors, researchers, and engineers who need to inject columns into clean data formats quickly and without Excel.
Useful Tools & Suggestions:
Once you’ve used Insert a TSV Column, try TSV Column Replacer if you need to update values in that new field right away. And if you’re aiming for cleaner formatting, Trim TSV Columns helps tidy things up after the insert.