Just a short note found on the MS Excel team blog stating that the Microsoft research team has developed an add-in that enables users to browse the web via the add-in and select data to import to Excel, all while the add-in will adapt and learn from your selections.
The system extracts data by learning from a user’s selection of data they wish to capture into Excel. The more selections, the more the system is trained. An example scenario: You wish to import and track data from MSN’s weather page. Visit the site using the tool, enter Data Capture mode, and select a row or two of data from the table. Then click Select Similar, and the system will find similar data based on your previous selections.
The add-in is still in early beta so you test it on your own risk. I will get back to this add-in once I’ve had time to test it.