The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> 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
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
fleewe
post Jul 26 2012, 07:17 AM
Post #3





Group: Members
Posts: 2
Joined: 26-July 12
Member No.: 17,497



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.

This post has been edited by fleewe: Jul 26 2012, 07:18 AM
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
sarker
post Jul 31 2012, 11:59 PM
Post #4





Group: Members
Posts: 1
Joined: 31-July 12
Member No.: 17,528



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
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
jimlongo
post Feb 12 2013, 11:21 PM
Post #5


This is My Life
*******

Group: Members
Posts: 1,128
Joined: 24-August 06
From: t-dot
Member No.: 16



- 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.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
jonasmarsh621
post Feb 18 2013, 04:26 AM
Post #6


Member
***

Group: Members
Posts: 38
Joined: 5-October 12
From: New York City, NY
Member No.: 17,901



This has been here awhile now. Never knew about this since I never did use excel. Nice piece of info right here.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

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: 28th March 2024 - 11:53 AM