Jump to content
Sign in to follow this  
Followers 0

web page to excel

12 posts in this topic

Posted

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

Share this post


Link to post
Share on other sites

Posted

copy and paste it

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

[quote name='Innuendo' timestamp='1364906219' post='595612102']
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.
[/quote]

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 [i]paste special[/i] you want to do ( there are many choices under[i] pasate special[/i] ) ?


Alternatively , Is there any FREE software which can copy the text data columnwise from web page table and can be pasted into excel ?

Share this post


Link to post
Share on other sites

Posted

can you provide a link to the page?

Share this post


Link to post
Share on other sites

Posted

[quote name='Haggis' timestamp='1364907241' post='595612122']
can you provide a link to the page?
[/quote]

This is password protected.

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Posted

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: [url="http://en.wikipedia.org/wiki/Comma-separated_values"]http://en.wikipedia....eparated_values[/url]

"Paste Special" shortcut is Ctrl + Alt + V

Share this post


Link to post
Share on other sites

Posted

even through I do paste special as text .....I get lot of patches , broders etc ......Is there any way I can clean data ?

Share this post


Link to post
Share on other sites

Posted

[quote name='Deep_Level_Shark' timestamp='1364909347' post='595612176']
even through I do paste special as text .....I get lot of patches , broders etc ......Is there any way I can clean data ?
[/quote]
Does the website have a data API you can query?

Share this post


Link to post
Share on other sites

Posted

[quote name='Deep_Level_Shark' timestamp='1364909347' post='595612176']
even through I do paste special as text .....I get lot of patches , broders etc ......Is there any way I can clean data ?
[/quote]

No.

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.