CSV Column Deleter

Drop columns by number, starting at 1.

Use this tool

Input CSV format
Output CSV format

Parsed table

Result

The result appears in this panel after you run the tool.

About this tool

Enter numbers such as 1, 3. The listed columns are removed from the parsed table, and the remaining cells are written with the output delimiter. Missing cells stay empty. A header row stays in the result when it was part of the table.

How to use it

  1. Paste a table or open a file.
  2. List the column numbers to remove, starting at 1.
  3. Use Delete columns. The serialized CSV is what you copy, download, or continue with.

Limitations

Listed columns removed, the rest left in place

The numbers you type are the columns that vanish

Splitting uses the input separator, quote, and escape. Column numbers start at one and must fall inside the widest row. Each row then drops those indexes. Columns you did not name stay, in their previous relative order. Data in the named columns is not moved to a side file. It is gone. An empty list of numbers is rejected, because the page asks you to name at least one column.

If you name every column, the rows become empty and the writer emits blank lines. That result is easy to mistake for a failed paste. It is a successful deletion of everything. The output dialect still applies: separator, quote, and escape format whatever cells remain. With no cells, quoting does not matter. The preview uses the input header flag to decide whether to call the first row names. Deleting the first column deletes the corner header cell and every data cell under it, and the new first column becomes the corner.

Interaction with a ragged table

A row that was already shorter than the deleted index simply loses nothing at that index if the cell was absent, while longer rows lose the cell. After deletion, widths can still differ. The page does not repad the file into a rectangle. Transpose would pad. This page does not transpose.

Deletion versus extraction

Extraction keeps a listed set and can reorder it. Deletion removes a listed set and does not reorder the survivors. Use deletion when the file is mostly right and a few columns are noise. Use extraction when the file is mostly noise and a few columns are the point. In both cases the abandoned characters are not in the output. Set the input dialect before you trust the indexes, or column 3 will be the wrong field.

Privacy

Your input is processed in your browser and is not uploaded to UtilChain. File names, text, and results are not sent to analytics.