Formatting Data from a Web page into clearly defined columns..PLS HELP!!
Posted by Charles E. Hines on December 01, 2000 9:48 PM
Is there a way to cut and paste a page, say of statistics, into an Excel spreadsheet so that it will give each stat its own column, so you can manipulate the data? I have tried saving it as a text file. You must make your column breaks all @ the same place in the document, which divides some #s you dont want to divide up. When you try to save it just as an excel file, it puts all of the data into one cell. Or is there a way to import the internet page into excel? Thanks for your help!!
Posted by Baki on December 02, 2000 8:01 AM
Ok, here is a simple way of doing it: Copy and paste the data to a text editor like "Notepad". Save it as a text file, then use MS-excel to open it (you need to select "All files" for the "Files of type" under the open window to see it). Under the text open wizard, select either Delimited or fixed width depending upon your data and follow the instructions.
Good luck
Posted by And Ashman on December 04, 2000 4:50 AM
You could try this way which does not involve cutting and pasting. Save the web page as a text file in your BROWSER then import the file into Excel. In IE5 click "file" the "save as" - I'm not sure about other browsers. It works for some pages I've been looking at.
I think there might be very simple ways to do this sort of thing by parsing the HTML directly in InterDev (?) or some other package, unfortunately I know nothing about that stuff.
(I was actually reading this board for an answer to a related question, how to automate this process using VBA)
