Scrape Website Data Into Excel (No Code, 2026)

You can scrape website data into Excel without code in three main ways: use Excel's built-in Data → From Web (Power Query) for static tables, pull data with Google Sheets formulas and export to Excel, or grab any repeating list with a browser extension that exports a CSV you open in Excel. The right choice depends on whether the page is static or JavaScript-rendered.

This guide compares all three, shows the exact steps for each, and explains what to do when a page loads data dynamically or sits behind a login.

Three ways to get web data into Excel, compared#

The fastest route to scrape website data into Excel depends on the page. Power Query suits clean static <table> elements on public URLs. Google Sheets formulas handle simple tables and then export to Excel. A no-code extension handles everything else — dynamic grids, infinite scroll, and pages behind a login — by exporting a CSV.

Method	Best for	Handles JS / scroll / pagination	Logged-in pages	Skill needed
Excel Power Query (Data → From Web)	Static HTML tables on a public URL	No	Hard	Low
Google Sheets IMPORTHTML / IMPORTXML, then export	Simple static tables and lists	No	No	Low
No-code browser extension → CSV	Any repeating list, grid, or table	Yes	Yes	None

The split is mostly about how the page delivers its data. If you can view the page source and see the rows sitting in plain HTML, Power Query or Sheets formulas will work. If the rows only appear after scripts run, you need a tool that reads the live page in your browser.

How do I use Excel Power Query (Data → From Web)?#

In Excel, go to the Data tab, click From Web, paste the page URL, and press OK. Power Query opens a Navigator listing every table it finds. Pick one, click Load, and the rows drop into a worksheet. It works well for static HTML tables and fails on JavaScript-rendered content.

Here is the full sequence:

1. Open Excel and select the Data tab.
2. Click Get Data → From Other Sources → From Web (or just From Web on newer versions).
3. Paste the page's URL and press OK.
4. In the Navigator pane, select the table that matches your data. The preview on the right confirms you picked the correct one.
5. Click Transform Data to clean it first (remove columns, split text, fix types) or Load to drop it straight into a sheet.

Power Query is genuinely powerful and built right into Excel, so it is the natural first try. It also remembers the query, so you can refresh it later (more on that below).

When Power Query fails#

Power Query reads the raw HTML that the server first returns. It does not run the page's JavaScript. So it breaks when:

• The data is rendered by JavaScript after load (most modern web apps, dashboards, and feeds).
• The page uses infinite scroll, so only the first batch exists in the initial HTML.
• The content sits behind a login, a cookie wall, or a region check.
• The "table" is built from <div> elements instead of a real <table>, so Power Query sees no table to grab.

How do I scrape with Google Sheets and export to Excel?#

Open a Google Sheet, put =IMPORTHTML("https://example.com","table",1) in a cell, and Sheets pulls the first table from that page. For lists, use "list" instead of "table". When the data lands, choose File → Download → Microsoft Excel (.xlsx) to move it into Excel.

The two core functions:

• =IMPORTHTML("url", "table", 1) — imports the first <table> on the page. Change the index to grab the second, third, and so on.
• =IMPORTHTML("url", "list", 1) — imports the first <ul> or <ol> list.
• =IMPORTXML("url", "//xpath") — pulls specific elements using an XPath query, for finer control.

Once the cells fill, download the sheet as .xlsx and open it in Excel. This route is free and needs no add-ons. Its limits mirror Power Query: it reads static HTML only, so it cannot see JavaScript-rendered rows, follow infinite scroll, or reach logged-in pages. IMPORTXML also asks you to write XPath, which is a mild learning curve.

How do I get dynamic or logged-in pages into Excel?#

For JavaScript pages, infinite scroll, or anything behind a login, use a browser extension that reads the live, fully-rendered page. It detects the repeating pattern, collects every row across scroll and pagination, and exports a CSV you open in Excel. Because it runs in your own browser, it sees the page exactly as you do — already logged in.

This is the gap the formula methods cannot close. An in-page tool like Calquer operates on the page after the site's scripts run, so the rows that Power Query and IMPORTHTML never see are right there. Here is the workflow:

1. Open the page with the list, grid, or table you want.
2. Launch the extension. A good detector scans the page and highlights the largest repeating group automatically — no XPath, no CSS selectors.
3. Confirm the pattern, then toggle off columns you do not need and rename the rest in plain English. For native tables and ARIA grids, columns are named from the real headers.
4. Start the collection. The tool auto-scrolls lazy-loaded lists and follows "Next page" controls, gathering every matching row.
5. Review the results and export as CSV (also available: JSON and TSV).
6. In Excel, choose File → Open and pick the CSV, or use Data → From Text/CSV for control over delimiters and encoding.

