1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How can i extract tables to edit

Discussion in 'Black Hat SEO Tools' started by chucklechuck, Jan 28, 2009.

  1. chucklechuck

    chucklechuck Registered Member

    Joined:
    Dec 2, 2008
    Messages:
    93
    Likes Received:
    52
    I want to be able to copy the contents of tables on web pages into something like excel so i can easily edit.

    e.g.
    HTML:
    http://rankings.big-boards.com
    I want to be able to get the tables in the same format but i always end up with the columns mixed up and the images all over the page.

    Anybody have any good tips for this? Tried web developer add on for FF but screwed up my browser for a while.

    Thanks in advance
     
  2. lilo5

    lilo5 Newbie

    Joined:
    Jan 10, 2009
    Messages:
    26
    Likes Received:
    2
    Location:
    Poland
    You try save page and open in excell.
     
  3. oscarslater

    oscarslater Regular Member

    Joined:
    Mar 13, 2008
    Messages:
    401
    Likes Received:
    152
    internet macros will work for this

    i'm not that good with it but it will extract a table as it is on the page and extract it to workable programs (excel, text, csv)

    hope that helps and I did see it here or you can get a free firefox plugin

    os
     
  4. xsubodh

    xsubodh Junior Member

    Joined:
    Nov 25, 2008
    Messages:
    137
    Likes Received:
    43
    Location:
    Mars
    Hi,
    Open up excel, go to Data>import external data>New web Query and enter your url, hit ok> import. Thats it you are done. However you will have to do the same thing again and again everytime you are working with a new webpage url, in a new workbook. I hope it helps
     
    • Thanks Thanks x 1