Find the columns that hold no data in any row and delete them in one press
Processed in your browser. Nothing is uploaded. Checked against sources on 17 Oct 2026.A sheet that has been through several tools often ends with columns that only have a header, or nothing at all. Drop it here and every column with no value in any data row is unticked straight away, with a count of how many. Check the list, tick back any you want to keep, and download the trimmed file, as CSV or Excel, whichever you started with.
Drop your files or click to choose them.
Adjust the options and check the preview.
Download the result. Nothing was uploaded.
A spreadsheet export rarely has exactly the columns the next step needs. An import form wants five columns in a fixed order; a report from a shop or bank has forty, half of them empty. Doing this in a text editor breaks quoted fields, and opening a large CSV in Excel can change numbers such as phone numbers and long IDs.
| Action | How |
|---|---|
| Delete columns | Untick them |
| Delete every empty column | One press; the count is shown |
| Change the order | Up and down arrows on each column |
| Rename a header | Type in the column's box |
| Start over | Reset |
Each column shows a sample value taken from the first row where it has one, so a column called Field7 can still be recognised. A live preview shows the first rows of the result, and the page warns when two kept columns would share the same name.
The rest of the article, and all 6 questions about CSV Column Editor, are on the CSV Column Editor page.
Drop the CSV on CSV Column Editor. Every column is listed with a sample value; untick the ones to delete and watch the preview change. Press Download and the new CSV keeps every other column, its delimiter and its quoting exactly as before.
Open the file here and use the up and down arrows beside each column until the list matches the order you need, for example an import template. The preview shows the first rows in the new order, and Download saves the rearranged file.
Yes. Type a new name in any column's box and the header row of the download uses it. The page warns when two kept columns would end up with the same name, which many importers and databases reject.
Yes. Drop an .xlsx and choose the sheet if there are several. The download is an .xlsx with the kept columns' numbers, dates and number formats unchanged. Formulas are saved as their calculated values, because the columns they refer to may have moved.
Rates and rules change; check the source before you rely on a figure.
Still stuck? Ask about CSV Column Editor and anybody who knows can answer. No account needed.
Same job, other tools: Markdown to Plain Text – Strip every Markdown mark and keep the words.
On the related tools: Convert Any File – Photos, documents, spreadsheets, archives: drop it and see what is possible.