CSV Column Editor
Keep, reorder and rename CSV columns without changing cell values or row order.
This tool runs entirely in your browser. Your data is never uploaded, never stored, and never leaves your device.
Select, reorder and rename CSV columns locally while preserving exact cell text and source-row order.
How to use it
- 1Load or paste UTF-8 CSV and read the columns.
- 2Keep required columns, change their order and rename headers.
- 3Apply the choices, inspect the preview and download the edited CSV.
Example
- Input
- id,name 001,Mira Keep name then id; rename Name and ID
- Output
- Name,ID Mira,001
What happens to your data
CSV column selection, reordering and renaming run in browser memory. The tool does not upload file contents. Removing fields does not necessarily anonymize the remaining records; inspect them before sharing.
Last updated October 2026
Select, reorder and rename CSV columns without changing the text inside their cells. Prepare a vendor export for an importer’s required header order, remove irrelevant fields from a test fixture, or replace internal field names with clearer labels. You can inspect the selected layout before downloading the result.
This is a column transformation, not a row filter, a join or a transpose. Every input data row remains in its original position. A leading-zero identifier such as 001 is never converted to the number 1.
How it works
Paste CSV or load a local file and read its columns. Each source column receives a numbered card. Keep the columns you want, use Up and Down to change their output order, and edit their output header names. Unchecked columns are omitted; selected columns follow the order shown on screen. Renaming never changes the source-to-value mapping. Select all, Deselect all and Reset columns make it easier to revise a wide table.
At least one column must remain. Output header names must be nonempty and unique, comparing exact text, including case and spaces. A name may contain commas, quotes or line breaks: CSV quoting preserves these correctly. Each renamed header is limited to 4 KiB of UTF-8. Repeating a source column to create a duplicate output field is not supported. Header-only input is valid and produces a header-only output.
For example, an export with id,name,email can become Full name,Customer ID by keeping name and id, moving name first and renaming both. Email is omitted, but the rows and selected field values are unchanged. Removing a column does not guarantee anonymization: names, free text or combinations of remaining fields may still identify people.
Inputs are UTF-8 and limited to 2 MiB, 10,000 records including the header, 200 columns and 200,000 cells. Headers must be unique and nonempty. Malformed quoting or unequal field counts stops processing; surplus fields are never silently discarded. Choose comma, semicolon or tab for both input and output. Downloads use UTF-8 without a BOM and CRLF record endings. Field text is preserved, but original quoting style and physical record endings are not. The preview shows at most eight rows and six columns with long values abbreviated; downloads contain the complete result. Exports are capped at 10 MiB.
Optional formula protection prefixes formula-like exported cells and headers with an apostrophe. It also changes negative numeric text and may make cells import as strings. It is not a universal spreadsheet-security guarantee. If protection would turn two distinct headers into the same name, the export is rejected rather than creating an ambiguous table. Import identifier columns as text in spreadsheets to avoid their automatic type conversion.
Files and pasted content are processed locally in this browser, not uploaded by the tool. Editing the input clears old results, and late file reads cannot replace a newer edit. Downloaded files stay on your device; handle them according to your own data policies. Changing a column, order, name or protection setting also removes the previous download until you apply the revised choices.
Worked example: Prepare an importer’s two-column layout
- Input
- id,name,email 001,Mira,mira@example.test 002,Leo,leo@example.test Keep name then id; rename to Full name and Customer ID
- Result
- Full name,Customer ID Mira,001 Leo,002
The email column is removed and the identifiers retain their leading zeros. The output remains personal data if names identify people.
Common use cases
- Matching a CRM importer’s exact header names and order
- Keeping only required columns in a reproducible test fixture
- Removing unwanted export fields without editing row values
- Renaming technical headers for a downstream report
Frequently asked questions
Does changing a header move the correct values with it?＋
Yes. Each card retains its original source-column index. Moving or renaming the card changes its output position or header, while its values continue to come from that same source column.
Can I delete every column or use duplicate names?＋
No. A valid output needs at least one column, and every selected output header must be nonempty and unique. Case and whitespace are significant. Formula protection is also checked for newly created header collisions.
Will this remove personal data safely?＋
It removes only the columns you deselect. Remaining names, notes or linked identifiers may still be personal data, so review the full output before sharing. This is not an anonymization or compliance certification tool.
Does the editor change numbers, dates or quoted multiline cells?＋
Cells are kept as exact strings. Leading zeros, long identifiers, dates and quoted line breaks are not reinterpreted. CSV serialization normalizes record endings and quoting; a spreadsheet can still reinterpret values when it opens the file.
Related tools
CSV Filter
Filter CSV rows, select output columns and download a focused table without uploads.
CSV Sample
Take first, last or seeded CSV samples and download a reproducible selection report.
CSV Validator
Check CSV syntax, row widths and headings without silently repairing data. Download a diagnostic report.
CSV Join
Match two CSV tables by exact text keys, review unmatched records and download the joined data locally.