Kage LabHow to copy a table from a website into Excel
There are three reliable ways to get a table from a web page into Excel. Which one is best depends on whether the table is public, how big it is, and how often you need it.
Method 1: Copy and paste (works everywhere)
- Click just before the first cell of the table, then drag to the end of the last row. Alternatively click the first cell and Shift-click the last.
- Press Ctrl+C (Windows) or Cmd+C (Mac).
- In Excel, click the cell where the table should start.
- Right-click and choose Paste Special → Text, or the Match Destination Formatting paste option. A plain paste also works but brings the website's fonts, colours and links with it.
Common problems:
- Everything lands in one column. The page isn't a real table underneath (many modern sites use boxes styled to look like a table). Try selecting a smaller part, or use method 3.
- Extra blank rows or merged cells. Cells with line breaks or merged headers often paste badly. Use Home → Merge & Center → Unmerge Cells, then delete blank rows with a filter.
- Numbers are stored as text (green triangles in the corner). Select the column, click the warning icon and choose Convert to Number. Currency symbols and percentages may need Find & Replace first.
Method 2: Excel's "From Web" import (public pages)
Excel for Windows (Microsoft 365, and Excel 2016 or later) can pull a table directly from a web address and refresh it later. Support in Excel for Mac is more limited.
- Copy the page's address from your browser.
- In Excel, go to Data → Get Data → From Other Sources → From Web (in some versions simply Data → From Web).
- Paste the address and click OK.
- The Navigator lists the tables Excel found. Click each to preview, select the one you want and click Load.
- To update it later, right-click the table and choose Refresh.
This only works for pages anyone can open without signing in, and only for tables that are in the page when it first loads. Tables that appear after you scroll, click "Next" or sign in usually won't show up in the Navigator.
Method 3: A browser extension (logins, multi-page and messy tables)
Because an extension works inside the page you're already looking at, it can read tables behind a login (your CRM, bank or admin portal), tables built from boxes rather than real table code, and tables that load as you scroll.
With TableHop for example:
- Open the page and click the TableHop icon in your toolbar.
- Pick the table from the list (hover to see it outlined on the page).
- Click Excel to download a real .xlsx file with a bold, frozen header row and filters, or Copy to paste it yourself.
If the table is split across pages, the Pro All pages option clicks "Next" for you and merges everything into one file.
Which method should I use?
| Situation | Best method |
|---|---|
| Small public table, once | Copy and paste |
| Public table you'll refresh weekly | Excel's From Web |
| Behind a login (CRM, portal, bank) | Extension |
| Split across several pages | Extension (or the site's own export button, if it has one) |
| Loads as you scroll | Extension |
Before you start: check for an export button
Many sites and business tools already have an Export, Download CSV or Download option near the table. It's always worth a look: it gives you the site's full data, often including columns that aren't shown on screen.
Whichever method you use, only copy data you're allowed to use, and respect the website's terms.
A free extension for Chrome and Edge that copies any web table into Excel, CSV or Google Sheets – columns intact. It works on your computer and never sends your data anywhere. See how it works.