How to Import Data from Web to Excel

Рет қаралды 390,392

Күн бұрын

🔥 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 KZfaq channel
kzfaq.info?...
🎬 Want to watch again? Navigate back to my KZfaq 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

Пікірлер: 201

@KevinStratvert 2 жыл бұрын

🏫 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: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@denisparker7803 2 жыл бұрын

Wow!! Bro you are about to reach 1M subscribers Congrats!! Thanks for amazing tutorials :)

@ardit9988 2 жыл бұрын

🇦🇱🇬🇧🍇🍇

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

@SavageGothamChess 2 жыл бұрын

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.

@gajabathiarjuntg2390 2 жыл бұрын

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

@shrutigadgil3084 3 ай бұрын

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❤❤❤

@PaulasPicks 2 жыл бұрын

Thanks for this helpful video, Kevin!

@nancyfoti2660 Жыл бұрын

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?

@EPICMentorship 2 жыл бұрын

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

@4D1_P74Z 2 жыл бұрын

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

@daniellb1364 2 жыл бұрын

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

@matthewgillis809 Жыл бұрын

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

@elisathree937 2 ай бұрын

Thanks Kevin, very clear and easy tutorial

@HarjeevanSingh-Tech 2 жыл бұрын

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

@broderp 7 ай бұрын

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.

@johncheung4905 2 жыл бұрын

Very informative! Good!

@harkisingh 2 жыл бұрын

Cannot fault anyone of your videos!! 👌

@nicolehatten8738 Жыл бұрын

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

@actcadglobalsales8465 2 жыл бұрын

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.

@AvanishKesharwani 2 жыл бұрын

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

@ProfGilRodrigues 2 жыл бұрын

Thanks. It helped a lot.

@PoojaYadav-py3jf Жыл бұрын

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 .

@igbamosupaulzini8397 2 жыл бұрын

thanks for the video mr kevin

@bottandsold7756 Жыл бұрын

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

@daryllarsen8858 2 жыл бұрын

Very cool! Thanks!

@JoseRuiz-gr7qi Жыл бұрын

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?

@mstonua 2 ай бұрын

🙌 Thank you Kevin😄

@thompsonsteveo2860 2 жыл бұрын

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.

@rsharma0894 2 жыл бұрын

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?

@KnowledgeSeeker26 2 жыл бұрын

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

@issiewizzie 2 жыл бұрын

Great .. is the import from web feature avalanche on all the web version of excel

@jeffreyackah786 9 ай бұрын

Thank you Kevin

@Realtystewards 2 жыл бұрын

I cannot find the "from web" tab in excel

@Eren-da-Jaeger Жыл бұрын

You are using Mac?

@Realtystewards Жыл бұрын

@@Eren-da-Jaeger yes

@Priyanshu9q 11 ай бұрын

Update your excel version

@laylabegum9304 2 жыл бұрын

Thanks Kevin. Very smart and quick tutorial.

@yigajonathan4744 2 жыл бұрын

I love this

@mash_space 2 жыл бұрын

Kevin Thank you for ths video and can't we transfer Excel data to web?

@aisurjyasamantaray3346 Жыл бұрын

Can we extract data from shopping websites like Amazon, Walmart and others

@yannicksans7141 2 жыл бұрын

Excellent !

@1039jkisrdgn 2 жыл бұрын

Hi Kevin may I know if this can be done in excel 365? I couldn't find the option Get Data (from Web)

@WorldOfRumaiza 2 жыл бұрын

I feel excel so hard and difficult… good for u 😍

@jasonluong3862 2 жыл бұрын

Being the boss of a 3-billion dollar company is not enough to keep Kevin too busy to make KZfaq videos. Thank you for taking the time for the little guys.

@sonalipatil2136 Жыл бұрын

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😕

@supperKingofworld 2 жыл бұрын

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

@swastikszn1781 2 жыл бұрын

Great video+Thumbnail too Is amazing!

@glassmug7946 2 жыл бұрын

What do you do if the data is not in table form?

@murataksu6496 Жыл бұрын

Thanks Kevin. Good one! Can anyone tell me how I can do same thing on iPhone?

@deborahrose648 2 жыл бұрын

Can you do videon how to create an automated word report once key headings have been filled in.

@danielroberts3971 Жыл бұрын

Ho Kevin, is their a way that I can auto download data from a website used for LMS using power query?

@william0mccarthy Жыл бұрын

great video thank you

@swastikszn1781 2 жыл бұрын

Great video!

@mohamadyassirmohamadkamil6975 Жыл бұрын

Do you have any way to import data from web including url from hyperlink text?

@erinee1939 2 жыл бұрын

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?

