Developer tools
Remove columns from CSV
Delete, keep, reorder, rename, add or duplicate columns. Each edit builds on the last, and every value you keep stays as it was. It runs in your browser.
Processed in your browser
1. Input CSV data
Paste CSV, or choose a UTF-8 file.
Read CSV, or changing either option here, starts again from this input and discards previous edits. Auto-detect tries comma, semicolon, tab and pipe; check the preview.
2. Column operations
Edits apply to the current table. Columns are addressed by position, so blank and duplicate headers stay distinct.
Current columns
Select a column to add its position to the list below; select it again to remove it. Positions are used in the order you select them. Arrow keys move between columns.
Keep only the selected positions, in the order you enter. Other columns are removed.
Read CSV to see available positions.
Missing trailing fields stay missing when possible. Moving or adding cells can require empty fields before them; the result reports additions. Turn padding off to reject such edits.
Reset options clears the column settings and keeps the current table.
3. Result preview
No result yet
Enable JavaScript to edit CSV columns.
Save the file againCopy and download include the entire current table.
Prefixing changes matching cells, including negative numbers and headers. The export reports the count. Off preserves field strings; spreadsheet apps may interpret formulas when opening them. The preview always shows the unprefixed values.
How to remove columns from a CSV file
Read your CSV
Paste CSV and select Read CSV, or select Choose file for a UTF-8 file. Check Input delimiter and First row contains headers.
Pick the columns
Set Operation to Delete columns. Select columns in the Current columns list, or type their positions, such as 2,4. Select Apply operation.
Save the result
Check the preview and the change counts. Select Copy CSV or Download CSV to save the whole table.
Six column operations
Delete, keep and reorder
Delete columns removes the positions you list and keeps the rest in order. Keep columns does the opposite and uses your order, so on the example Name, Email, Team, typing 3,1 gives Team, Name. Reorder columns needs every position once, in the new order.
Rename, add and duplicate
Rename header changes the name of one column. Add column inserts a new column with a header and the same value in every data row, at the position you type or at the end. Duplicate columns copies the listed columns, with their headers, to the end of each row.
Good to know
Text and records
Untouched field strings and row order are preserved, including leading zeroes and quoted newlines. Deleting columns intentionally discards their cells. Output quotes every field, uses CRLF between records with none after the last, and is UTF-8 without a BOM (an input BOM is dropped). A final record terminator does not add a row. When a file mixes CRLF, LF and CR record endings, each one ends a record; line breaks inside quoted fields are kept. Pasted text follows the browser’s LF convention; open a file to preserve embedded CRLF.
Browser resources
No fixed input size cap. The table and edits must fit browser memory. Cancelling a new read keeps the current table. Cancelling an edit or export clears edits and keeps the source. Reset clears the source too. Preview windows limit rendering, not processing or exports.
Questions
How do I delete a column from a CSV file?
Read the CSV, set Operation to Delete columns, type the column's position (1 is the first column) and select Apply operation. To delete several, type them with commas, such as 2,5,6.
How do I extract only some columns?
Choose Keep columns and list the positions you want, in the order you want them. Every other column is removed. Then select Download CSV.
How do I change the column order?
Choose Reorder columns and type every position once in the new order. For a three-column file, 3,1,2 moves the last column to the front. Keep columns also reorders if you only need some of them.
Can I edit a CSV without headers?
Yes. Clear First row contains headers before you read the CSV. Every row is then data, Rename header is not available, and Add column puts its value in every row.
How do I undo an edit?
There is no undo for a single step. Select Read CSV again to go back to the original input. An operation that fails leaves the current table unchanged.
What happens to short or extra-wide records?
Every field is read, including fields beyond the header width. The preview marks missing and empty fields separately. Missing trailing fields stay absent when possible. If an edit needs empty padding, the result reports how many fields it adds. Clear Allow necessary padding with empty fields to reject that edit. A projected row with no remaining fields needs one empty field to remain a CSV record.
Is my CSV uploaded?
No. The file is read and edited in your browser, and nothing is uploaded or stored. Reset clears the input and every edit.