Data & CSV
Select CSV columns
Keep chosen columns and put them in a different order.
A clear answer. Here’s how.
Select columns using one-based comma-separated positions, such as 3,1. Each position must exist and occur once. Preserves row order and original headings. CSV output quotes values and protects potential spreadsheet formulas.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- CSV data
Name,Group,Score Alex,A,72 Sam,B,85 Jo,A,91
- Column positions, in output order
- 3,1
Example result
| Score | Name |
|---|---|
| 72 | Alex |
| 85 | Sam |
| 91 | Jo |