 So one of the things you may notice is that when you downloaded these files for this week. We have this chld D funds that htm and one of the things we can actually do inside of excel is we can import we can grab external data from The web the web. It's basically from a web page So how we can do that and this is where it gets a little wonky is we're actually going to Grab it from this file that we've downloaded. So how do I do this? Well if I come over to from web This is going to pull up a miniature browser inside of excel I could actually surf the internet from here if I wanted to as you can see I can log in and do everything I need to So all of a sudden I need to figure out. How do I? get to this guy Right here. Well, one of the things I need to do is I need to find the file path Wherever I downloaded this wherever I have this file on my computer is where I need to point This address bar to right here So the way I can do this quick and easy is I've downloaded this. I know it's on my desktop But what's the file path to my desktop? Up here on the windows Explorer. I can actually click on this white bar and That's going to give me my entire file path. Notice. It's see users a guita 036 desktop Tutorial 11. I Want to take this? I want to copy this information Because that information is what I want to then in turn Paste here now. I'm not done just yet because that just gives me the folder that the file is in again I Need to display that file. So what I can come in here and do is I can hit slash C H L D funds dot htm Let me just double check the file name on that funds htm and When I hit enter What do you know? That html file that htm file that I have is now Being shown through excel and then one of the luxuries is I can take this information and Because of how this html is built just to kind of take a look at that for a second on the back end side of things This is what the way the website looks like notice Everything in here has a nice old keyword called a table So suddenly this category it looks like this But all this stuff is being stored in a table just in this HTML style code So suddenly what I can do is I can come in here and Excel knows when it sees that Table code you can even see I can click and highlight What I want to bring in to now Excel as soon as I hit import Just where do I want it as soon as I hit okay notice all the information that was being brought in from that html is Now fully important