How to Keep Only Specific Columns in a CSV and Remove the Rest

Sometimes you do not want to think about which columns to delete — you just want to specify which ones to keep and let the tool remove everything else. This is especially useful when working with large exports that have dozens of fields and you only care about three or four.

A browser column editor with a visual checklist makes this easy: uncheck everything, then check only what you want to keep. Download the result.

When You Need to Keep Only Specific Columns

• A CRM export has 50 fields and you only need email, first name, and company name for a mail merge
• An analytics export has engagement metrics for 30 events and you only care about 4
• A database dump has technical system columns mixed with user-facing data and you need to strip the internals
• You are sharing a report with a client and want to remove internal fields before sending
• You are feeding data into a script or API that only accepts specific fields and will error on unexpected columns

How to Select Only the Columns You Want to Keep

1. Open the free column editor in your browser.
2. Upload your CSV, XLSX, XLS, TSV, or ODS file.
3. You will see a list of all column headers, each with a checkbox. All start checked.
4. Uncheck the columns you want to remove — or uncheck all and then check only the ones to keep.
5. Verify that only your desired columns are checked.
6. Click Download.

The downloaded file contains only the checked columns, in the order shown in the list.

Sell Custom Apparel — We Handle Printing & Free Shipping

Reorder Your Kept Columns Before Downloading

After deciding which columns to keep, you can also rearrange their order using the up and down arrows. This is useful when the columns you are keeping were scattered across the original file and you want them in a logical order in the output.

For example, if you are keeping email, first name, company, and phone — but in the original file they were at positions 1, 5, 12, and 28 — you can reorder them into any sequence you want before downloading.

Versus Writing a SELECT Statement in SQL

If you have SQL access to your data, the equivalent operation is a SELECT statement: SELECT email, first_name, company FROM contacts. This is fast if you are already in a database environment.

But for a CSV file sitting on your desktop, loading it into a database just to run a SELECT is more overhead than needed. The browser column editor gets you the same result for file-based data without any setup.

Frequently Asked Questions

What if I need to keep columns in a specific order that is different from the original?

After selecting which columns to keep, use the up/down arrows to rearrange them into your desired order before downloading.

Can I save a column selection template to reuse on future files?

The tool does not currently save configurations between sessions. For repeated use with the same column set, a simple note with the column names you need makes it quick to re-apply on the next file.

Does this work if my CSV has no header row?

The tool expects a header row in the first row of the file. If your file has no headers, the first data row will be treated as headers, which will cause incorrect results. Add a header row to your file before uploading.

Is it free?

Yes. No account, no cost, no server upload.