• 0

web page to excel


Question

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

  • 0

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

  • 0

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

  • 0

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

  • 0

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

  • 0

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

  • 0

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.