The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

> EXCEL, HTML TO EXCEL
Prizma22
post 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..
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
 
Reply to this topicStart new topic
Replies
jimlongo
post 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
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Posts in this topic


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 19th April 2024 - 03:32 PM