CSV editor (preview, remove, split, merge, and reorder columns)

Review first, then edit. Remove unnecessary columns, tidy your data, and download a new CSV.

Preview your CSV, choose the columns to keep, then split, merge, or reorder them entirely in your browser.

Nothing is uploaded; processing stays inside your browser.

Preview CSV and choose columns to keep
Remove, reorder, split, and merge columns
No file upload (local processing)
Download the converted CSV as a separate file

What you can do with this CSV editor

CSV preview (first N rows)

  • Review data before applying edits
  • Detect the delimiter automatically or override it manually
  • Encoding switch support (UTF-8 / Shift_JIS)

Column selection and removal

  • Keep only the columns you need
  • Check output column names and count before export

Column reorder (advanced)

  • Drag to change column order
  • Changes column position, not row order

Column splitting

  • Split one column into multiple columns
  • Set the maximum split count and overflow handling
  • Split with a regular expression in Advanced mode

Column merging

  • Merge multiple columns into one new output column
  • Choose a separator: _, /, -, space, or custom
  • Choose blank handling (skip/include)

How to Use (3 Steps)

  1. Load a CSV file (file picker or drag and drop).
  2. Check the preview and edit (keep/remove columns, reorder, split, merge).
  3. Download the transformed CSV. Your original file is unchanged.

UI / Settings

Load

  • Delimiter: Auto / , / Tab / ; / | / Other
  • Encoding: Auto / UTF-8 / Shift_JIS
  • Header row: treat first row as column names (ON/OFF)

Preview

  • Preview rows: first 50 / 100 / 200
  • Search by column name and by value in preview

Column operations

  • Keep this column (checkbox)
  • Select all / Clear all / Show selected only
  • Advanced: drag to reorder columns

Split / Merge / Download

  • Split: target column, method, max splits, new names
  • Merge: target columns, new name, separator, blank policy
  • Download: file name, line endings (LF / CRLF)

FAQ

Is my uploaded CSV sent anywhere?

No. Parsing and transformations run locally in your browser.

Can I reorder columns?

Yes. Enable drag-to-reorder in Advanced options.

How many rows appear in the preview?

The preview shows only the first N rows for speed, but transformations run on the full file.

Can this handle mixed delimiter patterns?

Yes. Regex splitting in Advanced mode can handle mixed delimiter patterns.

Can I choose the merge separator?

Yes. Choose _, /, -, a space, or a custom separator.

Will my original file be modified?

No. The result is downloaded as a separate file, leaving the original unchanged.

Can I open Shift_JIS CSV files?

Yes. The editor supports automatic detection and manual switching between UTF-8 and Shift_JIS.

Notes

  • Only the first N rows appear in the preview for responsiveness. Export still processes the full file.
  • CSV with quoted commas or line breaks requires a standards-compliant parser, which is supported here.
  • Processing speed for large files depends on your device performance.