Printable Version of Topic

Click here to view this topic in its original format

HTMLHelp Forums _ Databases _ EXCEL

Posted by: Prizma22 May 22 2012, 10:46 PM

Hey, I am trying to do something I use to know how to do but I cannot figure it out.. I am trying to take data that is in a table format off of a website and create a spreadsheet. I did not create this website.. If I could just copy the source code and put it into the spreadsheet that would be great. but the code copy and paste it doesn't work. How do I do this? if you need the website I can give that to you.. Thank you..

Posted by: jimlongo May 30 2012, 12:59 PM

do a(n) sql dump, clean up and convert it to a file.csv and try importing it into excel.

Sorry misread your question . . . maybe export the source, do a find and replace <td>s for commas, save as a csv file and import into excel.

Posted by: fleewe Jul 26 2012, 07:17 AM

yes you can do it ..first you have to copy the code on simple notepad and after that you can paste it on spreadsheet.I hope it will work.

Posted by: sarker Jul 31 2012, 11:59 PM

I might merely make a copy the source code and set it into the table with the purpose of would be terrific. But the code make a copy and paste it doesn't piece. How figure out I figure out this

Posted by: jimlongo Feb 12 2013, 11:21 PM

- get source code.
- find and replace <td>s with commas, <tr>s with line returns
- save as file.csv
- open in excel

or something like that.

Posted by: jonasmarsh621 Feb 18 2013, 04:26 AM

This has been here awhile now. Never knew about this since I never did use excel. Nice piece of info right here.

Powered by Invision Power Board (
© Invision Power Services (