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 |
fleewe |
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 |
sarker |
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
|
jimlongo |
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. |
jonasmarsh621 |
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.
|
Lo-Fi Version | Time is now: 26th April 2024 - 07:48 PM |