 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / August 2007html import-web query 101?
Mac ibook g4, osx.3.9, 0ffice 2004, multiple browsers. have need to import an html table into excel to finish a thesis project. the data includes free text fields with imbeded commas, which are screwing up the import. copy/paste, the the on-line helps have been of no use. how do i create/modify a web query to import data from an html page already saved to my hard drive? > Mac ibook g4, osx.3.9, 0ffice 2004, multiple browsers. > have need to import an html table into excel to finish a thesis > project. the data includes free text fields with imbeded commas, which > are screwing up the import. copy/paste, the the on-line helps have > been of no use. how do i create/modify a web query to import data > from an html page already saved to my hard drive? What works for me: If you don't have the freeware TextWrangler application, download it from Versiontracker. Display the HTML page and select the desired table. Select "Services" from the browser's application name menu and choose "TextWrangler->New Window with Selection". TW will open a new window containing the selected table data with tab characters between the columns. Multi-line cell contents are troublesome, but they can usually be cleaned up. Edit the window's contents to suite and then copy and paste into Excel.  SignatureTom Stiller PGP fingerprint = 5108 DDB2 9761 EDE5 E7E3 7BDA 71ED 6496 99C0 C7CF On 8/18/07 10:07 AM, in article 1187446069.265404.161770@r34g2000hsd.googlegroups.com, > Mac ibook g4, osx.3.9, 0ffice 2004, multiple browsers. > have need to import an html table into excel to finish a thesis > project. the data includes free text fields with imbeded commas, which > are screwing up the import. copy/paste, the the on-line helps have > been of no use. how do i create/modify a web query to import data > from an html page already saved to my hard drive? What do you mean by 'screwing up" the import. Have you tried the text to columns function after the data was in Excel? SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.