Copy Table from Website to Excel — 3 Methods Compared

You found a table on a website — stock prices, sports stats, product comparisons — and you need it in Excel. You try copy-paste: broken formatting, merged cells, missing data. Sound familiar? Here are three methods that actually work, tested on 50+ websites.

Why copy-paste from websites breaks in Excel

Before we look at solutions, it helps to understand why the obvious approach fails. When you copy a table from a website, you are copying HTML — not just the text. That HTML includes:

• Invisible elements — Icons, buttons, and hidden spans that become visible text in Excel
• CSS styling — Colors, fonts, and spacing that Excel interprets unpredictably
• Merged cells — HTML colspan and rowspan that create merged cells in unexpected places
• Non-breaking spaces — Special characters that look like spaces but are not, breaking number formatting
• JavaScript content — Tables rendered by JavaScript that do not exist in the raw HTML at all

The result? A mess that takes longer to clean up than it would have taken to type the data manually.

3 methods to copy tables to Excel — compared

Here is how each method handles the common challenges:

Let us walk through each method in detail.

Method 1: Copy and paste (manual)

When to use: Simple tables on basic HTML pages. Worth trying first — it takes 5 seconds to know if it works.

Steps

1. Navigate to the page with the table
2. Click and drag to select the entire table (or triple-click to select a row, then Shift+click the last row)
3. Press Ctrl+C (Windows) or Cmd+C (Mac)
4. Open Excel, click the cell where you want the data
5. Press Ctrl+V to paste

Pro tip: Paste Special

If regular paste creates formatting chaos, try Paste Special:

1. After copying, right-click in Excel
2. Select Paste Special > Text (or press Ctrl+Shift+V)
3. This strips formatting but may also lose table structure

When this method fails

• JavaScript-rendered tables — Many modern sites (Google Finance, sports stats, dashboards) render tables with JavaScript. You will copy empty cells or "Loading..." text.
• Complex formatting — Tables with nested elements, icons, or interactive features paste as garbage.
• Hidden columns — Some sites hide columns with CSS; copy-paste includes the hidden data in wrong places.

If copy-paste fails, move to Method 2 or 3.

Method 2: Excel Power Query (From Web)

When to use: Public pages where you need to refresh data periodically (stock prices, exchange rates, public statistics).

Steps

1. Open Excel and go to Data tab
2. Click Get Data > From Other Sources > From Web (or just From Web in newer versions)
3. Paste the URL of the page containing the table
4. Excel will connect and show all detected tables — select the one you want
5. Click Transform Data if you need to clean it, or Load to import directly

Advantages

• Refreshable connection — Right-click the table and select Refresh to update data
• Transform capabilities — Power Query can clean, filter, and reshape data before loading
• No extensions needed — Built into Excel

When this method fails

• Login-required pages — Power Query fetches the page as an anonymous visitor. If the table is behind a login, you will get the login page instead.
• JavaScript tables — Power Query reads raw HTML. If the table is rendered by JavaScript (React, Angular, Vue, or plain JS), Power Query sees an empty page.
• Dynamic content — Tables that load on scroll or button click will not appear.

Method 3: Browser extension (recommended)

When to use: Any table you can see in your browser — including JavaScript tables, logged-in pages, and complex formatting. This is the most reliable method for modern websites.

A browser extension runs inside your browser, which means it sees exactly what you see. If the table is visible on your screen, the extension can export it.

Steps with HTML Table Exporter

HTML Table Exporter

Why this works when other methods fail

• Runs in your browser session — Sees logged-in pages, JavaScript content, and dynamically loaded data
• Exports clean data — Strips HTML formatting, icons, and hidden elements automatically
• Native Excel format — XLSX files open perfectly with no cleanup needed
• 100% local — Data never leaves your browser; no server processing

Troubleshooting common issues

Problem: Numbers will not calculate after pasting

Cause: Hidden characters (non-breaking spaces, invisible Unicode) that Excel treats as text.

Solution: Use a browser extension that exports clean data, or apply these formulas to fix pasted data:

• =VALUE(TRIM(CLEAN(A1))) — Removes hidden characters and converts to number
• =SUBSTITUTE(A1,CHAR(160)," ") — Replaces non-breaking spaces with regular spaces

Problem: Table appears empty in Power Query

Cause: The table is rendered by JavaScript after the page loads.

Solution: Use a browser extension instead. Power Query cannot execute JavaScript.

Problem: Only some rows are copied

Cause: The table uses virtualization (only renders visible rows) or infinite scroll.

Solution: Scroll to load all rows before exporting, or use a tool designed for virtualized tables. HTML Table Exporter PRO can handle some virtualized tables.

Problem: Dates are in wrong format

Cause: Regional date format differences (MM/DD vs DD/MM).

Solution: After importing, select the date column, go to Format > Cells > Date, and choose your preferred format. Or use HTML Table Exporter PRO which normalizes dates to ISO format automatically.

Problem: Cannot select the table

Cause: The page uses overlay elements or disables text selection.

Solution: A browser extension can still detect the underlying table. Try HTML Table Exporter — it finds tables regardless of CSS tricks.

Frequently asked questions

Summary: Which method should you use?

For most users, HTML Table Exporter is the best option. It handles the cases where other methods fail, exports clean Excel files, and takes 30 seconds to install. The free version includes XLSX export with no row limits.