Two columns, reordered
Input
id,name,email
1,Alice,a@example.com
2,Bob,b@example.comOutput
email,id
a@example.com,1
b@example.com,2Columns requested as "email,id" appear in that order, and name is dropped.
Ctrl+↵
Input
CSV input
Output
ResultOptions
Comma-separated names or 1-based numbers.
Detected automatically unless you pick one.
About this tool
Exports usually contain more columns than you need. This keeps only the ones you name, in the order you name them, or removes the ones you list instead.
Reordering matters for imports that expect a fixed column sequence, and dropping columns is often about privacy: stripping names and email addresses before sharing a dataset.
How to use it
- Paste or upload your csvDrop a file onto the input pane, use the file picker, or paste the text directly.
- Adjust the options if neededThe defaults suit most input; open Options to change the behaviour.
- ExtractPress Extract, or use Ctrl+Enter (Cmd+Enter on macOS).
- Copy or downloadCopy the result, or download it as a .csv file.
Worked examples
Each example below is executed against this tool by the test suite, so what you see is what the tool actually produces.
What to watch for
The details that decide whether a conversion is correct, and where information can be lost without any error being raised.
- Order follows your list
- Columns appear in the order you specify, so listing "email,id" puts email first regardless of its position in the source. That makes this a reordering tool as much as a filter.
- Name or 1-based number
- Columns can be referenced by header name, matched case-insensitively, or by position starting at 1. Numbers help when headers are awkward or duplicated.
- Keep or exclude
- The default keeps the listed columns. Switching to exclude mode removes them and keeps everything else in its original order, which is easier when you only want to drop one or two columns from a wide file.
- A useful step before sharing data
- Removing personal columns before sending a file elsewhere is a common privacy need, and since this runs in your browser, the file with the sensitive columns never leaves your machine.
Limitations
- Selects whole columns; no expression or computed columns.
- Header matching is by exact name, ignoring case.
- Processing happens in your browser, so very large inputs are bounded by available memory. Files above roughly 10 MB are handled but will feel slower, and multi-hundred-megabyte files are better suited to a command-line tool.
Questions
- Can I reorder columns without removing any?
- Yes. List every column in the order you want them.
- Can I refer to columns by number?
- Yes, using 1-based positions. Useful when headers are duplicated or awkward to type.