How to Import Data from Webpages into Google Sheets
This video will show you how to import tables and lists from a webpage to Google Sheets. Using the IMPORTHTML function in Google Sheets allows this import to be done very quickly. You can customize the data you import from the web by limiting columns or adding filters to get exactly what you want in Google Sheets. This is done by adding the QUERY function along with the IMPORTHTML function in Google Sheets.
0:00 Introduction
0:50 Import table from a webpage into Google Sheets
3:01 Import list from a webpage into Google Sheets
3:45 How to limit columns from the import table
5:48 Filter data from the import table into Google Sheets
Data I used in the example: en.wikipedia.org/wiki/Lists_o...
Пікірлер: 119
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.
These formulas are very handy...thanks for the demo! As always, really clearly explained and presented.
@TeachersTech
2 жыл бұрын
Thanks 🙏
Very direct, easy to follow and clean explanation. 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.
@TeachersTech
Жыл бұрын
Glad it was helpful. Thanks for sharing!
Really clearly explained and presented, thank you.
Thanks for the videos always Jimmy, they've been so helpful to me 😀
@TeachersTech
2 жыл бұрын
Glad to help!
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.
@TeachersTech
2 жыл бұрын
So happy these video help you out!
Many thanks, Jimmy, you pointed me on the right path!!!!
Very straightforward. Thank you!
Perfect. Just what I needed. Thank you! ❤
You are rocking bro. You save my life... Thank you!
You saved me some marks for my activity which was given to me.
Excellent! One of the best I"ve seen so far!
Really well done. Thank you! This will save me so much time!
I was stuck on this.Thank you.
Great video, helped me do exactly what I wanted too. Thank you very much!
Thank you so much this was very useful!
first time to get know that one can leverage sql syntax in google sheet. Thanks for the instruction.👍
Most excellent video. Thank you.
Very helpful. Thank you🙏.
@TeachersTech
2 жыл бұрын
Very welcome!
Really helpful, Thanks!
wow! that is amazing. helps a lot!
you made it easy. thank you
Thank you - perfect!
amazing, thank you!
Great video. Well explained. Just FYI, it's asterisk, not astericks.
amazing sir...thanks
This is very good. Thanks 🙏🙏
@TeachersTech
2 жыл бұрын
Welcome!
Thank you so much!
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
Thanks!
Fantastic!
Thank you so much
This is awesome.
Great video. Does it refresh automatically ? can I set it to refresh like every one minute ?
Game changer!!!!!
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!
very good I like it
thx so much.
Wow!!!! Love It.
Thank you very much! how can we import the second table that says documentaries?
Thanks for ur effort, wud u tell how can we add data validation for multiple categories for example as u shown for drama
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?
@rendisatria1708
Жыл бұрын
i also looking for this answer, does anyone knows how?
@rendisatria1708
Жыл бұрын
i also looking for this answer, does anyone knows how?
Excellent - not working for me yet - going to look for a basic troubleshooting guide. Thanks
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
2 жыл бұрын
I’ll check into this. I only tested it on a few pages.
@DjDomiC101
2 жыл бұрын
@@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
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
Thanks a lot. Do you have any course or playlist for webscraping using Sheets ?
Usefull
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.
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 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!
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.
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
Nice
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 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 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
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.
@cheesanchez24
Жыл бұрын
up
Is there a way to do get tables imported from behind a login screen if we have the API key?
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
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.
please help to import specific row of the 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?
is it work with one click if the website has more table on another pages?
I have a question ^^ does the list update even if the website e.g. adds more information?
@A.Bass00
11 ай бұрын
Good question. I'd like to know a way to populate Google sheets dynamically when the value of the website is updated.
Can I do this with Royal Mail in the UK or Wix?
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?
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
Can you query specific rows and columns at the same time?
@gardnerthompson190
7 ай бұрын
wondering this too
Hi, do you know how to import data from MyMap to a spreadsheet?
hi and what if i want to only bring Row 1 in col 1 is that possible?
How can I grab a single row/column cell?
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
i am trying to input a couple different websites for fantasy purposes and I am struggling with this
How do you manage without wikipedia Lists? straigt from google?
why everyone use wikipedia for examples? I want to use it with other webpage and its not working haaha
@jakelamotta7904
Жыл бұрын
Same. Trying to get stock infos from seeking alpha and it says ‚cant fetch url‘. So annoying. Can’t fix it. Anyone any idea?
@imenetina354
Жыл бұрын
@@jakelamotta7904 i tried using it with other webpages but it didn't work for me either
@A.Bass00
11 ай бұрын
I am trying to pull a different website that I want to pull in a value, not a list or table. Any ideas?
Thanks Jimmy. How do I go about "locale" when it is not "en_US"?
@lylestavast7652
Жыл бұрын
you set it once per the file - File - Settings and it applies to all sheets... if that's what you're asking.
Ok, but what if I don't have a table, but a list, and want to just pull the first line of the list?
how can you refresh the data automatically?
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.
hello teacher, I watched your videos on KZread 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.
Do you ever miss trappin?
"Resource at url contents exceeded maximum size." :(
I tried it is not working recently at all.
🎯 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
Well, for me it works only with ";" and not ",".
@neonnuggetchoco
2 ай бұрын
holy shit, thank you so much
Tried does not work
you look like a new roblox character my guy
This didn't work
Nope not working
Thanks!
thanks