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

Text Tools

Insert a TSV Column

Insert a new TSV column at a chosen 1-based position.

Tool

Use this tool to insert a new column into TSV data at a specific position. It is useful when imports, reports, or workflows require a new field in the middle of an existing TSV structure.

About this tool

Use this tool to insert a new column into TSV data at a specific position. It is useful when imports, reports, or workflows require a new field in the middle of an existing TSV structure.

Use insert 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 1-based insert position on line one
  2. Put the new column header on line two
  3. Put one value per TSV row after that
  4. Leave a blank line
  5. Paste the TSV below and run the tool

Examples

Example

Input

2
email
john@example.com
anna@example.com

name	role
John	admin
Anna	editor

Output

name	email	role
John	john@example.com	admin
Anna	anna@example.com	editor

Useful when a required field must appear in a specific position.

Example

Input

3
region
EU
US

id	title	status
1	Book	ok
2	Pen	ok

Output

id	title	region	status
1	Book	EU	ok
2	Pen	US	ok

Adds a new field into the middle instead of only first or last.

Common errors

Using index 0 instead of 1

Fix: This tool uses 1-based column positions.

The values count does not match the TSV row count

Fix: Provide one new value for each TSV data row.

Using a position outside the valid range

Fix: Use a position from 1 to header length plus 1.

FAQ

What does Insert a TSV Column do?

It adds a new column at a chosen 1-based position in the TSV.

Can I insert at the beginning or end?

Yes. Position 1 inserts first, and the last valid position inserts at the end.

Do I need one value per row?

Yes. The number of values should match the number of TSV data rows.

What if the position is invalid?

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

How is it different from Prepend or Append?

Insert lets you choose the exact position instead of only first or last.

Use cases

Related tools