2026-06-16 · Table to Sheets guide

How to export a big web table (more than 250 rows) to CSV — free

You found a long table on a web page — a few thousand rows of data you need in a spreadsheet — and the tool you tried only gave you the first couple hundred. Or it let you preview the whole thing, then asked you to upgrade before it would actually download. Here's how to get every row into a clean CSV without paying for the privilege.

Why big tables get cut off

Most "export a table" tools that cut you off do it for one of three reasons:

• A free-tier row cap. Plenty of popular extensions quietly limit free exports to around 250 rows. You don't find out until your export stops short — usually right in the middle of the job.
• An "upgrade to download" wall. Some tools happily show you the full table, then gate the actual CSV or Excel download behind a paid plan or a trial that expires.
• Copy-paste falling apart. Selecting a giant table by hand and pasting it into a spreadsheet works until it doesn't — merged cells, footnotes, and hidden columns scramble on the way over, and very long tables often select incompletely.

Ways to get the whole table

1. Built-in spreadsheet import. In Google Sheets, =IMPORTHTML(url, "table", 1) can pull a static table with no row limit. The catch: it only works if the table is plain HTML and public — it fails on JavaScript-rendered tables (most dashboards and stats sites) and anything behind a login.

2. Save the page and clean it up. You can save the HTML and open it in a spreadsheet app, but you'll usually spend more time cleaning footnotes, symbols, and stray columns than the export saved you.

3. Use a browser extension with no row cap. This is the simplest reliable path for big tables. A good one reads the table directly in your browser — so it works on JavaScript-rendered and logged-in pages — and exports the entire table, however many rows.

Getting every row, free

Table to Sheets is built around exactly this problem. Its CSV export is free and genuinely unlimited — no row cap, no monthly quota, and no "upgrade to download" wall. Whether the table is 30 rows or 30,000, you get the whole thing.

1. Open the page with the table and click the Table to Sheets button.
2. It finds every table on the page and lists them — pick the one you want.
3. Download a clean CSV with every row. (Want it in Google Sheets in one click, plus a clean mode that fixes footnotes and number formatting? That's the optional $5/mo Pro tier — but the full-size CSV export stays free.)

Because it reads the page's real rendered structure, your columns stay intact and your numbers come across as numbers — not text with stray commas and footnote markers.

The short version

• If a tool stops at ~250 rows or paywalls the download, that's a product limit, not a limit on what's possible.
• IMPORTHTML handles big static, public tables for free — but not JavaScript or login-gated ones.
• For everything else, a browser extension with no row cap is the fastest way to get the full table into a clean CSV.