CSV Column Extract & Reorder: Keep Only the Columns You Need (Download-Ready)

Select CSV

Or paste:

Extraction Settings

Delimiter: Comma (,) Tab Semicolon (;) Pipe (|) First row is header
Columns to extract (in desired order): * Numbers are treated as 1-based column indexes; text is matched to header names. You can mix both.

Output Settings

Output delimiter: Comma (,) Tab Semicolon (;) Pipe (|) Include header in output
Override header names (optional, comma-separated): * The first row headers will be overwritten for as many names as provided (remaining headers fall back to original/blank).

Extract

How to Use (3 Easy Steps)

1. Load your CSV
   • Upload via “Choose File” or paste CSV text into the box.
   • The first-row preview shows column numbers like [1] [2] [3] for quick reference.
2. Set extraction rules
   • Delimiter: Comma / Tab / Semicolon / Pipe
   • “First row is header”: keep checked if your CSV has a header row.
   • Columns to extract (output order follows your input):
     • By number: 3,1,5 (1-based from the left)
     • By header name: Name,Price,Stock (exact match)
     • Mixed: 3,Name,5
   • Output delimiter: choose Comma / Tab / etc.
   • Override header names (optional): e.g., ID,Product,Stock
3. Extract & download
   • Click “Extract” to preview up to 200 rows.
   • Click “Download CSV” to save the formatted file.

What You Get (Output)

• A new CSV containing only the selected columns, reordered exactly as specified.

Header Handling

• If “First row is header” is checked, the original header stays at the top.
• If “Override header names” is filled, headers are replaced from the first column onward.
• No header? Provide names in “Override header names” to add pseudo-headers.

Column Rules

• Numbering starts at 1 (leftmost column = 1).
• Header names require an exact match; when unsure, use numbers.
• Columns that can’t be found are skipped.

Formatting & Compatibility

• Rows with differing column counts are padded with blanks to align.
• Output delimiter follows your selection (Comma/Tab/etc.).
• Preview shows up to 200 rows; the downloaded CSV contains all rows.

Encoding

• Input is auto-detected (UTF-8 / SJIS-win (CP932) / EUC-JP / JIS) and converted to UTF-8.
• Output is UTF-8 (no BOM). In Excel, use “Data → From Text/CSV” and choose UTF-8.

Examples

• Keep only Product Name, Price, Stock → Name,Price,Stock
• Reorder to 4 → 2 → 1 → 4,2,1
• Add headers to a no-header CSV → uncheck “First row is header”, then set “Override header names” to ID,Name,Price

Notes & FAQs

• Don’t know column numbers? Use the first-row preview and count [1][2][3]…
• Header-name match fails? Watch spaces and case. Numbers are foolproof.
• Access control: For sensitive data, restrict to logged-in users or protect the page with a password.
• File size: Use within the shortcode’s limit (e.g., 5–10 MB). Split very large CSVs before use.