How to Import Data from Webpages into Google Sheets

thanks

Thank you so much

Is it possible to import data from other than public URL?
I mean I need to import data from pos software. This is not a public URL and it's access with login password

I tried it is not working recently at all.

hi and what if i want to only bring Row 1 in col 1 is that possible?

Excellent - not working for me yet - going to look for a basic troubleshooting guide. Thanks

"Resource at url contents exceeded maximum size." :(

Wow!!!! Love It.

Really helpful, Thanks!

Very direct, easy to follow and clean explanation. Thank you!

I have a question ^^ does the list update even if the website e.g. adds more information?

Would it be possible to do the pulling the opposite way? I mean, to pull data from a Google sheets into a website. For example, imagine that I had 50 words in a Google sheet database, and that each day I want my website to choose one of the words and show it, changing to a new word each day. Is there a way to do that?

Thank you - perfect!

Hello, Professor Teacher's Tech - thank you for this explanation, but the reason I came to find you is this: In the brand new Google AI interface (the one where you search by clicking on the lab beaker) today it asked me if I wanted to aff a new feature called "Add to Sheets". When I clicked on it I just got the URL. The AI interface didn't have any of your instructions in it. Please can you help me understand how the new AI search "add to Sheets" interface should be working? Thank you.

Great video. Well explained. Just FYI, it's asterisk, not astericks.

You are rocking bro. You save my life... Thank you!

first time to get know that one can leverage sql syntax in google sheet. Thanks for the instruction.👍

very good I like it

Is there a way to do get tables imported from behind a login screen if we have the API key?

Thanks this video. But If the table have many rows in many pages (when we change pages, url isn't changed), how can we get the table into google sheet? Can you guide me?
Many thanks.

thanks

wow! that is amazing. helps a lot!

how can you refresh the data automatically?

Hi, do you know how to import data from MyMap to a spreadsheet?

Nice

I honestly can't thank you enough !!
I have been struggling a long time trying to find how to do this
Thank you soooooooo much 🤩🤩🤩🤩🤩🤩

What is the solution if the website (URL) has a username and password and after that there is two field From (start date) To (End date)? Thank you

I just discovered your video! It was awesome! But what if i want just one value ? Like i want to web scrap the EUR value of a Crypto from coingecko and get it in a Google sheets case? This data isn't in a table nor in a list

Hi teachers tech,
this is a very good tutorial, just have one question, for example i just wanted to get a specific value or number on a webpage to show up on my sheet so i wont go back to the website and check it again. is that possible? the number is not clickable , the website just shows the number if its increasing its value or decreasing.

Is there a way that the import data can be saved and not still linked to the import function? So if the website goes down, the data stays. Aside from copy and special pasting?

Ok, but what if I don't have a table, but a list, and want to just pull the first line of the list?

Many thanks, Jimmy, you pointed me on the right path!!!!

I was stuck on this.Thank you.

what if my information doesn't appear to be in a list or table? How do I pull the information for example from the Steampowered website to extract a list of owned games?

Well done! Expect some hits in the coming days. I am sharing this video with my Trig students this week and they'll be downloading daylight hours data from the Astronomical Applications Department of the U.S. Naval Observatory and then coming up with a model to explain the data. Super cool and helpful video and I hope they bookmark this as it will help them in their future research in other future classes.

thx so much.

Very straightforward. Thank you!

Can I do this with Royal Mail in the UK or Wix?

This didn't work

Great video. Does it refresh automatically ? can I set it to refresh like every one minute ?

You saved me some marks for my activity which was given to me.

what about webpage with user , pass and even with PIN CODE to log in? how can we import data to spreadsheet, Sir? such as: daily bank account transaction.

you look like a new roblox character my guy

Thanks for making this video. If a website only shows 10 results per page, and it doesn't have a "show all" option, can you export all of the data or can you only export what's on the page?

Thanks!

amazing, thank you!