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

Text Tools

Extract a Column from TSV

Extract one specific column from TSV data by column number or header name.

Tool

Use this TSV column extractor to pull one column from tab-separated data by column index or header name. It is useful for exports, quick cleanup, analysis, and preparing single-field lists.

About this tool

Use this TSV column extractor to pull one column from tab-separated data by column index or header name. It is useful for exports, quick cleanup, analysis, and preparing single-field lists.

Use extract a column from tsv 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. Enter the column name or 1-based column number on the first line
  2. Leave a blank line
  3. Paste the TSV data below
  4. Run the tool
  5. Review the extracted values line by line

Examples

Example

Input

email

name	email	role
John	john@example.com	admin
Jane	jane@example.com	user

Output

john@example.com
jane@example.com

Useful when you know the field name.

Example

Input

2

name	email	role
John	john@example.com	admin
Jane	jane@example.com	user

Output

john@example.com
jane@example.com

Column index is 1-based, so 2 means the second TSV column.

Common errors

Forgetting the blank line between selector and TSV body

Fix: Put the header or index first, then a blank line, then the TSV data.

Using a column name that does not exist

Fix: Check the first TSV row and use the exact header text.

Using index 0 instead of 1

Fix: This tool uses 1-based column numbering.

FAQ

What does Extract a Column from TSV do?

It extracts one selected column from TSV data and returns the values line by line.

Can I select a column by header name?

Yes. Put the header name on the first line.

Can I select a column by number?

Yes. Use a 1-based column number on the first line.

Does it keep the header row?

No. It returns the values below the header row.

What if the column does not exist?

The tool returns an error message so you can fix the selector.

Use cases

Related tools