@sigfigronath Жыл бұрын

I was thinking this as I was watching... This guy needs to make a JavaScript course ASAP

@2404Pepe 10 ай бұрын

Hello Kevin, could I do this from Excel google sheet? it only prompts Big data and Looker. Thanks

@yashwanthnamburi3824 4 ай бұрын

Thanks alot man

@vlvchii 2 жыл бұрын

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.

@josephoketch7328 Жыл бұрын

Hi Kevin good work over there. Am looking for how to copy protected google sheets. do you have lesson about this?

@ShawnLaverty 2 жыл бұрын

Would there be a way to pull transactions from Venmo/PayPal into excel in a similar fashion?

@SyedMuzammilMahasanShahi 2 жыл бұрын

Thanks for the share

@priyanshushakya3978 Жыл бұрын

Thanq so much❤

@erlandatugaw8883 2 жыл бұрын

Is it possible to transport calendar data from Outlook, into Excel, without performing a copy/paste???

@bantuinUKM 2 жыл бұрын

how if we need login first to access di page which want to import the data. how to do that

@yigajonathan4744 2 жыл бұрын

Great videos

@RavenZamir 2 жыл бұрын

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?

@KevinStratvert 2 жыл бұрын

Hey Kennard - I have an intro to Access here: kzfaq.info/get/bejne/q8idqtNp0MjKgJc.html Let me know if anything else Access related would be helpful. Cheers!

@Aman1818 2 жыл бұрын

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 😊

@earthisbeautiful4665 2 жыл бұрын

would love to know this information

@andycindi1589 Жыл бұрын

I would also love to know.

@user-vk2cd9qw7i 10 ай бұрын

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

@mr.naresh3004 4 ай бұрын

web scraping beutify

@aravindvelamuri3354 2 жыл бұрын

can we import paginated data using Excel??

@CorreccionesElEscribiente Жыл бұрын

Bro, you crushed that cookie bussiness!

@sharma3226 Жыл бұрын

Sir could you please guide me to create excel auto update table about bestselling books rating on specific category say personal finance. 🙏🏾

@IntercoTireCorp Жыл бұрын

Thanks. Just the information I needed. Now I guess I should order some of your cookies...

@EonVendetta 2 жыл бұрын

How to extract data if not in tables? Thx

@nawafal-atallah9667 Жыл бұрын

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 ?

@reidervin9714 Жыл бұрын

Can this be performed on a website with login credentials?

@zaynlim1843 3 ай бұрын

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!

@aveerajsharma 2 жыл бұрын

Wow!!

@rangjungyeshe 2 жыл бұрын

Thanks!

@KevinStratvert 2 жыл бұрын

Wow, thanks so much! Much appreciated 🙏

@stevenicholas 2 жыл бұрын

I have just downloaded Microsoft 365 on Mac. How come I am not seeing "From Web" or other options shown in your video?

@sreyasimukherjee79 2 жыл бұрын

Missing that "Hi everyone Kevin here".

@jcchangshik3701 Жыл бұрын

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!

@JustBlankNoInfo 2 жыл бұрын

I'm actually loving these tutorials! 6:29 Speechless

@prashantvantagudi1376 Жыл бұрын

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 !!

@deborahrose648 2 жыл бұрын

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

@Adriaan.J.L 23 күн бұрын

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

@ravitassayag8868 2 жыл бұрын

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?

@BamboGroxo Жыл бұрын

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?

@jeepinil 2 жыл бұрын

Does PowerPoint have a similar option?

@ItsMe-sf7kh 2 жыл бұрын

what if you need to log in to the website we are requiring to import?

@NQuiz52 7 ай бұрын

Is this feature not available on Mac?

@dimpynaturalhub Жыл бұрын

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

@push_freebird6693 Жыл бұрын

very nice vedio!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

@mbadiou Жыл бұрын

Is this not available on the mac version? I can't find it

@rocko6439 2 жыл бұрын

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?

@aviv32 Жыл бұрын

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!

@oranlue2020 2 жыл бұрын

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. =(

@martinnmarie Жыл бұрын

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

@talatsultana2799 2 жыл бұрын

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?

@chronicposer Жыл бұрын

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.

@vijay123464 Жыл бұрын

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?

@AbdulRehman-gg4ss 2 жыл бұрын

Greetings from Pakistan 🇵🇰❤

@alirizvi748 10 ай бұрын

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.

@Bosunews 3 ай бұрын

Hi! what if I want to extract data from Website that needs to be logged in first? is it possible and how?

@christinadevito9525 2 ай бұрын

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!

@jasonluong3862 2 жыл бұрын

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?

@purplecrayon7281 Жыл бұрын

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.