If you have ever tried to pull a table into Google Sheets, you probably know the feeling. Sometimes it works in ten seconds. Sometimes you get one giant column, half the rows disappear, or IMPORTHTML acts like the table does not exist.
That usually is not your fault. A lot of modern pages render tables with JavaScript, hide desktop and mobile variants in the same DOM, or wrap comparison data in layouts that look like tables but are not clean source tables underneath.
Why IMPORTHTML fails on real pages
- the page loads the table after the initial HTML
- the table you see is actually a custom layout or grid
- the page contains several similar tables and Sheets grabs the wrong one
- hidden elements and decorative content leak into the result
Why normal paste is not much better
Plain copy-paste sounds easier, but it breaks for a different reason. You are copying whatever the browser selection gives you, not a cleaned table structure.
- columns collapse into one cell
- line breaks turn into messy rows
- checkmarks, badges, and links become noisy text
- spacing looks fine on the page but pastes badly into Sheets
A cleaner workflow for Google Sheets
- Open the page with the table.
- Let TableSnap detect the table on the page itself.
- Open Preview before you copy anything.
- Remove empty rows, duplicate rows, and obvious decorative content.
- Export as TSV if you want the smoothest direct paste into Google Sheets.
- Paste the result into your sheet.
This is the practical advantage of a browser-first workflow. You are capturing the rendered table that you can actually see, then cleaning it before it ever touches your spreadsheet.
When to use TSV instead of CSV
For Google Sheets, TSV is often the safer default for direct paste.
- TSV keeps column boundaries predictable during paste
- long text cells usually survive better
- commas inside values are less likely to create confusion
CSV is still useful if you want a file export, a handoff to another tool, or a repeatable import step later. But for quick browser to Sheets work, TSV is usually the low-friction move.
What to fix before you paste
- keep only the columns you actually need
- rename vague headers before they hit the sheet
- remove mobile-only duplicates
- trim whitespace so filtering and formulas behave normally
- decide whether links should stay as URLs or become plain text
The pages where this helps most
- pricing tables
- product specification tables
- comparison pages
- research tables
- directory and ranking pages
Bottom line
If your search is really "copy table from website to Google Sheets" or "IMPORTHTML not working", the fastest fix is usually not another formula. It is capturing the visible table cleanly, shaping it once, and pasting a result that Sheets can use immediately.