How to scrape a website to Excel
In short: Scrape data from a website into Excel in one of four ways: copy and paste for a small, clean table; Excel's built-in From Web (Power Query) for HTML tables you want to refresh; a no-code browser extension for lists, cards, and JavaScript pages; or code for large, scheduled jobs. The right choice depends on how the page is built.
What "scraping to Excel" actually means
Web scraping is simply reading the data that a page displays and copying it into a structured format — rows and columns. The web page already contains the data as HTML; the job is to pull out the parts you care about and drop them into a spreadsheet. You do not need a server or a programming background for most everyday jobs. The right method depends on how the page is built.
Method 1 — Copy and paste (the 30-second option)
For a small, clean HTML table, plain copy-paste often works. Select the table with your mouse, press Ctrl+C (or Cmd+C), click a cell in Excel, and paste. Excel usually keeps the column structure.
- Highlight the table rows on the web page.
- Copy, then in Excel use Paste Special > Text or Match Destination Formatting to avoid dragging in stray styles.
- Clean up any merged headers by hand.
It is fast, but it falls apart on long lists, cards that are not real tables, and anything spread across several pages.
Method 2 — Excel's built-in "From Web" (Power Query)
Modern Excel can import HTML tables directly, no add-in required.
- Open Excel and go to Data > Get Data > From Other Sources > From Web.
- Paste the page URL and click OK.
- In the Navigator, pick the table Excel detected and click Load.
- Use Transform Data first if you want to remove columns or fix headers before loading.
This is genuinely good for stable, well-formed tables — and it can refresh on demand. Its limits: it works best on content that arrives as real HTML tables, so it can miss lists, product cards, and some content a page draws with JavaScript after loading. On those pages the Navigator may show nothing useful.
Method 3 — A no-code browser extension (the easy path)
When the page is a list of cards, an infinite feed, or a table that Power Query cannot see, a browser extension that reads the rendered page is the simplest fix. This is where ScrapeSheet fits: it runs on the page you already have open, detects the tables and lists for you, and exports to Excel (.xlsx), CSV, or the clipboard.
- Install ScrapeSheet from the Chrome Web Store and pin it.
- Open the page with the data you want and click the ScrapeSheet icon.
- Click Extract. It picks up the tables and lists automatically; for messier pages you can describe the columns you want in plain language (Pro, with your own Claude or OpenAI key).
- Export the result to Excel and open the
.xlsxfile.
Because it reads the page as your browser displays it, it can also pick up content that scripts add after loading, which often trips up Method 2, and with Pro it follows pagination and loads infinite-scroll lists — see our guide on scraping multiple pages. The free plan allows up to 20 rows per export and one page per run; ScrapeSheet Pro (€12.99 per month) removes both limits.
Method 4 — Code (only when you really need it)
For large, repeatable, or scheduled jobs, a script in Python (with requests and BeautifulSoup, or pandas.read_html) or a headless browser gives full control. It is powerful but overkill for a one-off export, and it means maintaining code when sites change their markup. Most people never need it.
Which method should you pick?
- One clean table, one time: copy-paste or From Web.
- A table you will re-import regularly: From Web, so it refreshes.
- Lists, cards, JavaScript pages, or many pages: a no-code extension like ScrapeSheet.
- Thousands of pages on a schedule: a maintained script.
Scrape responsibly
Whatever the method, be considerate: check the site's terms and its robots.txt file (the format is standardized in RFC 9309), avoid hammering servers, and take extra care with personal data. We cover this in is web scraping legal?
More step-by-step guides are on the ScrapeSheet blog.
FAQ
What is the easiest way to scrape a website to Excel?
A no-code browser extension is the easiest: open the page, click Extract, and export to .xlsx. Excel's built-in From Web tool works well for clean HTML tables but can struggle with lists and JavaScript-rendered pages.
Can Excel scrape a website by itself?
Yes, via Data > Get Data > From Other Sources > From Web (Power Query). It imports HTML tables detected on the page, but it can miss lists, cards, and content loaded by JavaScript.
Do I need to code to scrape a website?
No. Excel's From Web tool and no-code extensions like ScrapeSheet require no programming. Code is only needed for large, custom, or automated pipelines.
Sources
General information, not legal advice. Always check the website's terms and the data-protection rules that apply to you.