Simple online tools for developers, networking, text and conversions.

Text Tools

Append a TSV Column

Add a new TSV column at the end of every row.

Tool

Use this tool to append a new column to TSV data. It is useful when you need to add notes, tags, extra calculated values, labels, or other trailing fields without editing rows manually.

About this tool

Use this tool to append a new column to TSV data. It is useful when you need to add notes, tags, extra calculated values, labels, or other trailing fields without editing rows manually.

Use append a tsv column when you need a fast browser-based result without extra setup. It works well for quick checks, one-off tasks, and routine formatting or calculation work.

Learn more

Why use this tool

How to use

  1. Put the new column header on the first line
  2. Put one value per TSV row after that
  3. Leave a blank line
  4. Paste the TSV below
  5. Run the tool to add the new last column

Examples

Example

Input

status
active
active

name	role
John	admin
Anna	editor

Output

name	role	status
John	admin	active
Anna	editor	active

Useful when you want to append the same kind of field after existing data.

Example

Input

note
ok
review

id	title
1	Book
2	Pen

Output

id	title	note
1	Book	ok
2	Pen	review

Appends a new trailing field to each row.

Common errors

The number of new values does not match the number of TSV data rows

Fix: Provide one new value for each TSV row below the header.

Forgetting the blank line before the TSV body

Fix: Put the new header and values first, then a blank line, then the TSV.

Using spaces instead of real tabs in the TSV

Fix: Make sure the TSV itself uses tab-separated columns.

FAQ

What does Append a TSV Column do?

It adds a new column at the end of the TSV and fills it with your provided values.

Do I need one value per row?

Yes. You should provide one value for each TSV data row.

Does it change the existing columns?

No. It only adds a new last column and keeps the others in place.

What if my values count does not match the row count?

The tool returns an error so you can fix the input.

How is it different from Prepend a TSV Column?

Append adds the new column last, while Prepend adds it first.

Use cases

Related tools