Come for the tech tips - stay for the Dad jokes! ����
Google Instructional Videos
Windows 10 Tutorials
What is trending
AR/VR/Google Earth Tours
Follow this Blog
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.
Embedded below is a GIF showing how data was gathered.
August 07, 2019
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)
Be a Twitter Ninja - use more than 4 photos in a tweet
The other day a friend of mine saw a tweet I posted and he asked me how I put more than 4 photos in my tweet. My answer, "I'm a nin...
You can now organize those saved sports videos and recipes in Facebook to collections
A great feature in Facebook has been "save link" (available on top right of posts select the three dots). However, it was kind of ...