Website to Excel: 6 Free Ways to Get Web Data Into a Spreadsheet

To get a website into Excel, copy a clean table straight into a sheet, pull the page with Excel's Data → From Web, or run a free no-code browser extension that detects the repeating data and exports a file Excel opens directly. For most real pages, the extension route is fastest: it reads the fully rendered page, collects every row — including ones hidden behind scrolling or a "Next" button — and hands you a spreadsheet in about a minute. The right method depends on the page, so this guide compares all six free options honestly.

Each section below covers what the method handles well, where it breaks, and how to tell which one fits the page in front of you.

Why is getting a website into Excel harder than it sounds?#

The data you see in your browser and the data a tool can reach are often two different things. A page that looks like a simple table can defeat Excel's importer for reasons that have nothing to do with you:

• JavaScript rendering. Many sites ship an almost-empty HTML file and draw the actual rows with JavaScript after the page loads. Tools that read the raw HTML see nothing.
• Infinite scroll. Long lists load 20–50 rows at a time as you scroll, so anything that grabs the page once captures only the first screen.
• Pagination. Data split across "1 2 3 … Next" pages has to be collected page by page, and most importers stop at page one.
• Fake tables. Card and grid layouts built from <div> elements look like tables but contain no real rows or cells to import.
• Login walls. Dashboards, member directories, and order histories exist only inside your logged-in session, which URL-based importers cannot see.

Every method below succeeds or fails based on how it handles these five problems, so keep them in mind as you choose.

When is copy-paste enough?#

Copy-paste works when the data is a small, real <table> that fits on one screen. Select the rows, copy, and paste into Excel — for a clean static table, Excel usually keeps the columns intact, and Paste Special → Match Destination Formatting strips the web styling.

It breaks down quickly, though:

• Div grids paste as a blob. Layouts styled to look like tables often land in a single column or one long run of text.
• Merged cells shift values. Cells spanning rows or columns push neighbors into the wrong place.
• You only get what is rendered. Scroll-loaded rows and later pages are simply not in your selection.
• Links and structure are lost. URLs become plain text, and numbers sometimes arrive as text Excel will not sum.

Use copy-paste for a one-off table of a few dozen rows. The moment you find yourself pasting page after page, switch methods. For table-specific tactics — merged cells, nested tables, headers — see scrape any HTML table to CSV in Chrome.

How do I use Excel's built-in "Data → From Web" (Power Query)?#

Excel can import web pages by itself through Power Query, and for static public tables it is genuinely good. The workflow:

1. In Excel, go to Data → From Web (under Get & Transform).
2. Paste the page URL and click OK.
3. The Navigator lists every table Excel found on the page. Click each to preview it.
4. Choose Load to drop it into a sheet, or Transform Data to remove columns, fix types, and filter rows first.
5. Later, right-click the table and hit Refresh to re-pull the live page.

That refresh is Power Query's superpower: build the import once and the sheet updates itself whenever you ask. The cleanup tools are strong too — you can split columns, change data types, and filter before the data ever lands in a cell.

The limits are the five problems above. Power Query reads the page's HTML, so tables drawn purely by JavaScript often come through empty or missing from the Navigator. It does not scroll, it does not click "Next", and pages behind a normal browser login usually fail because Excel is not inside your session. When the Navigator shows you the table you want, use this method; when the Navigator comes up empty on a page you can clearly see, the content is JavaScript-rendered and you need a tool that reads the live page.

Can Google Sheets get a website into Excel?#

Yes — Google Sheets can pull a static table with one formula, and then you download the sheet as an Excel file. In any cell:

=IMPORTHTML("https://example.com/stats", "table", 1)

The last argument picks which table on the page to import: 1 for the first, 2 for the second. Swap "table" for "list" to grab a bulleted or numbered list instead. When the data appears, go to File → Download → Microsoft Excel (.xlsx) and open it in Excel like any other workbook.

Two genuine advantages: it works on any operating system with just a browser, and the formula re-fetches the page periodically, so the sheet stays roughly current until you download.

The limits mirror Power Query's, with one extra. IMPORTHTML reads raw HTML, so JavaScript-rendered tables, infinite scroll, and logged-in pages are all out of reach — and the URL is fetched by Google's servers rather than your machine, which matters if the address itself is sensitive. One handy workaround: if pagination lives in the URL (say ?page=2), you can stack one formula per page and stitch the results together, though past a few pages this gets tedious.

What is the no-code extension workflow?#

A browser extension works where the importers fail because it reads the page after your browser renders it — JavaScript content, your logged-in session, and all. A pattern-detecting one needs no setup: it finds the repeating structure on its own. With a free no-code scraper such as Calquer (Chrome, Firefox, and Edge), the workflow looks like this:

1. Open the page and let it auto-detect#

Navigate to the list, grid, or table you want and open the extension. It scans the rendered page and highlights the largest repeating group — usually exactly the data you came for. Real <table> headers are read automatically, so your columns arrive named.

2. Toggle and rename columns#

Review the proposed columns, switch off the ones you do not need, and rename the rest in plain English. You are shaping the spreadsheet before a single row is exported.

3. Collect across scroll and pagination#

Start the collection. The tool auto-scrolls infinite lists until they stop growing and follows "Next" pagination, stacking every page's rows into one dataset. (Full details in scrape infinite scroll and pagination to CSV.)

4. Export, or paste straight into Excel#

