TableToSheet

How to copy a table from a website into Google Sheets

Updated October 26, 2026

There are three practical ways to get a table from a web page into Google Sheets. Which one works depends on how the page builds its table and whether you need the data to stay up to date.

1. Select, copy and paste

1. Drag to select the table on the web page, starting just above the first header cell and ending just below the last row.
2. Copy it (Ctrl+C, or ⌘C on a Mac).
3. In Google Sheets, click cell A1 and paste (Ctrl+V / ⌘V).

Works well for: small, simple tables.
Watch out for: selections that grab text above or below the table, merged cells that shift columns, and numbers with currency symbols or parentheses that paste as text. If formatting comes along that you don't want, paste with Ctrl+Shift+V (values only).

2. The IMPORTHTML formula (stays updated)

Google Sheets can pull a table straight from a public page:

=IMPORTHTML("https://example.com/page", "table", 1)

• The last number picks which table on the page to import, counting from 1 in the order they appear in the page's HTML. If you get the wrong table, try 2, 3 and so on.
• Use "list" instead of "table" to import a bulleted or numbered list.
• Sheets refreshes imported data periodically, so the sheet can track a page that changes.

When it doesn't work: IMPORTHTML only sees the HTML the server sends. Tables that a page builds with JavaScript after it loads, tables behind a login, and "data grids" made of <div> elements instead of a real <table> usually come back empty or as an error. Some sites also block automated requests.

3. A browser extension (for logged-in pages and data grids)

Because an extension reads the page you're already looking at in your own browser, it can export tables that IMPORTHTML can't reach, such as reports behind a login or tables rendered by JavaScript. TableToSheet lists every table and data grid on the page, and lets you copy one in a paste-ready format for Google Sheets or download it as CSV or Excel. It keeps columns aligned across merged cells and can convert values like $1,204.50 and (12,500) into plain numbers. It runs on your device; table data isn't sent anywhere.

Which one should you use?

• One-off, small public table: copy and paste.
• Public table you want to keep updated: IMPORTHTML.
• Logged-in pages, JavaScript tables, or tables you export often: an extension.

Tidying up after you paste

• Numbers stuck as text: select the column and choose Format → Number, or use Data → Split text to columns if values landed in one cell.
• Extra spaces: Data → Data cleanup → Trim whitespace.
• Repeated header rows (common with paginated tables): add a filter and hide or delete them.

Need the transactions from a PDF bank statement rather than a web page? See bank statement to Google Sheets.

TableToSheet home · Privacy policy