How to Remove a Column from a CSV Online (and Add or Reorder Columns)
Remove a column from a CSV, add new ones or reorder them in one pass, without Excel changing your data. Quoted fields stay intact. Free for files up to 25 MB.
Updated November 8, 20268 min read
To remove a column from a CSV online, load the file into the CSV column tool, untick the columns you do not want and press Apply. The same list lets you add a column, drag columns into a new order and rename a header, all in one pass, with a preview of the result before you download it. The file is rewritten as text, so values are not reinterpreted the way a spreadsheet does when it imports a CSV: long numbers, leading zeros and codes that look like dates come out exactly as they went in. It all runs on your device, not our servers, and the free plan takes one file up to 25 MB.
Remove a column from a CSV online: the short version
A CSV is a plain text file where each line is a row and a separator, usually a comma, marks where one column ends and the next begins. Removing a column means cutting the same field out of every line, header included. Doing that by hand in a text editor is easy to get wrong as soon as one field contains a comma inside quotes, because the columns after it shift by one. A column tool reads the file properly first, so it knows which comma is a separator and which one is part of an address.
If you only want to look at the file before deciding what to cut, open it in the CSV Viewer first. How to view a CSV file online covers reading large files, searching and sorting; this guide is about changing the columns themselves.
Removing, adding or reordering columns, step by step
Load the CSV
Open the CSV Column Add/Remove page and drop a .csv, .tsv, .txt or .psv file onto it, or choose Paste CSV text instead and paste the text. The delimiter, quote character and encoding are detected for you.
Check the header setting
Leave First row is a header ticked for a normal export. Untick it if the file starts straight into data, otherwise your first record is treated as column names.
Untick the columns to remove
Every column has its own Keep box. Untick as many as you like. To keep only a few, press Remove all and then tick the two or three you want.
Add, move and rename
Press Add column to insert a new one and choose what it holds. Drag a row by its grip, or use the up and down arrows, to change the order. Type over a name to rename that header.
Read the preview
The table under the list shows the first 50 rows of the output, updating as you edit. It shows the result, not the original, so what you see is what the file will contain.
Apply and download
Press Apply, then Download CSV, or Copy to put the text on the clipboard. Choose the output delimiter, line endings and byte-order mark first if the file is going somewhere specific.
Remove several columns at once, add new ones, reorder and rename headers, with a live preview. Free: one file at a time up to 25 MB, with every column feature included. Pro: up to 100 files at once with the same column list, delivered as one ZIP, plus a custom download name. It runs on your device, not our servers.
Edit CSV columnsWhat a new column can contain
When you add a column to a CSV, it gets a name and a value. The name goes into the header row; the value is written into every data row. There are four choices in the column's value menu, and they cover the jobs people otherwise open a spreadsheet for.
| Value mode | What every data row gets | Typical use |
|---|---|---|
| Same value | The same text you type, for example 2026-11 or shop-eu | Tagging a batch with its source, month or campaign before merging files |
| Blank | An empty field | A column an importer requires but you will fill in later |
| Row number | 1, 2, 3 counting data rows, so the first record is 1 even with a header | A simple ID, or a way to restore the original order after sorting |
| Copy of… | The value of another column from the original file | Keeping a value under a new name while removing the column it came from |
A new column appears at the end of the list. Drag it to wherever it belongs; the order of the list is the order of the output. The copy option refers to a column by its position in the original file, which is why it keeps working after you move or remove that original column.
Why not just delete the column in Excel?
Deleting a column in a spreadsheet is easy. The problem is the round trip. When Excel opens a CSV, it guesses a type for every cell, and saving the file back writes its guesses instead of your text. A column you never touched can come back changed. Why CSV files open wrong in Excel explains the causes; the column tool avoids them by never converting a cell at all.
| Value in the file | After open and save in a spreadsheet | After the column tool |
|---|---|---|
| 00451 (a postcode or product code) | Often 451, the leading zeros dropped | 00451 |
| 4111111111111111 (a 16-digit number) | Often rounded, the last digits turned to 0 | 4111111111111111 |
| 3-4 or MAR1 (a size or a code) | Often turned into a date | 3-4 or MAR1 |
| Müller in a UTF-8 file | Garbled if the file has no byte-order mark | Müller, and you can add the mark for Excel |
Each cell is copied as the exact text it was. Only the columns you changed are different, so if you compare the old and new file, the differences are your edits and nothing else.
Keeping quotes and commas inside fields intact
Quoted fields are where hand edits and quick scripts break. A field such as "Smith, John" contains the separator; a field such as "He said ""hi""" contains doubled quotes; a long comment can even contain a line break. The tool reads fields to RFC 4180, the common CSV standard, so all three survive and are quoted again on the way out.
- Only what needs quotes gets them. A field with a separator, a quote or a line break is quoted; a plain field stays plain. That keeps the file close to the original.
- Quote every field is there for importers that insist on quotes around everything. It is off by default.
- Apostrophes are not quotes. A name like O'Brien in the middle of a field is treated as a letter, so it cannot merge two rows into one.
- Ragged rows are padded. If some lines are shorter than the header, the output fills them in, so no row ends early where a column used to be.
Large CSV files and many files at once
The free plan opens one file at a time up to 25 MB, which is enough for exports of a few hundred thousand ordinary rows. The work is done in the background, so the page stays responsive while a large file is rewritten. The preview only ever draws 50 rows, so a big file does not make editing the column list slow.
For a file over 25 MB on the free plan, cut it into parts with Split CSV, apply the same column changes to each part, and join them again with Merge CSV if you need one file. With Pro, the size is limited by what your device can handle instead, and you can queue up to 100 files: the column list you build from the first file is applied to all of them, and the results come back as one ZIP.
Output settings that matter
- Output delimiter. Keep the file's own or switch to comma, semicolon, tab or pipe. The download's extension follows: .csv, .tsv or .psv. Semicolons are what many European spreadsheet setups expect.
- Line endings. LF for most systems, CRLF for Windows programs and strict importers.
- Add a byte-order mark. Tick it if the file is going into Excel, so accented and non-Latin characters open correctly.
- Copy. The clipboard gets the text without the byte-order mark, so nothing invisible is pasted into the next window.
If the file came from Excel in the first place, save it as CSV or convert it with Excel to CSV before you start; the column tool opens delimited text, not .xlsx workbooks.
Common problems and what they mean
- Everything is in one column. The delimiter was read wrongly. Set it by hand to comma, semicolon, tab or pipe. The tool warns when it is unsure and how consistent the rows are.
- Your first record became the header. Untick First row is a header. Renaming is then switched off, because there is no header row to write a name into.
- The button says Tick a column first. Every column is unticked, so there would be nothing to write. Tick at least one.
- The result has strange characters in Excel. Tick Add a byte-order mark and download again.
- A result is marked out of date. You changed a setting after applying. Press Re-apply so the download matches what you see.
Frequently asked questions
How do I remove a column from a CSV file without Excel?
Load the file into the CSV column tool, untick the column, check the preview and press Apply, then download. The rest of the file is copied as text, so no other value is changed. Free covers one file up to 25 MB.
Can I delete several CSV columns at once?
Yes. Each column has its own Keep box, so untick as many as you need and apply once. To keep only a few columns, press Remove all and tick the ones to keep.
How do I add a column to a CSV with the same value in every row?
Press Add column, type the header name, choose Same value and type the value. Every data row gets it. Drag the new column to the position you want before applying.
Can I change the order of columns in a CSV?
Yes. Drag a column by its grip or use the up and down arrows next to it. The order of the list is the order of the output, and you can reorder, rename, add and remove in the same run.
Will removing a column break quoted fields with commas in them?
No. Fields are read to RFC 4180, so commas, doubled quotes and line breaks inside quoted fields survive, and fields that need quotes are quoted again in the output.
Why is my CSV too large for the free plan?
Free handles one file up to 25 MB. Split a larger file into parts, edit each part, and merge them back, or use Pro, where the size is limited by your device and up to 100 files can be processed in one go.