Convert HTML into an Excel

[Guest]

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.

 

[Guest]

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