Every year CNBC publishes the top states in the US for business, quality of live, cost of living, education etc. While the data is already available at CNBC here, I thought of importing this data into an interactive Excel format.
Here is a brief description of how I did it.
Importing a HTML table into Excel:
The crudest way of this is to just copy-paste from a web-page into Excel. However my preference is to use the import data from Web Page option. This works like a charm. I did that for 2012, 2011 and 2010 data.
Next I formatted the table in Excel and saved the file as HTML so that I can add the Excel Interactive Button.
Go to www.excelmashup.com to generate the code and steps to add the script to the HTML file.
Here is the HTML table with the Excel Interactive Button:
Click on the button and you see Excel Interactive format:
Click on “Open in Excel Web App”
Since I live in Boise, Idaho state, I zoomed in on Idaho’s results which is very impressive for business seekers. Its ranked 7th overall for Cost of Business and 9th for Cost of Living. However it is at the bottom of the list for Education.
In summary, I really like the Excel’s Web Interactive Interface and also the Web App. Here, feel free to test drive it yourself.