How to Use the CSV Column Extractor
When you have a CSV file full of columns — transaction logs, member lists, survey responses — and only need a few of them, opening a spreadsheet app just to delete and reorder columns by hand is tedious. This tool lets you paste raw CSV text, specify the column numbers or names you want (comma-separated), and instantly rebuild a new CSV in exactly the order you specify.
Here's how it works: paste your source data into the CSV box. If the first line is a header row, leave "First row is a header" checked, then type something like "1,3" by column number or "Name,City" by column name in the columns box — you can even mix numbers and names. Columns are reordered to match whatever order you typed. Values containing commas or double quotes are automatically quoted to stay standard-CSV compliant.
The result box shows the full extracted CSV along with the row and column counts, so you can confirm at a glance that you pulled exactly the data you needed.
Frequently Asked Questions
Yes. A pure number is treated as a column number (starting at 1), and anything containing letters is matched against the header row's column names. Column names only work when the header checkbox is enabled.
Values containing a comma or double quote are automatically wrapped in double quotes to follow standard CSV formatting. Format your source data the same way for the most accurate parsing.