How to Import Data from Web to Excel

[@KevinStratvert]

🏫 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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@denisparker7803]

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

[@ardit9988]

🇦🇱🇬🇧🍇🍇

[@shrutigadgil3084]

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

[@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]

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.

[@elisabethtrihan]

Thanks Kevin, very clear and easy tutorial

[@ProfGilRodrigues]

Thanks. It helped a lot.

[@harkisingh]

Cannot fault anyone of your videos!! 👌

[@KnowledgeSeeker26]

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

[@WorldOfRumaiza]

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

[@EPICMentorship]

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

[@JustBlankNoInfo]

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

[@matthewgillis809]

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

[@HarjeevanSingh-Tech]

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

[@igbamosupaulzini8397]

thanks for the video mr kevin

[@AvanishKesharwani]

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

[@bottandsold7756]

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

[@CorreccionesElEscribiente]

Bro, you crushed that cookie bussiness!

[@swastikszn1781]

Great video+Thumbnail too Is amazing!

[@4D1_P74Z]

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

[@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?

[@PaulasPicks]

Thanks for this helpful video, Kevin!

[@jasonluong3862]

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

[@yannicksans7141]

Excellent !

[@swastikszn1781]

Great video!

[@RavenZamir]

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]

Hey Kennard - I have an intro to Access here: kzbin.info/www/bejne/q5PQqKNuoMeZhsU Let me know if anything else Access related would be helpful. Cheers!

[@daniellb1364]

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

[@mstonua]

🙌 Thank you Kevin😄

[@push_freebird6693]

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

[@sreyasimukherjee79]

Missing that "Hi everyone Kevin here".

[@johncheung4905]

Very informative! Good!

[@laylabegum9304]

Thanks Kevin. Very smart and quick tutorial.

[@yigajonathan4744]

Great videos

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

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

[@gajabathiarjuntg2390]

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

[@IntercoTireCorp]

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

[@jeffreyackah786]

Thank you Kevin

[@priyanshushakya3978]

Thanq so much❤

[@william0mccarthy]

great video thank you

[@actcadglobalsales8465]

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.

[@yigajonathan4744]

I love this

[@yashwanthnamburi3824]

Thanks alot man

[@daryllarsen8858]

Very cool! Thanks!

[@Aman1818]

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]

would love to know this information

[@andycindi1589]

I would also love to know.

[@HowToAnalyst]

Awesome video Kevin, I see an application with my upcoming fantasy football draft

[@KevinStratvert]

Very cool!

[@Realtystewards]

I cannot find the "from web" tab in excel

[@Eren-da-Jaeger]

You are using Mac?

[@Realtystewards]

@@Eren-da-Jaeger yes

[@Priyanshu9q]

Update your excel version

[@prokorshopal4865]

0:00 - Hi Kevin. 👋 6:48 - 362nd thumbs up from me. 👍 Cheers.

[@aveerajsharma]

Wow!!

[@AbdulRehman-gg4ss]

Greetings from Pakistan 🇵🇰❤

[@SyedMuzammilMahasanShahi]

Thanks for the share

[@garretreed9709]

2:00 that is a deal breaker for me. Guess this is where the tutorial ends for me

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

[@amiriqbal1871]

Very helpful video, is there a way to get data on a web page which is not in a table

[@aminrosli9744]

same question, have you got the answer to this question yet? i dont know the answer to this problem'

[@glassmug7946]

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

[@user-vk2cd9qw7i]

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]

web scraping beutify

[@rangjungyeshe]

Thanks!

[@KevinStratvert]

Wow, thanks so much! Much appreciated 🙏

[@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?

[@NoEgg4u]

Kevin, will this also work with marshmallows?

[@erinee1939]

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

[@ardit9988]

Good Evening, Everyone

[@erlandatugaw8883]

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

[@vlvchii]

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.

[@stevenicholas]

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

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

[@canirmalchoudhary8173]

Excel is powerful

[@Amee007]

Worth

[@rsharma0894]

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?

[@zaynlim1843]

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!

[@charles4372]

For some reason I don’t have the “From web” option. Is it because i’m using the free version?

[@murataksu6496]

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

[@TheCoolHani]

doesn't seem there is an option in latest Excel for MAC

[@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😕

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

[@2404Pepe]

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

[@mash_space]

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

[@josephoketch7328]

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

[@thompsonsteveo2860]

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.

[@dhammikanayanakanthi]

😍😍😍

[@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?

[@aisurjyasamantaray3346]

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

[@1039jkisrdgn]

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

[@issiewizzie]

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

[@Sun_Henry_Connie]

This is amazing! It wants to work, but does not. I went to a search engine, searched Wikipedia From within Wikipedia searched on Connie Francis. Copied the link. Opened a new sheet. Clicked on Data noticed the From Web info would not activate until after i clicked in a cell or two in the file. Clicked on: From Web Pasted in the URL. clicked: ok it connected and i can see a list of tables. I can click on Web View and see the site data. I selected the Bibliography table. i selected load. I got 3 rows of data. I tried several times before writing this and ended up with no rows of data. I don't understand how it worked this time and not my first 5 attempts. Thank You. I hope this outline helps another.

[@bantuinUKM]

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

[@GrenPara]

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

[@Adriaan.J.L]

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

[@JoeyCbr]

Can excel do this for password protected sites yet, without some 3rd party app requirement

[@brigitteperez5071]

If there are two tables within the same URL if only copies the first table and not the second - which is the set of information I need.. how do I go about it ?

[@cocoabread13]

what about when it requires authentication? like you need to log into it

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

[@ViralClips-20.24]

What if the data doesn't have the permission to click? How can i resolve it?

[@marcw.5492]

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

[@nanmer7135]

Why is mine all greyed out data not working with Office 2021 good license?

[@deborahrose648]

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

[@nawarqays7253]

Hi, When I go to get data from the web, this window appears It doesn't look like the dialog you appear in the video

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

[@sumonhasan7005]

How to do this same work in Microsoft Office 2019 or 365?

[@oranlue2020]

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

[@mohamadyassirmohamadkamil6975]

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

[@hanabinarif7333]

what if the webpage table has 109 pages? each tab contains 10 rows, how do i import them?