How to Import Data from the Web in Excel - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Euxhenio
Hi Kevin, I got a question/suggestion. This kind of import takes the bare table (what you see/read is what you get) but what happens if to an element of the table is associated a link. Let's say that -Oreo Classic- is also a link pointing to the page of the producer. Once you import the table in Excel only Oreo Classic is going to be imported but the link is going lost. Is there any way to import the links too? I googled that but not easy to find (confused with a VBA module on how to extrat links when already copied in a cell). Regards and Thanks
reply
Hi Kevin, I got a question/suggestion. This kind of import takes the bare table (what you see/read is what you get) but what happens if to an element of the table is associated a link. Let's say that -Oreo Classic- is also a link pointing to the page of the producer. Once you import the table in Excel only Oreo Classic is going to be imported but the link is going lost. Is there any way to import the links too? I googled that but not easy to find (confused with a VBA module on how to extrat links when already copied in a cell). Regards and Thanks
reply
Jason
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?
reply
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?
reply
Lonnie
Kevin, unrelated to this video but, have you thought of doing or have any videos demonstrating voice commands for Windows 10 and Office. I think this is one of those features that gets overlooked a lot. I need something to provide to our HR department. Hopefully it will help with a potential hiring of a disabled individual. Your thoughts?
reply
Kevin, unrelated to this video but, have you thought of doing or have any videos demonstrating voice commands for Windows 10 and Office. I think this is one of those features that gets overlooked a lot. I need something to provide to our HR department. Hopefully it will help with a potential hiring of a disabled individual. Your thoughts?
reply
Rax
Would this work for Web data that requires a login to access? I'm thinking specifically about extracting Twitter analytics data into a spreadsheet. I need to be an adnin of the Twitter account to access the data, but if I'm logged in, would it be possible to extract into Excel?
reply
Would this work for Web data that requires a login to access? I'm thinking specifically about extracting Twitter analytics data into a spreadsheet. I need to be an adnin of the Twitter account to access the data, but if I'm logged in, would it be possible to extract into Excel?
reply
Kennard
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?
reply
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?
reply
Actcad
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.
reply
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.
reply
Aman
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 -
reply
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 -
reply
Jason
Being the boss of a 3-billion dollar company is not enough to keep Kevin too busy to make YouTube videos. Thank you for taking the time for the little guys.
reply
Being the boss of a 3-billion dollar company is not enough to keep Kevin too busy to make YouTube videos. Thank you for taking the time for the little guys.
reply
musicisfunpart
Seems like this is only for PC not Mac. I didn-t see this function on Mac. On Mac, I only see get data from HTML, text, or data base.
reply
Seems like this is only for PC not Mac. I didn-t see this function on Mac. On Mac, I only see get data from HTML, text, or data base.
reply
Rahul
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?
reply
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?
reply
Add a review, comment
Other channel videos
8:18
