How to Copy a Table From a Website Into Excel or Word

To copy a table from a website into Excel, drag across the table in your browser, press Ctrl+C, click the top-left cell in Excel and press Ctrl+V. If the page uses a real HTML table, each row and column lands in its own cell. If everything ends up in one column, or the table is large or updates often, use Excel's Data > From Web instead: paste the page's URL and Excel imports the table directly. For Word, paste and choose Keep Source Formatting or Merge Formatting from Paste Options.

Copy a web table into Excel

1. In the browser, click just before the first header cell and drag to the last cell you need. Leave out page headings, share buttons and ads around the table.
2. Press Ctrl+C.
3. In Excel, click the cell that should become the top-left corner of the table.
4. Press Ctrl+V.
5. Check the result. If the columns are right but the styling isn't, select the Paste Options button that appears next to the pasted range and choose Match Destination Formatting to use your workbook's fonts, or Keep Source Formatting to keep the website's look.

Then check three things straight away:

• Each website column sits in one Excel column.
• Numbers are right-aligned (real numbers), not left-aligned text.
• Merged header cells from the page are unmerged before you sort or filter.

If the paste lands in one column

Undo with Ctrl+Z, then try a different format:

1. Press Ctrl+Alt+V to open Paste Special.
2. Choose HTML if it's listed. This rebuilds the table from the page's markup.
3. If HTML doesn't help, choose Unicode Text (or Text). Excel splits it on the tab characters between cells.
4. If a column still holds several values separated by commas or spaces, select it and use Data > Text to Columns.

Browsers usually put both HTML and tab-separated plain text on the clipboard when you copy a table, and the destination picks one. Rich text vs plain text on the Windows clipboard explains why the format matters.

Import the table with Data > From Web

Paste gives you a one-time snapshot. Excel's From Web connector (Power Query) reads the page itself, so it handles big tables and can refresh later.

1. Copy the page address from the browser's address bar.
2. In Excel, select the Data tab and, in the Get & Transform group, select From Web.
3. Paste the URL and select OK.
4. In Navigator, click each detected table to preview it and pick the one that matches the page.
5. Select Load. Excel adds the data as a table on a new sheet.
6. To update it later, select the table and choose Query > Refresh, or Data > Refresh All.

If Navigator shows no tables, the page probably builds its grid with scripts or layout blocks rather than HTML table tags, or it needs a sign-in. Look for a Download CSV or Export link on the site, which is usually cleaner than any paste.

Copy a web table into Word

1. Select the table in the browser and press Ctrl+C.
2. In Word, click where the table should go and press Ctrl+V.
3. Select the Paste Options button (or press Ctrl).
4. Choose Keep Source Formatting to keep the website's borders and colours, or Merge Formatting to keep the table structure in your document's font.

Avoid Keep Text Only for tables. Microsoft notes it discards tables, turning each row into ordinary paragraphs.

If the table arrives as lines of text separated by tabs, rebuild it:

1. Select the pasted text.
2. Select Insert > Table > Convert Text to Table.
3. Under Separate text at, choose Tabs, check the number of columns, and select OK.

Why web tables break when you paste

• It isn't an HTML table. Many modern sites draw grids with layout blocks or show mobile "cards". The clipboard gets a stream of text with no row and column structure. Try From Web or the site's export.
• The selection caught extra page parts. A sort icon, checkbox column or sticky header can add a stray first column. Start the selection on the first header cell.
• Merged and multi-row headers. Excel keeps merges from the page. Unmerge and fill in the blanks before sorting.
• Rows that weren't loaded. Tables that load more rows as you scroll, or collapsed sections, only copy what is on the page when you select it.
• The site blocks selection. Some pages stop you selecting text at all; copying from a site that blocks copying covers the options.

Clean up the pasted data

1. Remove links you don't need: select the range, right-click and choose Remove Hyperlinks.
2. Set number formats explicitly on the Home tab. Values copied with currency symbols or units may paste as text; how to copy a number without the currency symbol has fixes.
3. Sort or filter only after headers are unmerged.

If you later copy a filtered part of that sheet somewhere else, see how to copy only visible cells in Excel so hidden rows don't come along.

When a screenshot is the better choice

A picture is the right call when you only need to *show* the table, for example in a slide, a ticket or a chat message, or when the "table" is actually a chart drawn on the page. Press Windows logo key + Shift + S, drag around the table and paste. A screenshot can't be sorted or summed, so don't use it for numbers you need to work with. How to copy a screenshot to the clipboard covers the capture options. For charts and query results you make yourself, copying SQL results, Excel ranges and charts cleanly has better routes than a screenshot.

FAQ

Why does my pasted table show as one long column in Excel?

Excel received plain text without tab separators, or a page built without table markup. Undo, then try Paste Special > HTML or Unicode Text, or import the page with Data > From Web.

Can I keep the Excel table in sync with the website?

Yes, if you imported it with From Web. Refresh the query to pull the current version. A pasted table never updates.

Does Windows clipboard history keep the table?

Clipboard history stores text and HTML items up to 4 MB, so a modest table usually appears in Win+V. What Excel copies keep in Win+V covers the details for spreadsheet data.

Related reading

• How to Copy Only Visible Cells in Excel (Alt+;)
• Rich Text vs Plain Text on the Windows Clipboard
• Excel and Clipboard History: What Win+V Actually Keeps
• How to Copy Text From a Website That Blocks Copying

Sources

• Import data from the web (Microsoft Support) — Data > From Web, Navigator, Load and refresh.
• Control the formatting when you paste text (Microsoft Support) — Word Paste Options; Keep Text Only discards tables.
• Convert text to a table or a table to text (Microsoft Support) — Insert > Table > Convert Text to Table and Separate text at.
• Keyboard shortcuts in Excel (Microsoft Support) — Ctrl+Alt+V opens Paste Special.
• Keyboard shortcuts in Windows (Microsoft Support) — Windows logo key + Shift + S captures a region to the clipboard.
• Using the clipboard (Microsoft Support) — clipboard history formats and 4 MB limit.

Copy. Stack. Drop.

Transform your clipboard into an interactive edge shelf. Stack, pin, and drag assets into any app with zero friction.

Download for Windows Get from Microsoft Store

How to Install Guide · First 10 Minutes Guide · Drag & Drop Guide · Edge Drop vs Win+V · Support