Jump to content



Photo

web page to excel


  • Please log in to reply
11 replies to this topic

#1 Deep_Level_Shark

Deep_Level_Shark

    Neowinian

  • Joined: 02-December 05

Posted 02 April 2013 - 12:20

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


#2 Haggis

Haggis

    Neowinian Senior

  • Tech Issues Solved: 14
  • Joined: 13-June 07
  • Location: Near Stirling, Scotland
  • OS: Debian 7
  • Phone: Samsung Galaxy S3 LTE (i9305)

Posted 02 April 2013 - 12:35

copy and paste it

#3 Innuendo

Innuendo

    Neowinian

  • Tech Issues Solved: 1
  • Joined: 01-June 02

Posted 02 April 2013 - 12:36

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.

#4 OP Deep_Level_Shark

Deep_Level_Shark

    Neowinian

  • Joined: 02-December 05

Posted 02 April 2013 - 12:44

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 ?

#5 Haggis

Haggis

    Neowinian Senior

  • Tech Issues Solved: 14
  • Joined: 13-June 07
  • Location: Near Stirling, Scotland
  • OS: Debian 7
  • Phone: Samsung Galaxy S3 LTE (i9305)

Posted 02 April 2013 - 12:54

can you provide a link to the page?

#6 OP Deep_Level_Shark

Deep_Level_Shark

    Neowinian

  • Joined: 02-December 05

Posted 02 April 2013 - 12:56

can you provide a link to the page?


This is password protected.

#7 Haggis

Haggis

    Neowinian Senior

  • Tech Issues Solved: 14
  • Joined: 13-June 07
  • Location: Near Stirling, Scotland
  • OS: Debian 7
  • Phone: Samsung Galaxy S3 LTE (i9305)

Posted 02 April 2013 - 12:58

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

#8 68k

68k

    Neowinian Senior

  • Tech Issues Solved: 4
  • Joined: 20-January 10
  • Location: Australia

Posted 02 April 2013 - 13:05

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

#9 OP Deep_Level_Shark

Deep_Level_Shark

    Neowinian

  • Joined: 02-December 05

Posted 02 April 2013 - 13:29

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

#10 Kami-

Kami-

    ♫ d(-_-)b ♫

  • Tech Issues Solved: 3
  • Joined: 28-July 08
  • Location: SandBox

Posted 02 April 2013 - 14:59

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?

#11 episode

episode

    Neowinian Fanatic

  • Tech Issues Solved: 3
  • Joined: 11-December 01

Posted 02 April 2013 - 15:02

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


No.

#12 Innuendo

Innuendo

    Neowinian

  • Tech Issues Solved: 1
  • Joined: 01-June 02

Posted 02 April 2013 - 17:07

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.