table to spreadsheet

Discussion in 'Content Management' started by uca, Mar 16, 2006.

0
  1. #1
    If I find a table of data on a website, and I want to work on it, do calculations and stuff, and to do that I want to import it to a spreadsheet, is there an easy way? I'm sure someone can help!

    Thanks in advance!

    :)
     
    uca, Mar 16, 2006 IP
  2. chengfu

    chengfu Well-Known Member

    Messages:
    113
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    108
    #2
    At least with openoffice it often works to simply select the html table in the browser and cut-and-paste it into an empty spreadsheet.
     
    chengfu, Mar 16, 2006 IP
  3. MatthewN

    MatthewN Well-Known Member

    Messages:
    859
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    195
    #3
    Just copy and paste it. You might need to clear some junk that comes over with it also.
     
    MatthewN, Mar 16, 2006 IP
  4. uca

    uca Well-Known Member

    Messages:
    2,242
    Likes Received:
    69
    Best Answers:
    0
    Trophy Points:
    155
    #4
    I'll try with Excel, so far with 602 I could only get all the data in one cell.

    Unless there's a way around this, I'll try later on another pc that has Excel.

    Thanks!

    :)
     
    uca, Mar 16, 2006 IP