Wednesday, August 7, 2019

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("","table",3)
Embedded below is a GIF showing how data was gathered.

Take care,

No comments:

Post a Comment