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
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
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.
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!
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?
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
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.
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?
@@TeachersTech Any Update? I am also having trouble with this. Also, is it possible to import data from a PDF link? Or can I transfer it once its in Adobe Acrobat
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.
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
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.
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.
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.
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!
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.
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?
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?
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
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.
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?
🎯 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
hello teacher, I watched your videos on RUclips 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.
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
You saved me some marks for my activity which was given to me.
Sir thanks for teaching so efficient lessons that solve what seems impossible before. Again thanks. God bless you.
So happy these video help you out!
Thanks for keeping it short and to the point. Really appreciate it.
These formulas are very handy...thanks for the demo! As always, really clearly explained and presented.
Thanks 🙏
You are rocking bro. You save my life... Thank you!
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
first time to get know that one can leverage sql syntax in google sheet. Thanks for the instruction.👍
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.
Glad it was helpful. Thanks for sharing!
I was stuck on this.Thank you.
Many thanks, Jimmy, you pointed me on the right path!!!!
Great video. Well explained. Just FYI, it's asterisk, not astericks.
Very direct, easy to follow and clean explanation. Thank you!
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 🤩🤩🤩🤩🤩🤩
Very helpful. Thank you🙏.
Very welcome!
Thanks!
amazing sir...thanks
Thanks for the videos always Jimmy, they've been so helpful to me 😀
Glad to help!
Great for sorting a dump of my share portfolio - current prices
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!
Really well done. Thank you! This will save me so much time!
Great video, helped me do exactly what I wanted too. Thank you very much!
you made it easy. thank you
Most excellent video. Thank you.
Game changer!!!!!
Thank you so much this was very useful!
Thanks for ur effort, wud u tell how can we add data validation for multiple categories for example as u shown for drama
Really clearly explained and presented, thank you.
Excellent! One of the best I"ve seen so far!
Fantastic!
Excellent - not working for me yet - going to look for a basic troubleshooting guide. Thanks
Very straightforward. Thank you!
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?
i also looking for this answer, does anyone knows how?
i also looking for this answer, does anyone knows how?
Perfect. Just what I needed. Thank you! ❤
Thank you so much!
Thanks
Thank you so much
Thank you - perfect!
Really helpful, Thanks!
Can you query specific rows and columns at the same time?
wondering this too
This is very good. Thanks 🙏🙏
Welcome!
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
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.
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?
I’ll check into this. I only tested it on a few pages.
@@TeachersTech Any Update? I am also having trouble with this. Also, is it possible to import data from a PDF link? Or can I transfer it once its in Adobe Acrobat
wow! that is amazing. helps a lot!
Usefull
thx so much.
very good I like it
amazing, thank you!
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.
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
thanks
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
Great video. Does it refresh automatically ? can I set it to refresh like every one minute ?
Thank you very much! how can we import the second table that says documentaries?
Nice
awesome!
i will like to know if there's a way to Import Data from Webpages with credentials into Google Sheets
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 a lot.
Do you have any course or playlist for webscraping using Sheets ?
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.
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.
up
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!
Wow!!!! Love It.
please help to import specific row of the column
I have a question ^^ does the list update even if the website e.g. adds more information?
Good question. I'd like to know a way to populate Google sheets dynamically when the value of the website is updated.
Is there a way I can add or customize the list while importing the data?
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.
It does work, but how do I make the data in the Google sheet keep updating as the website change?
is it work with one click if the website has more table on another pages?
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?
is there a way to pull info from a website you have to sign into?
How do you manage without wikipedia Lists?
straigt from google?
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?
Is there a way to do get tables imported from behind a login screen if we have the API key?
i am trying to input a couple different websites for fantasy purposes and I am struggling with this
Can I do this with Royal Mail in the UK or Wix?
hi and what if i want to only bring Row 1 in col 1 is that possible?
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
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.
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
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?
How to use website to match photos to text google sheets
Hi, do you know how to import data from MyMap to a spreadsheet?
🎯 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
why everyone use wikipedia for examples? I want to use it with other webpage and its not working haaha
Same. Trying to get stock infos from seeking alpha and it says ‚cant fetch url‘. So annoying. Can’t fix it. Anyone any idea?
@@jakelamotta7904
i tried using it with other webpages but it didn't work for me either
I am trying to pull a different website that I want to pull in a value, not a list or table. Any ideas?
👍👍👍
how can you refresh the data automatically?
How can I grab a single row/column cell?
I tried it is not working recently at all.
hello teacher,
I watched your videos on RUclips 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.
"Resource at url contents exceeded maximum size." :(
Ok, but what if I don't have a table, but a list, and want to just pull the first line of the list?
what about when the tables aren't so obvious like they are on wikipedia?
Thanks Jimmy. How do I go about "locale" when it is not "en_US"?
you set it once per the file - File - Settings and it applies to all sheets... if that's what you're asking.
Do you ever miss trappin?
This didn't work
Tried does not work
Well, for me it works only with ";" and not ",".
holy shit, thank you so much
Nope not working
Gee, thanks for NOT posting the link to the cheat sheet like you said you would 🙄