Because of the working relationship, I often need to put some tables on the Web page into Excel to save, used to directly use the method of copying, but sometimes the table pasted into Excel is not too ideal, after the need to manually modify, it is troublesome, there is no better way? Of course, let the HTML Table Extractor This IE plug-in tool to help bar!
Open http://www.download.com/HTML-Table-Extractor/3000-2378_4-10462296.html This site in IE, click "Download Now" to download, after downloading , all the way "Next" can be installed.
Step 1: Restart IE, the toolbar will have an extra "HTML table Extractor" icon, when you need to import the table in the Web page, first click the icon.
Step 2: A small dialog box pops up at the bottom of the window, click on the "Search table" button, and then move the mouse pointer over the table, the table will be red, which means that it is selected, and then click the right mouse button, and then in the shortcut menu appears in turn, select "Export to Excel→create New Table command.
Step 3: This way, the table in the Web page will be imported directly into Excel, and finally save it.