How to Extract Data from Excel: 5 Fast Methods (2026 Guide)
To extract data from Excel, choose the method that matches your goal: copy-paste for a few cells, the Excel data extractor for specific columns without uploading, File → Save As CSV to feed another program, Power Query for repeatable automated extraction, or FILTER/XLOOKUP for pulling rows that match a condition. This guide covers all five methods — including how to do it in your browser without Excel installed.
What “extract data from Excel” usually means
The query covers three different goals:
- Pull specific columns — you have a 30-column export and only need three of them.
- Get the data into another format — CSV or JSON to import into a database, CRM, or script.
- Pull rows matching a condition — extract only the records where a column equals a value.
Pick the method below that matches your situation.
Method 1 — Copy and paste (fastest for a few values)
Select the range, press Ctrl+C (or Cmd+C), and paste into the destination. Use Paste Special → Values to paste numbers without the formulas behind them. Works for a handful of cells; does not scale to hundreds of rows.
Method 2 — Extract specific columns with a browser tool (no upload)
When you need just certain columns out of a wide spreadsheet, the Excel data extractor opens an .xlsx in your browser, lets you pick the sheet and columns, and outputs clean CSV — with the file never leaving your device.
If your data is already a CSV rather than an Excel file, the CSV column extractor does the same column-selection job for comma-separated files.
Method 3 — Export to CSV (to feed another program)
In Excel: File → Save As → CSV (Comma delimited). Almost any tool — databases, scripts, other spreadsheets — can import a CSV. Two things to watch:
- CSV saves only the active sheet, so a multi-tab workbook needs one export per tab.
- Formulas are saved as their calculated values, not the formula itself.
For a full walkthrough on converting Excel to CSV without losing data, read how to convert Excel to CSV without losing data.
Method 4 — Power Query (extract data from Excel automatically)
If you extract from the same kind of file every week, Excel’s built-in Power Query (Data → Get Data) lets you define the columns and transformations once, then re-run them on new files automatically. The steps:
- Data → Get Data → From File → From Workbook
- Select the sheet and apply any column filters or type changes in the Query Editor
- Click Close & Load to write the result to a new sheet
- Next week, right-click the result table and choose Refresh — or point the query at the new file
Power Query is the right answer when “extract” means an automated pipeline, not a one-off export.
Method 5 — Formulas: extract data from Excel based on criteria
When you want only the rows where a column meets a condition, Excel’s newer functions are the cleanest option:
=FILTER(A2:D100, C2:C100="London")— returns every row where column C equals “London”, spilling the results into a new range.=XLOOKUP("Smith", A2:A100, B2:D100)— returns the row matching “Smith” across columns B–D.=INDEX(B2:B100, MATCH("Smith", A2:A100, 0))— the older equivalent for Excel versions without XLOOKUP.
These keep everything inside Excel and update automatically when the source data changes. FILTER requires Excel 365 or Excel 2021; XLOOKUP requires Excel 365 or 2019.
Extract data from Excel to Excel (between workbooks)
To pull data from one workbook into another, link them with a formula:
=[SourceFile.xlsx]Sheet1!$A$2Or use Power Query’s “From Workbook” source — this is more robust than direct formula links because it does not break when files move, and it lets you reshape the data before it lands in the destination sheet.
Which method should you use?
| Your goal | Best method |
|---|---|
| A few values, one time | Copy & paste (values only) |
| Specific columns, no upload | Excel data extractor |
| Data into a database or script | Export to CSV |
| Automated extraction every week | Power Query |
| Rows matching a condition | FILTER / XLOOKUP formula |
| Data from one workbook into another | Power Query or cross-workbook formula |
A note on privacy
Spreadsheets often contain the most sensitive data in an organisation — customer lists, financials, employee records. Many “extract data from Excel online” tools upload the file to their server, handing that data to a third party. A browser-based extractor avoids this: the file is read and processed on your own device and never transmitted. For how that works technically, see browser-based vs server-side file processing.
Extract Excel data in your browser
No install, no upload, no sign-up:
- Excel data extractor — open an
.xlsxand pull the sheets and columns you need. - CSV column extractor — the same for CSV files.
- JSON field extractor — for pulling fields out of JSON exports.
Frequently asked questions
How do I extract specific columns from Excel?
Open the file in the Excel data extractor, select the columns you want, and download just those as CSV — without altering or uploading the original.
How do I extract data from Excel to CSV?
In Excel, use File → Save As and choose “CSV (Comma delimited)”. Each tab needs a separate export. For a browser-based option, the Excel data extractor converts any sheet to CSV without opening Excel.
How do I extract data from Excel automatically?
Set up a Power Query (Data → Get Data → From File → From Workbook). Define the columns and filters once, then refresh the query each time new data arrives — no manual steps.
How do I extract rows based on a condition?
Use Excel’s FILTER function: =FILTER(range, condition). For older versions without FILTER, use AutoFilter to show matching rows and copy the visible results.
Can I extract data from Excel without uploading the file?
Yes. The Excel data extractor runs in your browser — the file is read locally and never sent to a server. Safe for confidential spreadsheets.
Do I need to know how to code?
No. Copy-paste, Save As CSV, Power Query, and browser extractors all work without code. Python (with pandas) or R only help when you need to automate extraction across dozens of files.