How to Import Data from Webpages into Google Sheets 

Congratulations, you're one of the few people ever where I've watched a video to solve an issue that doesn't seem to behave as expected for a "tip" to actually work, and then it actually worked, by 2:55. And I skipped the intro and watched on x2 speed. What a satisfying experience. Finally. After all these years lol

Thanks for keeping it short and to the point. Really appreciate it.

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

These formulas are very handy...thanks for the demo! As always, really clearly explained and presented.

Really clearly explained and presented, thank you.

Thanks for the videos always Jimmy, they've been so helpful to me 😀

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

Very straightforward. Thank you!

Perfect. Just what I needed. Thank you! ❤

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.

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 🤩🤩🤩🤩🤩🤩

Sir thanks for teaching so efficient lessons that solve what seems impossible before. Again thanks. God bless you.

Excellent! One of the best I"ve seen so far!

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

Really well done. Thank you! This will save me so much time!

I was stuck on this.Thank you.

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

Thank you so much this was very useful!

Great video, helped me do exactly what I wanted too. Thank you very much!

Most excellent video. Thank you.

Very helpful. Thank you🙏.

you made it easy. thank you

Thank you very much! how can we import the second table that says documentaries?

Thank you so much!

Really helpful, Thanks!

wow! that is amazing. helps a lot!

amazing, thank you!

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

Thank you - perfect!

amazing sir...thanks

Thank you so much

Thanks for the video! I am having trouble on some websites as the error #N/A appears even though there is a table on the website, any advice? Ive also tried using the list function and neither work! Thank you again!

very good I like it

Thanks!

This is very good. Thanks 🙏🙏

Fantastic!

Game changer!!!!!

Thanks for ur effort, wud u tell how can we add data validation for multiple categories for example as u shown for drama

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

Thanks a lot. Do you have any course or playlist for webscraping using Sheets ?

thx so much.

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

Wow!!!! Love It.

I was able to get a result I was happy with using this video, unsure why the query function does not react the same trying to limit with rows but I used data validation drop down to create a retroactive selectable for my sheet, not perfect but works

How do I know that data on the website is protected? It can be selected, copy and pasted but there's some sort of filter on it that prevents web scraping. If I use "list" it imports lists mentioned but if I type coloumn, nothing.

I just saw your krita tutorial video ( i have a question related that ). How can i save my artwork with layers in pc or laptop ( when i save it, it just save the final artwork and all layers are gone ) ? Please help 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.

Usefull

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?

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.

Great for sorting a dump of my share portfolio - current prices

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

thanks

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

please help to import specific row of the column

Nice

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

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

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

Thanks for sharing! as I'm beginner there is something I can't do. I want to get some soccer results to Google spreadsheets but I'm always having #N/A error. How can I fix this? Also are these data live? I mean if the source will change, will it change data on spreadsheets too? TIA!

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

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

How can I grab a single row/column cell?

what if the url is just like regular like idk the table is javascript or something. If I copy paste it all goes into 1 column

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?

is it work with one click if the website has more table on another pages?

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?

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?

It does work, but how do I make the data in the Google sheet keep updating as the website change?

Amazing content. Thanks. Can I do the same process in a website that has dynamic values changing over time? For example: a private site that shows me the weather temperature and this temperature is upgraded each minute? So I need to enter this site using my private password and to see this data live. Then I use my Google Sheets to do some convertions on these data.

is there a way to pull info from a website you have to sign into?

How to use website to match photos to text google sheets

Thanks Jimmy. Loved your teaching style. Watched your video and was successful with downloading tables from Wikipedia. But I could not get your method to work on other web sites. What's the problem?

How do you manage without wikipedia Lists? straigt from google?

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 am trying to input a couple different websites for fantasy purposes and I am struggling with this

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.

Can you query specific rows and columns at the same time?

how can you refresh the data automatically?

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.

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

Thanks Jimmy. How do I go about "locale" when it is not "en_US"?

👍👍👍

Hello I keep getting an error message saying: “Please use a desktop web browser to allow access to fetch data from external urls.” I’m using my iPad and safari is my web browser. Please help.

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

hello teacher, I watched your videos on RU-vid and wanted to consult you about a difficult issue. We want to dump the websites and e-mail addresses of the brands we found on the internet into Excel. In other words, the company or brand name on the left line, the website and email taken from automatic google right next to it. As we find new brands, we will add them to the excel file and as the code runs, it will continue to find their website and emails. I would be very grateful if you could help with this, free or paid. Enjoy your work.

I tried it is not working recently at all.

why everyone use wikipedia for examples? I want to use it with other webpage and its not working haaha

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

🎯 Key Takeaways for quick navigation: 00:23 📊 *You can import data from webpages into Google Sheets, including tables, and customize the imported data.* 01:26 🧾 *Use the "importhtml" function in Google Sheets to import data from a webpage. Syntax includes URL, query, index, and locale (which can be left blank).* 03:18 📋 *You can specify whether to import a table or a list from a webpage using the "query" parameter in the "importhtml" function.* 04:38 📊 *Limit the columns you import by using the "query" function within "importhtml" and specifying which columns you want to include.* 06:32 🧐 *You can filter specific data from a table by adding a filter condition using the "query" function in "importhtml," allowing you to extract only the data you need from the webpage.* Made with HARPA AI

Do you ever miss trappin?

Tried does not work

Well, for me it works only with ";" and not ",".

This didn't work

Nope not working

Gee, thanks for NOT posting the link to the cheat sheet like you said you would 🙄

you look like a new roblox character my guy

Thanks!

thanks