Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
skydiving99
 
Posts: n/a
Default 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.
  #2   Report Post  
tpmax
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how i convert excel files with images to access mike Excel Discussion (Misc queries) 1 March 7th 05 05:51 PM
how i convert excel files with images to access mike Excel Discussion (Misc queries) 1 March 7th 05 03:11 AM
convert .123 format to Excel? Doug Rainville Excel Discussion (Misc queries) 5 January 28th 05 09:45 PM
Still Convert Lotus 123 to Excel 2003 becky Excel Discussion (Misc queries) 2 December 24th 04 02:14 AM
Is there a formula to convert numbers to written text in Excel? LZC Excel Worksheet Functions 3 November 27th 04 08:10 PM


All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"