All column indices are 1-based (column 1 is the first column). All processing happens in your browser.
.csv file.CSV Column Tools simplifies common data manipulation tasks by allowing you to extract csv columns or reorder csv columns without opening a spreadsheet application. This tool is perfect for preparing data exports, dropping sensitive fields, or fixing transposed data. Whether you need to swap csv fields or filter a large dataset, this utility provides a fast, browser-side solution for all your data formatting needs.
Software developers and data analysts often need a quick way to extract specific fields from a wide CSV or delete personally identifiable columns before sharing datasets. This free csv formatter handles quoted fields, embedded commas, and multi-line values correctly according to RFC 4180 standards. By performing all operations locally in your browser, your data remains secure while you perform complex reordering or field swapping tasks.
Use the CSV Delimiter Changer to convert to comma-separated first, then paste the result here. Or specify a custom delimiter in the options panel if your CSV uses tabs, pipes, or semicolons.
The parser correctly handles RFC 4180 quoting: fields enclosed in double quotes can contain commas, newlines, and other delimiters. Quotes inside quoted fields are represented as two consecutive double quotes.
Yes - the Reorder operation accepts a full comma-separated list of column names in the desired new order. Any columns not listed are dropped (equivalent to both reordering and filtering).
Select "Tab" as the delimiter in the options panel. The tool then parses as TSV while still applying the same column operations.
See also CSV Delimiter Changer, CSV to JSON, and CSV Transposer to build a complete workflow with these CSV Column Tools.