Pricing pages, league tables, government statistics — getting them into Sheets usually means one giant text blob or hours of re-typing. Here is the two-click way that keeps every row and column exactly where it belongs.
Updated August 2026 · 4 minute read
Google Sheets is happy to receive a real HTML table — the problem is getting one onto your clipboard without mangling it.
Drag-select across a table and you often capture surrounding paragraphs, ads and captions. Pasted into Sheets, everything collapses into a few overloaded cells.
Screenshotting the table means running it through OCR software and fixing the errors it introduces. Numbers with wrong digits are worse than no numbers.
Fine for three rows. Not fine for the 200-row dataset behind that public dashboard.
The free Clean Copy extension for Chrome and Firefox has a dedicated Copy Table mode. It finds the real <table> element under your cursor and puts proper structured data on the clipboard.
Chrome Web Store or Firefox Add-ons — search "Clean Copy", install, done.Open the page, click anywhere inside the table,
click the Clean Copy icon, choose "Copy table".Click cell A1 in your sheet, press Ctrl+V (Cmd+V on Mac).
Every value lands in its own cell — headers included.Because the clipboard carries real table semantics, Sheets maps each <td> to its own cell automatically.
No ad fragments, cookie banners or captions — only the table you pointed at.
The same paste works in Excel, Numbers and LibreOffice Calc.
| Method | Keeps structure? | Catch |
|---|---|---|
| Select + copy text | Rarely | Grabs extra content, collapses columns |
| Screenshot + OCR | After cleanup | Digit errors are hard to spot |
| Sheets IMPORTHTML formula | Yes | Only public pages; breaks on JS-rendered tables |
| Clean Copy — Copy table | Yes | Free browser extension install required |
If your table lives behind a login or loads dynamically, the formula route fails and a local copy tool is the reliable option.
Install the free Clean Copy extension for Chrome or Firefox, click its icon while the table is on screen, choose Copy Table, then paste into your sheet with Ctrl+V (Cmd+V on Mac). Every cell lands in its own row and column.
If you select the text instead of the table element, the browser copies plain text and Sheets has no structure to work with. Copying the table itself (as Clean Copy does) preserves HTML table semantics, which Sheets understands.
Yes — the same clipboard content pastes cleanly into Excel, Numbers and LibreOffice Calc. We have a separate guide for Excel with more detail.
Scroll to the part of the table you need first so the rows exist in the page, then copy. Lazy-loaded rows that have never rendered cannot be copied because they are not in the document yet.
No. Clean Copy works entirely inside your browser. The table never leaves your machine until you paste it where you want it.