Plainware toolsPlainware tools TableSnap

How to copy a table from a website into Google Sheets

You found a table on a website and you want it in Google Sheets, with each value in its own cell. Depending on the page, there are three good ways to do it.

Method 1: copy and paste

  1. Select the table on the page, from the first cell to the last.
  2. Copy it.
  3. Click cell A1 of an empty sheet and paste.

Google Sheets usually keeps the columns. If formatting, colors or links come along, paste with Ctrl+Shift+V (Cmd+Shift+V on a Mac) to keep only the values.

Watch out for: tables built without real table markup, which paste as a single column of text, and very long tables that are hard to select.

Method 2: the IMPORTHTML function

Google Sheets can fetch a table from a public page by itself. In a cell, type:

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

Works for: public pages whose tables are written directly in the HTML. The data refreshes automatically.

Watch out for: finding the right table number takes trial and error. It does not work on pages that require a login, on most dashboards, or on tables generated by JavaScript after the page loads, which is the case for many modern sites.

Method 3: one-click export with TableSnap

TableSnap reads the table that you see in your browser, including on pages where you are logged in and on tables drawn by JavaScript.

  1. Open the page in Chrome and click the TableSnap icon (or press Alt+Shift+T).
  2. Every table is outlined and numbered on the page. Pick yours in the list.
  3. Click Copy to clipboard, then paste into Google Sheets: columns, numbers and headers land in the right cells.

It also recognizes many tables built with div elements or ARIA grids instead of classic table tags, handles merged cells, and can collect rows across several pages of a paginated table (Pro feature).

Nothing is uploaded: the extension reads and converts the table locally, in your browser.

In short