How to Copy a Table From a Website to Excel (5 Easy Ways)

Copying a table from a website to Excel means moving the table as structured rows and columns — not as a mangled paste or a screenshot to retype. There are five reliable ways to do it, from a two-second keyboard shortcut to a formula that pulls the table straight from a URL, and the right one depends on how often you do it and how clean the result must be.

The five ways at a glance

Method 1: Copy and paste

The zero-tool answer:

1. Select the table by dragging from its first cell to the last.
2. Press Ctrl+C / Cmd+C.
3. In Excel or Google Sheets, click a cell and press Ctrl+V / Cmd+V.
4. If columns split wrongly, use Paste Special → Text or the paste preview's split options, then fix headers by hand.

This works surprisingly well for plain HTML tables — and falls apart on merged cells, sticky headers, lazy-loaded rows and grids that were never real <table> elements. Fine for a glance; frustrating for anything you will reuse.

Method 2: Capture the table with an extension

A structure-aware extension reads the table the way the browser sees it, so rows arrive clean:

Beyond a clean single export, this is the method that scales: repeated grids of cards extract as rows the same way real tables do, several pages can be batch captured in one pass, and every capture keeps its source link. The details are on the table capture page.

Method 3: The Google Sheets formula

If the table has a public URL, Google Sheets can fetch it by itself:

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

Paste this into a cell and Sheets pulls the first table on that page. The last number selects which table (1, 2, 3…) when a page has several.

Caveats worth knowing: it only works with public URLs (no login-required pages), dynamic pages that render tables with JavaScript often return nothing, and sites that block bots break the formula. When it works, though, it is a genuine one-step import.

Method 4: Online table converters

Web-based converters take a pasted table or a URL and return a spreadsheet file. They solve the occasional one-off without installing anything — at the cost of pasting your data into a third-party website, per-use limits, and the usual lottery of formatting quality. Reasonable for public data you don't mind uploading; think twice before pasting anything sensitive.

Method 5: Python for developers

Two lines cover most cases:

import pandas as pd
tables = pd.read_html("https://example.com/pricing")
tables[0].to_csv("pricing.csv", index=False)

pandas.read_html parses every <table> on the page into DataFrames, and the rest of the Python ecosystem handles pagination, cleaning and scheduling. The trade-off is the same as any code: you own its maintenance, and JavaScript-rendered tables need heavier tooling (Playwright, for example). For comparing this path against no-code tools, see the best web scraping tools.

Which method should you use?

• One table, one time, low stakes → copy and paste.
• A table you'll reuse, share or repeat weekly → a capture extension.
• Public page, spreadsheet-first workflow → try =IMPORTHTML first.
• Sensitive data → keep it local: paste, extension or your own script — not an online converter.
• Many pages, regularly, with custom logic → Python.

The pattern across all five: structure is the thing worth preserving. A table that arrives in Excel with its columns intact is a table you can actually sort, filter and build on — everything else is cleanup work.