Because the work happens on your device, nothing about the page leaves your browser — no account, no server. That matters when the data is a client list, internal report, or anything sensitive. See how Calquer keeps everything on-device.

Opening the CSV cleanly in Excel#

Double-clicking a CSV usually works, but Data → From Text/CSV is safer. It lets you set the delimiter (comma versus semicolon), choose the file encoding (pick UTF-8 so accented characters and symbols survive), and preview the columns before loading. This prevents the classic "everything landed in column A" problem.

How do I clean and format the scraped data in Excel?#

Most scraped data needs a quick pass. Use Data → Text to Columns or Power Query's transform step to split combined fields, TRIM to drop stray spaces, and Remove Duplicates on the Data tab to clear repeated rows. Format prices and dates as proper number and date types so Excel can sort and total them.

A practical checklist after import:

• Remove duplicates. Pagination sometimes overlaps, repeating the first item. Select the range, then Data → Remove Duplicates.
• Trim whitespace. Wrap a column in =TRIM(A2) to clear leading and trailing spaces, then paste as values.
• Split combined columns. Use Text to Columns to break "$1,299 / mo" into an amount and a period, or to separate a city and state.
• Fix data types. Right-click a column, choose Format Cells, and set numbers, currency, or dates so sorting and formulas behave.
• Drop empty columns the detector picked up but you do not need.

If you scraped a single HTML table and just want it tidy fast, our walkthrough on scraping an HTML table to CSV in Chrome covers the table-specific edge cases.

How do I refresh the data over time?#

It depends on the method. A Power Query connection refreshes with Data → Refresh All, and you can set it to refresh on open or on a timer. Google Sheets IMPORTHTML re-fetches automatically on a schedule. A CSV export is a one-time snapshot — to update it, re-run the extension and re-import.

Method	Refresh behavior
Power Query	Manual Refresh All, or scheduled refresh on file open / interval
Google Sheets formulas	Auto re-fetches periodically while the sheet is open
CSV from an extension	Static snapshot; re-run the scrape to update

For data you track repeatedly — like prices or stock levels — a static snapshot still works well if you re-run it on a routine. Our guide to tracking product prices in a spreadsheet without code shows how to turn periodic CSVs into a simple history table.

A quick legal and etiquette note#

Reading public data already visible to you is generally fine, but it depends on the site's terms of service and the kind of data involved. Frameworks like the EU GDPR and California's CCPA govern personal data, and cases such as hiQ Labs v. LinkedIn shaped the US conversation around public-data scraping. Check a site's robots.txt and terms, and avoid hammering servers. For a plain-English overview, read whether web scraping is legal.

FAQ#

Can Excel scrape a website without VBA?#

Yes. Excel's built-in Power Query (Data → From Web) imports HTML tables with no VBA and no macros. It handles static, public tables well. For JavaScript-rendered pages, infinite scroll, or logged-in content, pair Excel with a browser extension that exports a CSV you then open.

Why does Power Query say it found no tables?#

Power Query reads only the raw HTML the server first sends; it does not run JavaScript. If the rows are rendered by scripts, built from <div> elements rather than a real <table>, or sit behind a login, Power Query sees nothing to import. Use an in-browser extension instead.

How do I import web data into Excel from a dynamic page?#

Use a browser extension that reads the live, rendered page in your browser, exports the rows as CSV, then open that CSV in Excel via Data → From Text/CSV. Because the tool runs on the already-loaded page, it captures JavaScript content, infinite scroll, and logged-in views.

Is IMPORTHTML or Power Query better for one quick table?#

For a single static table, both are fast. IMPORTHTML in Google Sheets is a one-line formula and re-fetches on its own. Power Query keeps everything inside Excel and remembers the query for easy refresh. Pick whichever app you already have open.

Will my data stay private if I use an extension?#

It depends on the tool. Cloud scrapers send the page to a server. A local extension that runs entirely on your device keeps the data with you — nothing is uploaded and there is no account. Calquer uses only activeTab, scripting, and storage permissions, with no host access. See our privacy approach.

---

Ready to try it? Add Calquer to Chrome and turn the next list, grid, or table you are viewing into a clean Excel-ready file — free, no code, 100% in your browser.