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

Text Tools

Delete a Column from CSV

Delete one selected column from CSV by header name or column number.

Tool

Use this Delete a Column from CSV tool to remove one selected column from CSV data. It is useful for cleaning exports, removing unwanted fields, preparing imports, simplifying reports, and quickly deleting a column without editing every row manually.

About this tool

Use this Delete a Column from CSV tool to remove one selected column from CSV data. It is useful for cleaning exports, removing unwanted fields, preparing imports, simplifying reports, and quickly deleting a column without editing every row manually.

Use delete a column from csv 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 header name or 1-based column number on the first line
  2. Add a blank line
  3. Paste the CSV below it
  4. Click Run Tool to remove the selected column
  5. Review the updated CSV output

Examples

Example

Input

email

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

Output

name,role
John,admin
Anna,editor

Removes the selected header from all rows.

Example

Input

2

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

Output

name,role
John,admin
Anna,editor

Uses 1-based column numbering.

Common errors

Forgetting the blank line between selector and CSV body

Fix: Put the selector first, then a blank line, then the CSV data.

Using a column name that does not exist

Fix: Check the CSV header row and use the exact header text.

Using index 0 instead of 1

Fix: This tool uses 1-based column numbering.

FAQ

What does Delete a Column from CSV do?

It removes one selected column from CSV data and returns the updated CSV.

Can I select a column by header name?

Yes. Put the exact 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 other columns in the same order?

Yes. It removes only the selected column and keeps the rest in order.

What if the column does not exist?

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

Use cases

Related tools