How to Import Data from Web to Excel
HTML-код
- Опубликовано: 23 июл 2024
- 🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to import and dynamically connect web data to your spreadsheet in Microsoft Excel. To import data from the web into your workbook, you need to ensure that there is a table of data on the web site that you would like to import. Once you import your data, if the data changes, you can refresh it. You can even configure Excel to refresh in the background, on pre-defined intervals, or every single time you open your spreadsheet. At the end, we also look at how you can use Power Query to transform your data before importing. This way any changes you make are applied anytime you update your data. By the end of this video, you'll have a strong understanding of how to import data from the web into Excel.
👋 Additional resources
- How to use Microsoft Power Query: • How to use Microsoft P...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
0:46 Find web site with data to import
1:25 Import web data into Excel
3:20 Refresh web data
4:31 Transform data
6:18 Wrap up
📃 Watch related playlists
- Playlist with all my videos on Excel: • ❎ How to use Excel
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🔔 Subscribe to my RUclips channel
ruclips.net/user/kevlers?...
🎬 Want to watch again? Navigate back to my RUclips channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert - Наука
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Wow!! Bro you are about to reach 1M subscribers Congrats!! Thanks for amazing tutorials :)
🇦🇱🇬🇧🍇🍇
Now I can stop writing scraping apps. Thanks for tying power qwery into the flow. It all comes together after watching your power query videos.
I never knew that this was possible. This is so helpful. Extremely helpful tutorial. 4:18 Yay! KCC is on top and so is your channel.
Great video Kevin. Thanks for pulling out this useful stuff.
Thanks to Kevin my hours of copy pasting work has been saved. I was literally gonna pull an all nighter for copy pasting.....but he have me my sleep time. I found the video at the perfect time. Thanks a bunch Kevin❤❤❤
Thanks for this helpful video, Kevin!
Great tutorial! Just what I was looking for. Clear, concise and easy to follow. Would you have a video to do this in Google sheets?
Very good video Kevin, do keep it up. We are learning a lot
I love your Intro!!! And videos to... Keep it up Kevin, never stop making these videos. It helps me a lot!!!
Thank you for sharing. You are the golden man! 😎
Very informative video that has made my tasks much more efficient! Also, the subtle diss towards Russell Stover was gold lol.
Thanks Kevin, very clear and easy tutorial
Wow tbh I didn't think this was possible! Thanks Kevin, this is an extremely helpful tutorial 😁😁👍
Nope, did not work. This must only work for very basic websites. I am trying to download a parts list from a website that is in a scrollable window and not fully visible. There is also a picture with hyperlinks to the table. (Its a motorcycle parts manual I want to keep a copy of for off line viewing) I also gave a ton more options than what was presented in this video.
Very informative! Good!
Cannot fault anyone of your videos!! 👌
Thanks Kevin for your video. I love watching your tutorials. They are ALWAYS clear, informative and to the point. I understand how this one works, but I'm trying to import a website that uses password credentials for entry to the site.
I don't know if you even reply to these anymore (I'm hoping u see this one) but I am struggling keep a lot of data in order and having the ability to pull from a protected site to organize in a way that's helpful to me would be a BIG help.
Do u have a video explaining this? Or a recommended link that would show me how to do this. Pleeeease, all advice welcome 🙏.
Hello Kevin, how do I extract table data from a URL (ERP table) that requires login credentials. I tried following your steps using my login credentials but was not able to extract the table to a excel file.
Thank you for the video, now I will also import data from the web! :-)
Thanks. It helped a lot.
Thanks! Actually I want to practice for which I want data, but i was not knowing how to extract data from .I haven't practice this one yet ...but noted all the step .Going to practice tomorrow.Thank you so much one more time .
thanks for the video mr kevin
Holy WOW1 thank You! This saved me hours of work!!!
Very cool! Thanks!
Hi Kevin, thanks for this useful video,
what if we have many diifferetnes table, so big, that we need to click "next" many times.
Is there a method to download the hole table instead to enter manyu differentes links?
🙌 Thank you Kevin😄
I have a question that may be explored, could you have as your desktop like a dashboard in excel that update like this. updating as it goes but as your desktop.
Thanks for the video but if the web page has a structured data(table made using class) then this idea doesn't work
any way to do that?
Kevin's tech videos are by far the best one's on RUclips!
Great .. is the import from web feature avalanche on all the web version of excel
I cannot find the "from web" tab in excel
You are using Mac?
@@Eren-da-Jaeger yes
Update your excel version
Thank you Kevin
Thanks Kevin. Very smart and quick tutorial.
Kevin Thank you for ths video and can't we transfer Excel data to web?
Can we extract data from shopping websites like Amazon, Walmart and others
I love this
Excellent !
Hi Kevin may I know if this can be done in excel 365? I couldn't find the option Get Data (from Web)
I feel excel so hard and difficult… good for u 😍
Being the boss of a 3-billion dollar company is not enough to keep Kevin too busy to make RUclips videos. Thank you for taking the time for the little guys.
Hey Kevin, amazing tutorial. just had one query here, if the table has collapsible rows then how to extract data from them. As i tried but dint work with above method😕
Is there any way to transfer the data that’s not in a table? Like could I copy and paste the entire text on the screen into the excel use that as a table format and put that into special categories
Great video+Thumbnail too Is amazing!
What do you do if the data is not in table form?
Thanks Kevin. Good one! Can anyone tell me how I can do same thing on iPhone?
Can you do videon how to create an automated word report once key headings have been filled in.
Ho Kevin, is their a way that I can auto download data from a website used for LMS using power query?
great video thank you
Great video!
Do you have any way to import data from web including url from hyperlink text?
Hi Kevin, Thank you for your video. They are very useful. Can you please make some videos on HTML & CSS as well as Java programming?
I was thinking this as I was watching... This guy needs to make a JavaScript course ASAP
Hello Kevin, could I do this from Excel google sheet? it only prompts Big data and Looker. Thanks
Thanks alot man
Man, I knew you could do this and I am pretty sure there's also a way to have it sign into the source if it's account specific activity. I know how to do data importing but not when it comes to info related to internet applications you have to sign in on to access that data.
Hi Kevin good work over there. Am looking for how to copy protected google sheets. do you have lesson about this?
Would there be a way to pull transactions from Venmo/PayPal into excel in a similar fashion?
Thanks for the share
Thanq so much❤
Is it possible to transport calendar data from Outlook, into Excel, without performing a copy/paste???
how if we need login first to access di page which want to import the data.
how to do that
Once again you enhance our knowledge on Microsoft products and give us really useful tools.
I have one request. Can you create some How to videos on using Microsoft Access within the Kevin Stratvert Cookie Company?
Hey Kennard - I have an intro to Access here: ruclips.net/video/ubmwp8kbfPc/видео.html Let me know if anything else Access related would be helpful. Cheers!
Great videos
Hi Kevin love your videos.
How do you import data from a website that requires logging in first. I do a lot of reporting and if there is a way than it will be super useful. Please advise 😊
would love to know this information
I would also love to know.
can we import paginated data using Excel??
Is there any way to import data that’s not in a table perhaps with the html class and id? Similar to how adblockers can know which part of a website to block when you have a custom filter
web scraping beutify
Sir could you please guide me to create excel auto update table about bestselling books rating on specific category say personal finance. 🙏🏾
Bro, you crushed that cookie bussiness!
How to extract data if not in tables? Thx
Thanks. Just the information I needed. Now I guess I should order some of your cookies...
how about export large list (more than 1000 rows) from a page into excel extension file (.cvc) because Alt+A doesn't copy all information on that page ?
Can this be performed on a website with login credentials?
Thanks for the great video. I have a question, do you know how to fix the credential issue after i paste the link into excel? It shows "We couldn't authenticate with the credentials provided. Please try again". Any help is much appreciated!
Wow!!
I have just downloaded Microsoft 365 on Mac. How come I am not seeing "From Web" or other options shown in your video?
Thanks!
Wow, thanks so much! Much appreciated 🙏
Missing that "Hi everyone Kevin here".
Hi Kevin,
Hopefully you can help me with this question, I am currently trying to open a igy file in Excel. According to Excel, Excel says that it is gathering the data but once it is done, the data doesn’t display. However, I am able to open the same file in a different computer with Excel. What Could be the issue? Is it an Excel setting issue? Thank you in advance!
I'm actually loving these tutorials! 6:29 Speechless
Hi der,
Its a very good video. However, when extracting data from a table that runs into multiple pages, there is a problem. The 1st page table gets copied everytime I run the same steps for the second page onwards.
pls help !!
If I want my class to fill in a template which once filled in by them n becomes a nice word report. How do I do that
How do I make the column headers the same as in the original table. Mine says column 1, column 2 etc. with the original headers right below it
whay if i want to add the new data to the wxsisting data daily and to accumalate the data insteat of replafing it to the new one?
hi there Kevin, FISRT: Thanks you very mutch for this information, is very useful for me. Now the question, it is possible to keep old information?
Does PowerPoint have a similar option?
what if you need to log in to the website we are requiring to import?
Is this feature not available on Mac?
Sir i want to get automation in a single clik website only from url link which i search from google in a excel particular cell
Is this not available on the mac version? I can't find it
very nice vedio!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
How to tell excel which browser to use?
what happens if you need to login into the site to get the data, how would you do it?
im doing a spread sheet where i need to refresh new data every 24h, and that the data which was 24h ago will still be saved on new row, is it possible? do you have any video that explains how to do it ? i didnt know how to search it on youtube , thank you for your video!
Can you make a video about updating Microsoft words, excel, PowerPoint, etc. Cuz my laptop is still at Microsoft 2007 and I don't know how to update it. =(
thank you for this but can you also make a video regarding on how to access or get external data for the sites with username and password on the web so i can try it on my excel file badly needed
Hey Kevin, when I record my voice on my phone, it's not sound like how my voice is, so is there any way to solve this?
Is there a how to import data from the web when the website requires a log in? Im trying to do this and I have my creds for the website in question but Excel can't seem to connect.
Thank you, but i am getting an "Error" like
An error occurred in the ‘’ query. DataSource.Error: An unknown error occurred when navigating to the web page.
Can you please provide me the solution?
Greetings from Pakistan 🇵🇰❤
Hi Kevin How can I link the Google Form data to Excel or to Access? I tried following your instructions, however, it did not work for me.
Hi! what if I want to extract data from Website that needs to be logged in first? is it possible and how?
I’ve seen it done before but believe it may need to be coded into the sheet. Never have been able to successfully do it myself but wish you the best of luck!
What prevents the reverse traffic where the website is pulling the data from the Excel sheet? Is this security function built into Excel or is this task a network firewall issue independent of Excel?
Perhaps this question is outside the scope of your expertise, but can you do a video where an Excel sheet or Access database serves as the data source for a public website?
You raise a very interesting point. But what Excel was doing when importing, is no different than a web browser pulling and displaying data. If a site is hosting data that might be some kind of trojan horse, your browser (or security software) should raise an alert before you even thought of importing into Excel.