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

Step 01

Your table

100% in-browser

Revision Q&A

(click a question) Lab module 03
Q1: 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.