Import HTML tables to multiple Excel Worksheets

Question

When I import an HTML document into Excel, if there is more than one table in the HTML document Excel puts the tables on the same worksheet one after the other. Is there a way to tell Excel to put each table on its own worksheet?

Answer 1

Unless you're using the Excel XML/HTML format (circa Office 2000, but deprecated in 2010, I believe), you won't be able to do this.

If you are using plain old HTML tables (circa Office 97 "Excel HTML Extensions" era), all versions of Excel from 97 onwards will import these fine but strictly to one worksheet.