広告が嫌いですか? 行く広告なし今日 

CSV Column Extractor & Reorderer

データ開発者

広告・取り除く？

入力

出力

クライアント側

広告・取り除く？

ガイド

CSV Column Extractor & Reorderer

Extract, reorder, rename, and filter columns from CSV files directly in your browser. Paste CSV data or upload a file, then use drag-and-drop to rearrange columns, checkboxes to include or exclude them, and inline editing to rename headers. Preview the transformed output and download or copy the result as a clean CSV. Supports comma, semicolon, tab, and pipe delimiters with full RFC 4180 compliance for quoted fields.

使い方

Paste your CSV content into the input area or upload a .csv file. The tool auto-detects the header row and lists all columns with checkboxes and drag handles. Uncheck columns you want to exclude, drag to reorder, and click any column name to rename it inline. Set the number of preview rows to see a live preview of the output, then copy or download the full transformed CSV.

特徴

Drag-and-Drop Reordering – Rearrange columns visually by dragging them into the desired order
Column Include/Exclude – Check or uncheck columns to control which ones appear in the output
Inline Column Renaming – Click any column header to rename it directly
RFC 4180 Compliant Parser – Correctly handles quoted fields containing commas, newlines, and escaped quotes
Multi-Delimiter Support – Works with comma, semicolon, tab, and pipe-separated files
ライブプレビュー – See the first N rows of your transformed output before downloading
Download & Copy – Export the result as a .csv file or copy it to your clipboard
ファイルのアップロード – Upload .csv files directly from your computer

広告・取り除く？

 よくある質問

What is RFC 4180 and why does it matter for CSV parsing?

RFC 4180 is the formal specification for the CSV (Comma-Separated Values) format. It defines rules for handling quoted fields, embedded commas, newlines within fields, and escaped double quotes. A parser that follows RFC 4180 correctly handles edge cases like a field containing a comma inside double quotes without splitting it into two columns. Without RFC 4180 compliance, CSV tools often break on real-world data.
How do you handle CSV files with different delimiters?

While CSV technically stands for Comma-Separated Values, many files use semicolons (common in European locales where commas are decimal separators), tabs (TSV files), or pipes as delimiters. This tool lets you specify the delimiter so it correctly splits fields regardless of which separator your file uses. The same quoting rules apply across all delimiter types.
Can I reorder columns in a CSV without losing data?

Yes. Column reordering is a non-destructive operation that changes the order of columns without modifying any cell values. Every row is remapped to the new column order, and all data including quoted fields, empty cells, and special characters is preserved exactly as it appeared in the original file.
What happens to rows when I exclude a column?

When you exclude a column by unchecking it, that column is removed from every row in the output. The remaining columns shift together with no empty gaps. Header names and all row data for included columns are preserved. You can re-include an excluded column at any time before downloading the result.