Deep_Level_Shark Posted April 2, 2013 Share Posted April 2, 2013 how do I copy a tabular column data in a web page into an excel sheet ? I want to do this because I want to do a auto sum of column values of the table in excel. Is there any work around ? I'm using Office 2007 Link to comment Share on other sites More sharing options...
0 Haggis Veteran Posted April 2, 2013 Veteran Share Posted April 2, 2013 copy and paste it Link to comment Share on other sites More sharing options...
0 Innuendo Posted April 2, 2013 Share Posted April 2, 2013 Been a while since I used Office 2007 so I don't know if it is the same, but with Office 2010 it's just a simple matter of copying the table to the clipboard and using the "Paste Special..." command in Excel to get the data into your spreadsheet. Link to comment Share on other sites More sharing options...
0 Deep_Level_Shark Posted April 2, 2013 Author Share Posted April 2, 2013 Been a while since I used Office 2007 so I don't know if it is the same, but with Office 2010 it's just a simple matter of copying the table to the clipboard and using the "Paste Special..." command in Excel to get the data into your spreadsheet. I did a copy & paste indeed.....but this fetches lot of patches into excel. I am not getting clean data.......... without clean data I may not be able to do a columnwise auto sum. by the way , which paste special you want to do ( there are many choices under pasate special ) ? Alternatively , Is there any FREE software which can copy the text data columnwise from web page table and can be pasted into excel ? Link to comment Share on other sites More sharing options...
0 Haggis Veteran Posted April 2, 2013 Veteran Share Posted April 2, 2013 can you provide a link to the page? Link to comment Share on other sites More sharing options...
0 Deep_Level_Shark Posted April 2, 2013 Author Share Posted April 2, 2013 can you provide a link to the page? This is password protected. Link to comment Share on other sites More sharing options...
0 Haggis Veteran Posted April 2, 2013 Veteran Share Posted April 2, 2013 post a screenshot of it? its hard to tell you the best way to do something when we cant see what your trying to do Link to comment Share on other sites More sharing options...
0 (Account no longer active) Posted April 2, 2013 Share Posted April 2, 2013 Try pasting as "plain text" first. If that doesn't work, put the data into Notepad (NOT Word or anything else - only Notepad), and separate values with commas. Save text file as .csv, and then open it in Excel. See example here first in regards to CSV formatting: http://en.wikipedia....eparated_values "Paste Special" shortcut is Ctrl + Alt + V Link to comment Share on other sites More sharing options...
0 Deep_Level_Shark Posted April 2, 2013 Author Share Posted April 2, 2013 even through I do paste special as text .....I get lot of patches , broders etc ......Is there any way I can clean data ? Link to comment Share on other sites More sharing options...
0 Kami- Posted April 2, 2013 Share Posted April 2, 2013 even through I do paste special as text .....I get lot of patches , broders etc ......Is there any way I can clean data ? Does the website have a data API you can query? Link to comment Share on other sites More sharing options...
0 episode Posted April 2, 2013 Share Posted April 2, 2013 even through I do paste special as text .....I get lot of patches , broders etc ......Is there any way I can clean data ? No. Link to comment Share on other sites More sharing options...
0 Innuendo Posted April 2, 2013 Share Posted April 2, 2013 I think you will either have to follow 68k's suggestion to create a CSV file or type the data by hand. If the web page is password protected it wouldn't surprise me if the page is coded in a way to specifically stop people from copying/pasting the data easily. Link to comment Share on other sites More sharing options...
Question
Deep_Level_Shark
how do I copy a tabular column data in a web page into an excel sheet ?
I want to do this because I want to do a auto sum of column values of the table in excel.
Is there any work around ?
I'm using Office 2007
Link to comment
Share on other sites
11 answers to this question
Recommended Posts