Import Data directly from a website into Google Sheets

If you see data from a list or table in a website and you would like to use that information, you can copy that data instantly.

To gather the information try using this formula:

• =IMPORTHTML("url","table", number table on site)

Here is the formula I used to gather data from the Wikipedia page about NFL teams.

• =IMPORTHTML("https://en.wikipedia.org/wiki/National_Football_League","table",3)

Embedded below is a GIF showing how data was gathered.

Take care,
Brad