CSV Editor (Preview, Remove Columns, and Re-download)

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

Preview your CSV, choose which columns to keep, and apply split, merge, and reorder operations 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)

  • Check data before applying edits
  • Automatic delimiter detection with manual override
  • 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
  • This changes column position, not row sorting

Column splitting

  • Split one column into multiple columns
  • Set maximum split count and overflow handling
  • Regex-based splitting in advanced mode

Column merging

  • Merge multiple columns into one new output column
  • Choose 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 transformation run locally in your browser.

Can I reorder columns?

Yes. Enable drag reorder in the advanced options.

How many rows are shown in preview?

Preview is limited to the first N rows for speed, but transformations can run on the full file.

Can this handle mixed delimiter patterns?

Yes. In advanced mode, regex splitting can handle mixed delimiter patterns.

Can I choose the merge separator?

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

Will my original file be modified?

No. The result is downloaded as a separate file.

Can I open Shift_JIS CSV files?

Yes. Encoding supports automatic detection and manual switching.

Notes

  • Only the first N rows are shown in preview for responsiveness. Full-file processing is still applied on export.
  • CSV that contains quoted commas or line breaks requires a standards-compliant parser (supported here).
  • Processing speed for large files depends on your device performance.

Related Tools