How to export a table from a website to Excel

Updated 5 November 2026

There are four common ways to do it. The right one depends on how the page is built and whether you need to log in to see it.

1. Copy and paste

Select the table with your mouse, copy it (Ctrl+C, or Cmd+C on a Mac), and paste into Excel or Google Sheets.

Good for: one small, real HTML table.
Falls down on: long tables, product grids and card layouts (they paste as one long column), and pages where the "table" is really styled boxes. Links, images and hidden values are lost.

2. Excel's "From Web"

In Excel for Windows: Data → From Web (under Get & Transform Data), paste the page address, then pick a table in the Navigator window and click Load.

Good for: public pages with real tables that you want to refresh later.
Falls down on: pages behind a login, pages that build their content with JavaScript after loading, and lists that aren't HTML tables. Excel fetches the page itself, so it doesn't see what your browser sees.

3. Google Sheets `IMPORTHTML`

In a cell, type:

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

The last number picks which table on the page (1 = first). Use "list" instead of "table" for bulleted lists.

Good for: public pages with simple tables, kept live in a sheet.
Falls down on: the same things as Excel's From Web: logins, JavaScript-built pages, and card or grid layouts. Google's servers fetch the page, not your browser, and some sites block them.

4. A browser extension

An extension reads the page as your browser shows it, after it has loaded and after you've logged in. That's why it works on product grids, search results and dashboards where the other methods fail.

With PluckTable: open the page, click the PluckTable icon, check the preview (it names the columns for you: title, price, rating…), and click Excel. If it picked the wrong list, click the one you want on the page.

Good for: anything you can see on screen, including grids and lists that aren't tables.
Watch out for: privacy. Some free scraper extensions collect your browsing history; read the privacy policy before installing one. PluckTable sends nothing from your browser (how we compare).

Which should you use?

Your page	Use
One small, real table	Copy and paste
Public table you want to refresh	Excel From Web or IMPORTHTML
Product grid, search results, directory	A browser extension
Behind a login	A browser extension
Many pages of results	An extension that follows "Next" (PluckTable Pro)

Check the site's terms before copying data for anything beyond personal use.

PluckTable is free for every row on the page, in CSV or Excel. No account.