ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Convert HTML into an Excel (https://www.excelbanter.com/excel-worksheet-functions/18342-convert-html-into-excel.html)

skydiving99

Convert HTML into an Excel
 
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.

tpmax

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.



All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com