EXCEL, HTML TO EXCEL |
EXCEL, HTML TO EXCEL |
Prizma22 |
May 22 2012, 10:46 PM
Post
#1
|
Group: Members Posts: 1 Joined: 22-May 12 Member No.: 17,151 |
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..
|
jimlongo |
May 30 2012, 12:59 PM
Post
#2
|
This is My Life Group: Members Posts: 1,128 Joined: 24-August 06 From: t-dot Member No.: 16 |
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. This post has been edited by jimlongo: May 30 2012, 01:02 PM |
Lo-Fi Version | Time is now: 24th April 2024 - 06:03 AM |