Tool 03 · Extract columns
Extract Columns from CSV
=CHOOSECOLS()
Keep the columns you need, in the order you want.
100% in your browser: your data never leaves your device
Your table
100% in-browser
Revision Q&A
(click a question) Lab module 03Q1: How do I extract columns from a CSV file?
Paste or open the file, untick the columns you don't need, and use the arrows to reorder the rest. Then copy or download the result.
Q2: How do I pick columns in Excel?
In Excel 365, =CHOOSECOLS(A1:F100, 3, 1) returns columns 3 and 1 in that order. The workspace shows this formula for your own choice of columns.
Q3: Is my data uploaded?
No. Everything runs in your browser and your data never leaves your device.
Know someone fighting with a spreadsheet? Send them this page.