Tool 03 · Extract columns
Extract Columns from CSV
=CHOOSECOLS()
Keep the columns you need, in the order you want.
Your table
100% in-browser
Revision Q&A
(click a question) Lab module 03Q1: How do I extract columns from a CSV file? expand_more
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? expand_more
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? expand_more
No. Everything runs in your browser and your data never leaves your device.
Know someone fighting with a spreadsheet? Send them this page.