CSV Column Editor
Keep the columns you need for an import or report. Each column retains its original position label, even when headers repeat or are blank.
Edit CSV columns
- Paste or open a UTF-8 file, choose the delimiter and say whether the first record contains headers.
- Read columns, choose which to keep and move them into order. Rename headers if needed.
- Generate the CSV, review its dimensions and download it.
How column selection works
Original position identifies each column. Two columns called ID stay separate.
Rows keep their order and retained cells keep their text, including spaces and leading zeroes.
The exported file uses commas and CRLF record endings, with quotes where required.
Column examples
With headers ID, ID and Memo, you can keep the second ID and rename it Item ID.
Keeping a column with the value 0007 preserves those four digits in the exported field.
Table and import limits
Every record must have the same number of fields, even in columns you remove.
Spreadsheet apps can interpret certain strings as formulas. The editor flags possible formula text and preserves its value.
Local CSV editing
The browser processes your table on your device. Download creates a separate CSV file.
CSV column questions
Sources
These references describe CSV record syntax and the positional structure of tables.
- IETFrfc-editor.orgRFC 4180Section 2 explains commas, record endings, quoted fields and escaping a quote.
- W3Cw3.orgW3C tabular data modelThe rows section describes ordered cells and their correspondence with table columns.
References checked on 19 November 2026.
Related tools
JSON to CSV Converter
Convert flat JSON records to delimited text with first-seen columns, original number spellings and explicit empty-value rules.
Open tool — JSON to CSV ConverterCSV Row Filter
Keep or exclude CSV rows with text conditions on specific columns.
Open tool — CSV Row FilterCSV Delimiter Converter
Convert CSV separators, preview real columns and spot import problems. Works locally with CSV, TSV and text; values remain unchanged.
Open tool — CSV Delimiter ConverterCompare Two CSV Files
Match rows by a key column and find added, removed and changed records.
Open tool — Compare Two CSV FilesCSV Duplicate Finder & Remover
Find exact duplicate CSV rows or repeated IDs. Review conflicting values, keep original data and download retained, removed and unresolved records.
Open tool — CSV Duplicate Finder & RemoverCSV Merger
Combine rows from several CSV files by exact column name. Preview alignment and download CSV with a merge report.
Open tool — CSV MergerCSV to JSON Converter
Convert CSV text or UTF-8 files to JSON objects or arrays, keeping cells as strings without guessing data types.
Open tool — CSV to JSON ConverterCSV Splitter
Split a CSV by rows or exact file size. Keep headers and download each part.
Open tool — CSV Splitter