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

Text Tools

Prepend a TSV Column

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

Tool

Use this tool to prepend a new column to TSV data. It is useful when you need to add a fixed field, source tag, environment marker, or other leading column before existing TSV data.

About this tool

Use this tool to prepend a new column to TSV data. It is useful when you need to add a fixed field, source tag, environment marker, or other leading column before existing TSV data.

Use prepend 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 first column

Examples

Example

Input

source
api
api

name	role
John	admin
Anna	editor

Output

source	name	role
api	John	admin
api	Anna	editor

Useful when you want every row labeled with its source.

Example

Input

env
prod
prod

id	title
1	Book
2	Pen

Output

env	id	title
prod	1	Book
prod	2	Pen

Adds a new leading field before the existing TSV columns.

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 Prepend a TSV Column do?

It adds a new column at the beginning 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 first 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 Append a TSV Column?

Prepend adds the new column first, while Append adds it at the end.

Use cases

Related tools