CSV Editaror (Vista previa & Quitar Columns)
Vista previa CSV before editing. Choose columns to keep, delete the rest, split one column into many, or merge several columns into one — all in your browser.
CSV preview and CSV edit stay local. Useful for CSV column delete, CSV column split, CSV column merge, and CSV column selection.
CSV Editaror
CSV preview + CSV edit in one place: delete columns, choose CSV columns, reorder, split columns, and merge columns before downloading.
What this CSV editor can do
Check the CSV preview first. Auto-detect delimiters (comma/tab/semicolon/pipe) and switch manually if needed.
Keep only the columns you need to reduce mistakes. Verify column names and counts before export.
Drag to change column order — this is not value sorting.
Split one column into multiple columns using a delimiter or regex. Control max parts and how unsplittable rows are handled.
Combine multiple columns into one with a chosen separator and empty-cell handling.
Cargar CSV
Local onlyVista previa
Vista previa shows only the first N rows.Columns to keep
—Advanced: reorder columns
Drag to change column order (not sorting by value).
Split column
Merge columns
Descargar edited CSV
Local-only downloadUI & settings
Import
- Delimiter: Auto / comma / tab / semicolon / pipe / custom
- Encoding: Auto / UTF-8 / Shift_JIS
- Header row: treat first row as column names
Vista previa
- Rows to show: 50 / 100 / 200
- Search: column names and values
Column operations
- Keep columns only (delete the rest)
- Show selected columns only
- Advanced: drag to reorder columns
Split
- Target column (dropdown)
- Split by delimiter or regex
- Max split count and handling for unsplittable rows
- Auto-generated column names (editable)
Merge
- Seleccionar multiple columns
- New column name
- Separator: _ / / / - / space / custom
- Empty-cell handling: skip or keep
Descargar
- Auto file name: original_edited.csv
- Line endings: LF / CRLF
How to use (3 steps)
- Cargar a CSV (Choose CSV or drag & drop).
- Vista previa and edit: keep columns, reorder, split or merge if needed.
- Descargar the edited CSV. The original file is untouched.
Example: split & merge
id,last,first,region 1,Smith,Anna,CA-San Francisco 2,Lee,Ken,WA-Seattle
full_name,region_state,region_city Smith Anna,CA,San Francisco Lee Ken,WA,Seattle
Notas
- Vista previa shows only the first N rows for speed. The conversion applies to the whole file.
- Proper CSV parsing is required when quoted fields contain commas or line breaks (supported by this tool).
- Performance depends on your device for large files. Keep preview light.
- This tool runs entirely in your browser. No data is uploaded.
Tips
- Use regex split for mixed separators (e.g. commas + spaces).
- Merge columns with a custom separator to create stable IDs.
- If you see garbled text, switch the encoding to Shift_JIS.
FAQ
Are uploaded CSV files sent to a server?
No. Everything runs locally in your browser.
Can I change column order?
S?. Use the advanced option and drag columns to reorder them.
How many rows are shown?
Vista previa shows only the first N rows for speed, but the conversion applies to the full file.
Can I handle CSVs with multiple delimiters?
S?. Use the advanced regex delimiter option for mixed separators.
Can I choose the separator when merging columns?
S?. You can set _, /, -, space, or any custom separator.
Will the original file be modified?
No. The edited CSV is downloaded as a new file.
Can I open Shift_JIS CSVs?
S?. Switch the encoding to Shift_JIS or use Auto detection.