Download CSV (which Excel opens directly), JSON, or TSV — or copy the rows to your clipboard and paste them into an open Excel or Google Sheets file. The clipboard route is the quickest path from page to spreadsheet and skips the file step entirely.

Two honest limitations: pagination that reloads the entire page is only followed on the same site (same-origin), and data inside cross-origin iframes — widgets embedded from another domain — is not detected. For most lists, grids, and tables, neither comes up. For the broader point-and-click approach on any layout, see how to export any website to CSV without code; for an Excel-first walkthrough, see scrape website data into Excel with no code.

Does the site already offer a download?#

Before scraping anything, look for an export button. Plenty of sites — analytics dashboards, banking portals, government open-data sites, sports statistics pages — offer Download CSV, Export to Excel, or an ".xlsx" link somewhere near the data. When it exists, it is the best method on this list: the site hands you complete, correctly typed data with zero extraction work.

Places to check:

• Near the table itself — export icons often hide in a toolbar or "…" menu above the data.
• Account or reports pages — logged-in services frequently bury exports under settings or billing.
• Open-data portals — public agencies often publish the same data as downloadable CSV or Excel files, fresher and fuller than the web view.

The catch is obvious: most pages offer nothing, and some downloads are truncated or stale compared to what the page shows. When the button is missing, you are back to the methods above.

When do you genuinely need code or a paid service?#

Some jobs are beyond any in-browser method, and pretending otherwise wastes your time. Reach for code (Python with requests and BeautifulSoup, or a headless browser like Playwright) or a hosted scraping service when you need:

• Scale — thousands of pages or whole-site crawls, not one list.
• Scheduling — unattended runs every hour or night, written to a database.
• Pipelines — output flowing into other systems, not a spreadsheet.
• Heavy anti-bot sites — rotating proxies and solving challenges is infrastructure work, not a browser task.

The trade-offs are real: code requires programming and maintenance as sites change, and hosted services bill by usage and process the data on their servers. For the everyday "I need this page in Excel" task, both are overkill.

Which method should you choose?#

Method	Works on JS-rendered pages?	Handles scroll / pagination?	Login walls?	Effort
Copy-paste	Only what is on screen	No	Yes — you are already logged in	Low, but messy output
Excel Power Query (Data → From Web)	Rarely	No	Mostly no	Medium
Google Sheets IMPORTHTML → .xlsx	No	No — one URL per formula	No	Low
No-code browser extension	Yes	Yes	Yes — runs in your session	Low
Site's own export / data file	Yes — the site does the work	Built in	Yes, when offered	Lowest, when it exists
Code or scraping service	Yes	Yes	Sometimes, with setup	High

A quick decision path:

• Export button on the page? Use it. Done.
• Small static table, one time? Copy-paste.
• Static public table you will re-check? Power Query or IMPORTHTML — the refresh is worth the setup.
• JavaScript-rendered, scrolling, paginated, or logged-in data? A no-code extension is the only free method that handles all four.
• Thousands of pages on a schedule? Code or a paid service.

How do you clean web data once it is in Excel?#

Web data almost always needs a short cleanup pass before it behaves like spreadsheet data:

• Numbers stored as text. $1,299 will not sum. Strip currency symbols and thousands separators (Find & Replace works), or use Data → Text to Columns to re-type a whole column.
• Dates. Normalize formats like 2026-06-11 so sorting and date math work, instead of leaving mixed text dates.
• Duplicates. Overlapping pagination can repeat rows — Data → Remove Duplicates clears them in one click.
• Whitespace. =TRIM(A2) removes the stray spaces that make identical values look different to filters and lookups.

Is it legal to pull website data into Excel?#

Reading public data that is already visible in your browser is generally fine, but three things still apply: the site's terms of service, basic courtesy on volume (collect at a human pace rather than hammering a server), and personal-data law such as GDPR and CCPA if the rows describe people. Data behind your own login is yours to view, but check the terms before extracting it in bulk. For a plain-English walkthrough of the cases and rules, see is web scraping legal?.

FAQ#

How do I export a website to Excel for free?#

Use Excel's Data → From Web for static public tables, Google Sheets IMPORTHTML followed by a download as .xlsx, or a free no-code browser extension for JavaScript-rendered, scrolling, or logged-in pages. All three are free; the extension covers the most page types.

Can Excel pull data from a website automatically?#

Yes — Power Query imports it once and re-pulls the live page whenever you hit Refresh, with no further setup. The catch is that it only works on pages whose tables exist in the raw HTML; JavaScript-rendered content usually will not appear in the Navigator.

How do I get data behind a login into Excel?#

Use a tool that runs inside your browser session. URL-based importers like Power Query and IMPORTHTML fetch the page from outside, so they hit the login wall. An on-device extension reads the page you are already viewing — logged in or not — then exports a CSV or copies the rows for pasting into Excel.

Why does my pasted web data end up in one column?#

The page is almost certainly a <div> grid styled to look like a table, so there are no real cells for Excel to map. Either use Text to Columns to split the blob on a delimiter, or use a pattern-detecting extension that reads the visual repeating structure and exports proper rows and columns.

How do I get an infinite-scroll page into Excel?#

Use a tool that scrolls the page and waits for new rows until the list stops growing, then exports everything at once. Copy-paste and URL importers capture only the rows loaded at that moment — usually the first 20 to 50.

---

Ready to try it? Add Calquer to Chrome and turn the next page you are looking at into a clean Excel sheet — auto-detected, collected across scroll and pagination, exported in under a minute. Free, no code, 100% in your browser.