Sign in to follow this  

web page to excel

Recommended Posts

Deep_Level_Shark    4

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
Haggis    981

copy and paste it

Share this post


Link to post
Share on other sites
Innuendo    21

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
Deep_Level_Shark    4

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 ?

Share this post


Link to post
Share on other sites
Haggis    981

can you provide a link to the page?

Share this post


Link to post
Share on other sites
Deep_Level_Shark    4

can you provide a link to the page?

This is password protected.

Share this post


Link to post
Share on other sites
Haggis    981

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
68k    290

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

Share this post


Link to post
Share on other sites
Deep_Level_Shark    4

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
Kami-    178

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?

Share this post


Link to post
Share on other sites
episode    560

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

No.

Share this post


Link to post
Share on other sites
Innuendo    21

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  

  • Recently Browsing   0 members

    No registered users viewing this page.