Copy a Table From a Website to Excel (Even When Paste Breaks)
By M H TawfikUpdated 12 min read
To copy a table from a website to Excel cleanly, paste it as plain text (Paste Special → Text) so Excel ignores the page's styling, or skip pasting entirely: pull the table with Data → From Web, or use a free table extractor that reads the rendered table and hands you a clean CSV or clipboard copy. Plain Ctrl+V fails because Excel receives the page's HTML — merged cells, hidden rows, links, and layout included — not the tidy grid you see on screen.
This guide explains exactly why your paste just scrambled, the quick fixes that rescue most tables in under a minute, and the reliable methods for the tables that refuse to cooperate.
Why does pasting a table into Excel scramble the data?
Pasting scrambles because Excel does not paste what you see — it pastes the HTML behind it. The browser puts both a formatted version and a plain-text version of your selection on the clipboard, and Excel prefers the formatted one. That version carries every structural quirk of the page straight into your worksheet.
The usual culprits:
- Merged cells (
rowspan/colspan). A header that spans three columns, or a category cell that spans five rows, becomes a merged blob in Excel. Every value after it shifts into the wrong column, and the rows below stop lining up. - Fake tables built from
<div>elements. Many modern pages style<div>and<span>blocks to look like a table without any<table>markup underneath. There are no real rows or cells to copy, so the selection lands as one long column of text — or one giant cell. - Lazy-loaded rows. Long tables often render only the rows on screen and load the rest as you scroll. Select-all copies what currently exists in the page, so you paste 40 rows of a 400-row table and may not notice until later.
- Links and images inside cells. A product cell that contains a thumbnail, a linked title, and a rating widget can paste as several cells, an embedded image floating over your sheet, or a hyperlink you did not want. One rich cell becomes three messy ones, and the columns drift.
- Locale and encoding mismatches. A European page showing
1.299,50 €pastes into a US-locale Excel as text, not a number.03/04/2026silently becomes March 4 or April 3 depending on your region. Currency symbols and accented names can arrive garbled if the encoding gets mangled along the way.
Here is the quick diagnosis chart:
| Symptom | Likely cause | Fix |
|---|---|---|
| Columns shifted, rows misaligned | Merged cells (rowspan / colspan) | Paste as text, or export with a tool that reads the rendered layout |
| Everything landed in one column or one cell | <div>-grid "fake table", no real <table> markup | Use a pattern-detecting extractor; copy-paste cannot see cells that do not exist |
| Only part of the table came through | Rows lazy-load on scroll or sit on later pages | Use a tool that collects rows across scroll and pagination |
| Random images and hyperlinks in the sheet | Rich content inside cells | Paste Special → Text, or route through Notepad first |
| Numbers align left and will not sum | Locale mismatch or numbers pasted as text | Convert with Text to Columns or VALUE() after import |
€, £, or accented letters look garbled | Encoding mismatch | Re-import via Data → From Text/CSV and choose UTF-8 |
| Dates wrong or treated as text | Source date format differs from your locale | Re-parse with Text to Columns → Date and set the source order |
Knowing which failure you hit tells you which fix below to reach for.
What quick fixes work when paste breaks?
When a paste scrambles, strip the formatting before Excel sees it. Three fixes handle most cases: paste as plain text inside Excel, bounce the copy through Notepad, or paste into Google Sheets first and move it over. Each takes under a minute.
1. Paste Special → Text
Copy the table again, click the destination cell in Excel, then use Home → Paste → Paste Special → Text (or paste with Ctrl+Shift+V in newer versions and pick values only). Excel now takes the plain-text version from the clipboard, which drops merged-cell formatting, images, hyperlinks, and fonts. Tab characters between cells still split into columns, so a well-structured table usually lands clean.
2. Paste into Notepad first
Paste the copied table into Notepad (or any plain-text editor), select everything, copy again, and paste that into Excel. Notepad can only hold plain text, so this forcibly launders the clipboard — same effect as Paste Special, but it also lets you eyeball the raw rows and delete junk lines before Excel ever sees them.
3. Use Google Sheets as an intermediary
Google Sheets is noticeably more forgiving with messy HTML tables than Excel. Paste the table into a blank Sheet, check that the columns landed correctly, then either copy the now-clean range into Excel or download it via File → Download → Microsoft Excel (.xlsx). For static public tables you can even skip the copy and let a formula fetch it — the no-code website-to-Excel guide covers IMPORTHTML step by step.
Before reaching for any fix, check what you copied, not just how you pasted it. If the page lazy-loads rows, scroll to the bottom of the table first so every row exists in the page — no paste trick can recover rows that were never on the clipboard.
These fixes are great for one-off jobs on real <table> markup. They do nothing for <div>-grid fake tables (no cells exist to copy) and nothing for rows split across pagination. For those, you need a method that reads the page itself.
How do I pull the table with Excel's Data → From Web?
Instead of copying at all, let Excel fetch the table: go to Data → From Web, paste the page URL, and press OK. Power Query lists every <table> it finds in a Navigator pane; pick yours, preview it, and click Load. The rows arrive as a proper Excel table with no clipboard involved.
This route has two genuine advantages. First, Power Query parses the HTML structurally, so merged cells and stray formatting cause far less damage than pasting. Second, the query is saved — Data → Refresh All re-pulls the table later, which is ideal for data you check repeatedly.
Its limits are just as real:
- It reads the raw HTML the server first returns and does not run JavaScript, so tables drawn by scripts show up as nothing.
<div>-grid fake tables are invisible to it — there is no<table>for the Navigator to list.- It cannot follow infinite scroll or "Next page" links, so it captures only what is in the initial HTML.
- Pages behind a login usually return a sign-in screen instead of your table.
If the Navigator shows your table, take the win. If it shows nothing — or the wrong thing — the page is dynamic, and the next method is built for exactly that.
What is the most reliable way to copy a web table into Excel?
The most reliable way is to read the table as the browser renders it, then export proper rows and columns. A free table extractor such as Calquer does this in one pass: it auto-detects the table on the page, turns the real headers into column names, collects every row — including ones that load on scroll or sit on later pages — and gives you a CSV or a clean clipboard copy to paste straight into Excel.
The workflow:
- Open the page with the table in Chrome, Firefox, or Edge.
- Run the extension. It scans the rendered page and highlights the largest repeating group — your table. This works on real
<table>markup and on<div>-grid fake tables, because it detects the visual pattern rather than searching for<tr>tags. - Confirm the columns. For native tables and ARIA grids, the real
<th>and column-header cells become your column names automatically. Toggle off columns you do not need and rename the rest. - Collect the rows. The tool gathers every matching row, scrolling through lazy-loaded sections and following pagination so the export matches the full table, not just the first screen. The mechanics are covered in scraping infinite scroll and pagination to CSV.
- Export or copy. Download CSV, JSON, or TSV — or copy the result to the clipboard and paste it directly into Excel or Google Sheets as clean, tab-separated cells.
Notice what this sidesteps: merged cells map to the right columns because the tool reads the laid-out table; links become text (or a URL column you choose to keep) instead of live hyperlinks; images stop floating over your sheet; and partial copies disappear because collection runs until the table is fully gathered.
Everything in this workflow runs on your device — the page is never uploaded anywhere. That matters when the table is an internal report, a client list, or anything behind a login that should not pass through a third-party server.
For the table-specific deep dive — nested tables, sorted views, multi-page exports — see scrape any HTML table to CSV in Chrome. And if your data is not really a table at all (cards, search results, listings), the broader method in how to export any website to CSV without code applies.
How do I fix numbers stored as text and broken dates after import?
After any import, fix types before you analyze: convert text-numbers with Text to Columns or VALUE(), re-parse dates with the correct source order, and import CSVs as UTF-8 so symbols survive. Two minutes of cleanup prevents an afternoon of silent wrong answers.
Numbers stored as text
Left-aligned numbers, a green corner warning, or a SUM that returns 0 all mean Excel is holding text. To convert a whole column at once, select it, run Data → Text to Columns, and click Finish without changing anything — Excel re-evaluates each cell and recognizes the numbers. If the values carry currency symbols or thousands separators ($1,299 or 1.299,50 €), strip those first with Find & Replace, or wrap the cell in a formula like =VALUE(SUBSTITUTE(SUBSTITUTE(A2,"€",""),".","")) adapted to the source format. For European-style decimals, Data → From Text/CSV also lets you set the locale at import so 1.299,50 parses as a number directly.
Dates in the wrong format
The dangerous failure is not a date that errors — it is 03/04/2026 quietly importing as the wrong day. Select the date column, run Data → Text to Columns, choose Date in the final step, and tell Excel the source order (DMY for a European page, MDY for a US one). Excel re-parses every cell against that order and stores real dates, which then sort and subtract correctly. Where you control the export, prefer ISO format (2026-06-11) — every locale of Excel reads it unambiguously.
Garbled symbols and accents
If € became € or names lost their accents, the file was opened with the wrong encoding. Do not double-click the CSV; import it via Data → From Text/CSV and set File Origin to 65001: Unicode (UTF-8). The preview updates immediately, so you can confirm the characters are intact before loading.
If your end goal is a working spreadsheet rather than a one-time grab — totals, lookups, refreshed data — the full pipeline from page to finished workbook is laid out in getting website data into Excel.
FAQ
Why does my table paste into one column in Excel?
The "table" is almost certainly built from styled <div> elements rather than real <table> markup, so the clipboard contains no cell boundaries — just lines of text. No paste option can fix that. Use a pattern-detecting extractor that reads the repeating visual layout and exports real rows and columns.
How do I copy a table from a website without the formatting?
Copy the table, then in Excel use Paste Special → Text so only the plain-text version of the clipboard is used. Alternatively, paste into Notepad first and re-copy from there. Both drop fonts, colors, merged-cell formatting, images, and hyperlinks while keeping the tab-separated cell structure.
Why did only some of the rows copy?
The table loads rows lazily — only the rows near your viewport exist in the page when you copy. Scroll to the very bottom of the table first so every row renders, or use a tool that auto-scrolls and collects rows until the table stops growing, including rows on later pages.
How do I paste a table into Excel and keep the hyperlinks?
Paste normally (Ctrl+V) and Excel keeps links as clickable hyperlinks — along with all the other formatting you may not want. A cleaner approach is exporting with a tool that captures the URL as its own column, so you get a plain text column of links you can sort and filter instead of embedded hyperlinks.
Why do my pasted numbers not add up in Excel?
They were pasted as text, usually because of currency symbols, thousands separators, or a locale mismatch. Select the column, run Data → Text to Columns, and click Finish to force re-evaluation — or strip the symbols with Find & Replace first. Once cells right-align, SUM will see them.
Can I copy a table straight to the clipboard instead of downloading a CSV?
Yes. A table extractor with clipboard export copies the detected rows as tab-separated text, which pastes into Excel or Google Sheets as proper cells with headers in place. It behaves like a perfect manual copy — minus the merged cells, images, and missing rows.
Ready to stop fighting paste? Add Calquer to your browser and copy the next web table into Excel as clean rows and columns — free, no code, 100% on your device.