Omnikit
DevFilesMoneyAll tools
Ctrl K
Dev toolsFile toolsMoney calculatorsAll tools
HomeFile toolsCSV Column EditorDelete Columns from CSV

Delete Columns from CSV

files

Untick the columns you do not need and download a slimmer CSV, quoting kept intact

Processed in your browser. Nothing is uploaded. Checked against sources on 17 Oct 2026.

Exports from shops, banks and CRMs carry dozens of columns nobody asked for. Drop the CSV here and each column is listed with a sample value from the first row that has one; untick the ones you do not need, or remove every empty column with one press, and download. Values are copied exactly, quoted fields with commas or line breaks stay intact, and a semicolon or tab file keeps its delimiter.

Next:
  • Export the sheet as CSV Save any sheet of an Excel workbook as CSV, with clean dates
  • Open the CSV as Excel Turn CSV files into a tidy Excel workbook with real numbers
  • Convert Anything Drop any file and we name it, then offer the one thing you probably came for

How to use Delete Columns from CSV

1

Drop your files or click to choose them.

2

Adjust the options and check the preview.

3

Download the result. Nothing was uploaded.

How Delete Columns from CSV works

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

What does not change. Values are copied exactly, cell by cell. A CSV is written back with its own delimiter, comma, semicolon, tab or pipe, and with proper quoting, so values containing commas, quotes or line breaks stay whole. An Excel file comes back as an .xlsx, with the numbers, dates and number formats of the kept columns unchanged; formulas are saved as their results.

The rest of the article, and all 6 questions about CSV Column Editor, are on the CSV Column Editor page.

Frequently asked questions

How do I delete a column from a CSV file?

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.

How do I change the order of columns in a CSV?

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.

Can I rename the column headers?

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.

Does it work with Excel files?

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.

Sources

  • RFC 4180, Common Format and MIME Type for Comma-Separated Values (CSV) FilesQuoted fields, doubled quotes, CRLF line breaks: how the CSV is read and written back

Last verified 17 October 2026.

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.

More ways to use CSV Column Editor

  • CSV Column EditorDelete, reorder and rename columns of a CSV or Excel file, then download the result
  • Reorder CSV ColumnsPut the columns of a CSV in the order an import form or template expects
  • Remove Empty ColumnsFind the columns that hold no data in any row and delete them in one press

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.

Related tools

All file tools
Excel to CSVSave any sheet of an Excel workbook as CSV, with clean datesCSV to ExcelTurn CSV files into a tidy Excel workbook with real numbersConvert AnythingDrop any file and we name it, then offer the one thing you probably came forDocument ConverterTurn a document into another format, with the cost stated firstPPT to WordPull the text out of a PowerPoint deck into an editable Word fileWord to PPTMake a slide deck from the headings in a Word documentWord to ExcelLift the tables out of a .docx and into a spreadsheet you can sortExcel to WordPut a spreadsheet into a Word document as a table you can edit
Was this tool helpful?
Omnikit

Small jobs, done in your browser. Free, fast and private. Files are never uploaded.

Files

  • Compress Image
  • Image to PDF
  • Merge PDF
  • Compress PDF
  • PDF to Word
  • Word to PDF

Dev

  • JSON Formatter & Validator
  • Base64 Encode & Decode
  • JWT Decoder, Verifier & Encoder
  • Password Generator
  • UUID Generator
  • Unix Timestamp Converter

Money

  • SIP Calculator
  • EMI Calculator
  • GST Calculator
  • FD Calculator
  • PPF Calculator
  • Lumpsum Calculator
GuidesQuestionsAboutHow we checkLaw library (beta)PrivacyTermsDisclosureContactMore: Exam practice (UGC NET Paper 1)Runs in your browser. Nothing is uploaded. © 2026 Omnikit (theomnikit.com)