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.

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.

Copy 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

  1. 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.

  2. 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.

  3. 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.