Append TSV columns online. Paste or upload two TSV datasets side by side and merge them column-wise with live preview and export support.
How to Use:
- Paste your first dataset into the Left TSV box and your second dataset into the Right TSV box.
- Use the Trim each cell toggle to clean extra spaces from each field before merging.
- Toggle Maximize Output if you need more space to view wide output.
- Click Append to join the columns together, line by line.
- Use Copy Output to copy the result or Export to File to save it as
.tsv
. - Click Clear All to reset both inputs, output, toggles, and the row count.
What Append TSV Columns can do:
Append TSV Columns merges two TSV blocks horizontally. Each row from the left is matched with the row from the right, and their columns are combined. If one side has more rows than the other, the extra rows are filled with blanks. It’s great for combining datasets with matching row structure but different attributes. Everything updates live, right in your browser, and never leaves your device.
Example:
Left TSV:
id name
1 Alice
2 Bob
3 Charlie
Right TSV:
age city
30 NY
25 LA
35 Chicago
Output:
id name age city
1 Alice 30 NY
2 Bob 25 LA
3 Charlie 35 Chicago
Common Use Cases:
Use Append TSV Columns when you want to merge attributes across files, match metadata with core records, or combine exported fields from different systems. It’s perfect for analysts, devs, or anyone working with structured tab-separated data who wants to horizontally combine rows.
Useful Tools & Suggestions:
After using Append TSV Columns, Display TSV Statistics gives you a quick look at how your table changed. And if the new data needs rearranging, TSV Column Swapper makes it easy to shift things into the right order.