How to Import Data from Web to Excel

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

⌚ 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

🚩 Connect with me on social

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ 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

[SavageGothamChess]

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.

[gajabathiarjuntg]

Great video Kevin. Thanks for pulling out this useful stuff.

[EPICMentorship]

Very good video Kevin, do keep it up. We are learning a lot

[KrashNav]

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.

[D_PZ]

I love your Intro!!! And videos to... Keep it up Kevin, never stop making these videos. It helps me a lot!!!

[PaulasPicks]

Thanks for this helpful video, Kevin!

[nancyfoti]

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?

[shrutigadgil]

Thanks to Kevin my hours of copy pasting work has been saved. I was literally gonna pull an all nighter for copy he have me my sleep time. I found the video at the perfect time. Thanks a bunch Kevin❤❤❤

[matthewgillis]

Very informative video that has made my tasks much more efficient! Also, the subtle diss towards Russell Stover was gold lol.

[daniellb]

Thank you for sharing. You are the golden man! 😎

[HarjeevanSingh-Tech]

Wow tbh I didn't think this was possible! Thanks Kevin, this is an extremely helpful tutorial 😁😁👍

[AvanishKesharwani]

Thank you for the video, now I will also import data from the web! :-)

[nicolehatten]

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 🙏.

[elisathree]

Thanks Kevin, very clear and easy tutorial

[harkisingh]

Cannot fault anyone of your videos!! 👌

[KnowledgeSeeker]

Kevin's tech videos are by far the best one's on YouTube!

[laylabegum]

Thanks Kevin. Very smart and quick tutorial.

[bottandsold]

Holy WOW1 thank You! This saved me hours of work!!!

[broderp]

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.

[actcadglobalsales]

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.