Delete or Keep Columns Online

Remove unwanted columns, or keep only the columns you choose.

100% private. Everything runs in your browser. Your data never leaves your device.

Delete / Keep Columns

What does this tool do?

This tool lets you remove unwanted columns from a table, or keep only the columns you select. Paste your data, choose columns, and export the trimmed result. Runs in your browser.

How to use Delete / Keep Columns - Free Online Tool

  1. Paste your table (with a header row), or click "Try with sample data".
  2. Tick the columns to keep, or the ones to delete.
  3. Click Apply.
  4. Copy or download the result.

Example

Keeping only Name and Email:

Before

Name Phone Email
Ali 123 a@x.com

After

Name Email
Ali a@x.com

The Phone column is dropped.

Excel formula alternative

Prefer a formula? You can achieve a similar result with manual delete:

right-click column > Delete

In Excel you delete columns one by one. This tool keeps or drops many at once.

When should I use this tool?

Trimming an export to needed columns
Removing sensitive columns before sharing
Preparing data for import
Cleaning wide spreadsheets
Selecting fields for a report
Dropping empty columns

Frequently Asked Questions

Yes, choose keep-mode and tick the columns to keep.

Yes, the first row is treated as column names.

No, it runs in your browser.

Yes, copy it or download as Excel.

Related tools

Transpose Data
Sort Data
Split Text (Text to Columns)
CSV Viewer
Remove Blank Rows/Columns

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator