Try doing either a query or a Web query (click DataImport External
DataImport Data or Web query).

"skydiving99" wrote:

I have a large dataset in HTML format, and I would like to convert it into
Excel so I could modify and delete unnecessary data. I tried to open the
HTML file in Excel, but it was too big so only part of it was imported into
Excel.

Does anyone know how to either: a) import the entire HTML file; or b)
selectively import the HTML into Excel since the file is too big?

Thank you very much.