 In my previous video, I have demonstrated how we can download the Toastmasters dashboard data directly in Excel. This method works when we have an option to download the CSV file from the Toastmasters website. However, there are several reports on the website, especially the daily reports. For example, if I was to select the education achievement, this report does not have an option to download the CSV file. How can we load this data directly in Excel? Let me show you how. The Excel load from web is a very smart function. If you give the URL of any page, it will try to convert everything that it finds on that page into data. Let me go back to my page. This time I will select the URL which is on top here. Press Ctrl C to copy it. First go to Excel, select data from web and paste that same URL in this box by using Ctrl V. When I click on the OK button, Excel will go and load that entire page and try to make sense of the data that exists on that page. Let's click OK. As you can see here, Excel tried to interpret everything that is on that page and found couple of things. It found a document, it found three tables. What I need to do is check each item to see if it contains the data that we need. Click on document. It doesn't have any data. Click on table zero. It has some headings. I'm not interested in this. Click on table one. Also, it has data that doesn't seem to be of any interest to me. Finally, let's check what's there in table two. And voila, that is the data that I'm interested in. That's the table containing the education awards that were available on that page. Click on the transform data button. Excel will load everything it could find in table two. Scroll down to see if there are any unnecessary rows. This table has no unnecessary rows. All I have to do now is click on close and load. After a couple of seconds, the entire data set is loaded now in Excel. The beauty of this method is that anytime I want to refresh the data, I don't have to go to the Toastmasters website. I can simply click refresh and click on the refresh button. And the data will be automatically refreshed. You can go one step further by ensuring that anytime you open this file, the data will be refreshed automatically. If you want to do that, click on data, click on this arrow, refresh all and select connection properties. In the option refresh data when opening the file, enable it and click OK. Anytime you open this Excel file, Excel will automatically go to the Toastmasters website, get the latest data and refresh it in Excel. If you were to do any kind of analysis on this data, for example, a pivot table, we can do that by clicking on insert pivot table. Excel will automatically select the entire data set, click OK, create your pivot. Let's say I want to know the number of awards by division. I can simply select division in the row column, select award in the value column and it will give me immediately by division the number of awards. If I want to convert this into a nice graph, very simple, click anywhere within the table, click insert, select the type of graph you want and you have your division wise graph for the awards. Anytime you open this Excel file, it will reflect the current status of awards in your district. Isn't that cool? You can apply this technique to any unencrypted page on the web. All you have to do is give the URL that appears on the top of the page, go into Excel and plug that in and identify which table contains the data that you are interested in and tell Excel to load that data. That's all there is to it. I hope you found this video useful to extract any data available on the web directly into Excel. Have fun playing with the data.