2026-06-18 · Table to Sheets guide

How to copy a table from a website into Excel — without the mess

You see a tidy table on a web page — prices, stats, a schedule — and you just want it in Excel so you can sort and total it. Then you copy, paste, and it lands as a jumbled mess: columns shifted, footnotes glued to numbers, everything crammed into one cell. Here are the three real ways to copy a table from a website into Excel, what each one is good for, and the one that stays clean.

1. Copy and paste (and why it scrambles)

The obvious move: select the table on the page, Ctrl+C, click a cell in Excel, Ctrl+V. Sometimes it works. Often it doesn't, and the reasons are predictable:

• Merged cells. Header cells that span two columns on the page push everything below them out of alignment once they hit a grid.
• Footnote markers and symbols. A value like 1,234[1] or $1,234 pastes as text, not a number — so Excel won't sum or sort it until you clean every cell by hand.
• Hidden or styled columns. Some "columns" are really <div>s and spacing tricks. They come across as extra junk columns or vanish entirely.

You can soften this with Paste Special. After copying, in Excel choose Home > Paste > Paste Special, then Text or Match Destination Formatting to strip the web styling. It helps with stray fonts and colors, but it does nothing for merged cells or footnote markers welded to your numbers — those still land as text.

2. Excel's Data > From Web (Power Query)

Excel has a built-in importer: Data > From Web, paste the page URL, and Power Query tries to detect tables for you to pick from. When it works on a simple, public page, it's genuinely good — and it can refresh later.

The limits show up fast:

• JavaScript-rendered pages. Most dashboards, stats sites, and "interactive" tables are built in your browser after the page loads. Power Query fetches the raw page, doesn't see that data, and finds nothing useful.
• Login-gated pages. If the table only appears when you're signed in, the importer — which isn't signed in as you — can't reach it.
• It's fiddly. Navigating the navigator pane, picking the right table out of several, and adjusting steps is more friction than most people want for a one-off grab.

3. Export the table to a clean CSV, then open it in Excel

The simplest reliable path is to skip the scramble entirely: have a browser extension read the table you're already looking at and hand you a clean CSV — which Excel opens with a double-click. (CSV is a plain spreadsheet file; it's not a native .xlsx, but Excel opens it directly and you can Save As .xlsx once it's in.)

This works where copy-paste and Power Query struggle, because the extension reads the table's rendered structure right in your browser — after the page's JavaScript has run, and while you're logged in.

That's what Table to Sheets is built for:

1. Open the page with the table and click the Table to Sheets button.
2. It finds every table on the page and lists them — pick the one you want.
3. Download a clean CSV and open it in Excel.

The CSV export is free and unlimited — no row cap. It reads the page's real HTML, not a screenshot, so there's no OCR guesswork and your columns stay lined up. It also only runs when you click it, and doesn't track you.

If your numbers still arrive carrying footnote markers like [1], thousands-separator commas, or a leading $ or £, the optional Pro tier ($5/mo) adds a clean mode that strips those so values import as real numbers — plus one-click export straight to a new Google Sheet. The free unlimited CSV that opens in Excel covers most jobs on its own; clean mode just saves the find-and-replace afterward. You can grab the extension here and start with the free export.

The short version

• Copy-paste is fine for small, simple tables but scrambles on merged cells, footnotes, and hidden columns — Paste Special helps with styling only.
• Data > From Web can work on simple public pages but struggles with JavaScript-rendered and login-gated tables, and it's fiddly.
• For everything else, export the rendered table to a clean CSV with a browser extension and open it in Excel — the fastest path that keeps your columns and numbers intact.