How to Import Data from Web to Excel
Вставка
- Опубліковано 1 сер 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 UA-cam channel
ua-cam.com/users/kevlers?...
🎬 Want to watch again? Navigate back to my UA-cam 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: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
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.
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❤❤❤
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.
Very informative video that has made my tasks much more efficient! Also, the subtle diss towards Russell Stover was gold lol.
Great video Kevin. Thanks for pulling out this useful stuff.
Thanks for this helpful video, Kevin!
I love your Intro!!! And videos to... Keep it up Kevin, never stop making these videos. It helps me a lot!!!
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
Thank you for sharing. You are the golden man! 😎
Thank you for the video, now I will also import data from the web! :-)
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 .
Cannot fault anyone of your videos!! 👌
Thanks Kevin, very clear and easy tutorial
Wow tbh I didn't think this was possible! Thanks Kevin, this is an extremely helpful tutorial 😁😁👍
Kevin's tech videos are by far the best one's on UA-cam!
Very informative! Good!
Being the boss of a 3-billion dollar company is not enough to keep Kevin too busy to make UA-cam videos. Thank you for taking the time for the little guys.
I feel excel so hard and difficult… good for u 😍
Thanks. It helped a lot.
thanks for the video mr kevin
Holy WOW1 thank You! This saved me hours of work!!!
Thanks Kevin. Very smart and quick tutorial.
Excellent !
Thank you Kevin
Very cool! Thanks!
🙌 Thank you Kevin😄
Great video+Thumbnail too Is amazing!
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 🙏.
Great video!
I love this
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: ua-cam.com/video/ubmwp8kbfPc/v-deo.html Let me know if anything else Access related would be helpful. Cheers!
Bro, you crushed that cookie bussiness!
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
great video thank you
Thanks for the share
Great videos
Thanks alot man
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.
I'm actually loving these tutorials! 6:29 Speechless
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.
2:00 that is a deal breaker for me. Guess this is where the tutorial ends for me
Thanks. Just the information I needed. Now I guess I should order some of your cookies...
Missing that "Hi everyone Kevin here".
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, 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?
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?
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😕
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.
Thanq so much❤
Greetings from Pakistan 🇵🇰❤
Thanks!
Wow, thanks so much! Much appreciated 🙏
very nice vedio!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Kevin Thank you for ths video and can't we transfer Excel data to web?
Thanks Kevin. Good one! Can anyone tell me how I can do same thing on iPhone?
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.
I cannot find the "from web" tab in excel
You are using Mac?
@@Eren-da-Jaeger yes
Update your excel version
Great .. is the import from web feature avalanche on all the web version of excel
Wow!!
What do you do if the data is not in table form?
0:00 - Hi Kevin. 👋
6:48 - 362nd thumbs up from me. 👍 Cheers.
Hi Kevin may I know if this can be done in excel 365? I couldn't find the option Get Data (from Web)
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!
Hi Kevin good work over there. Am looking for how to copy protected google sheets. do you have lesson about this?
Can you do videon how to create an automated word report once key headings have been filled in.
Hello Kevin, could I do this from Excel google sheet? it only prompts Big data and Looker. Thanks
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?
Is it possible to transport calendar data from Outlook, into Excel, without performing a copy/paste???
Can we extract data from shopping websites like Amazon, Walmart and others
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
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
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
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
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!
I have just downloaded Microsoft 365 on Mac. How come I am not seeing "From Web" or other options shown in your video?
Ho Kevin, is their a way that I can auto download data from a website used for LMS using power query?
Sir could you please guide me to create excel auto update table about bestselling books rating on specific category say personal finance. 🙏🏾
Awesome video Kevin, I see an application with my upcoming fantasy football draft
Very cool!
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 !!
Do you have any way to import data from web including url from hyperlink text?
Very helpful video, is there a way to get data on a web page which is not in a table
same question, have you got the answer to this question yet? i dont know the answer to this problem'
For some reason I don’t have the “From web” option. Is it because i’m using the free version?
Would there be a way to pull transactions from Venmo/PayPal into excel in a similar fashion?
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!
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 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. =(
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
😍😍😍
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?
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?
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
Hi good video but I came across a snag.
The website with data only shows the table when website data is entered.
Since the URL does not change and the table does not show it cant import data..
Does 365 operate differently ? I cant seem to get to Navigator screen - I cant connect to web pages I have used in queries for years !?
doesn't seem there is an option in latest Excel for MAC
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.
how if we need login first to access di page which want to import the data.
how to do that
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?
Great basics but …. Could you automate this query to load data every day ….
Can this be performed on a website with login credentials?