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

backlinks in excel

Discussion in 'Black Hat SEO' started by Bartman, Aug 21, 2010.

  1. Bartman

    Bartman Power Member

    Joined:
    Apr 24, 2010
    Messages:
    569
    Likes Received:
    131
    hello
    I want to have all the backlinks that a website has in excel format.
    How do i do this?
    backlinkwatch.com does not export to excel
     
  2. beazt

    beazt Power Member

    Joined:
    Oct 29, 2009
    Messages:
    765
    Likes Received:
    1,245
    Occupation:
    IM
    Location:
    BHW
    Home Page:
    Not sure about Excel but if you use yahoo! site explorer to check backlinks, then there is an option at the top right corner to extract first 1000 results in Text file.
     
  3. Bartman

    Bartman Power Member

    Joined:
    Apr 24, 2010
    Messages:
    569
    Likes Received:
    131
    with yahoo site explorer, dont you have to prove that you own the domain by uploading a file?
     
  4. origin

    origin Regular Member

    Joined:
    Nov 11, 2008
    Messages:
    334
    Likes Received:
    90
    Home Page:
    The easiest way, IMO, is by scrapping those backlinks pages, then it can be exported to excel file or other file format.
     
  5. rprabu

    rprabu Power Member

    Joined:
    Feb 11, 2009
    Messages:
    580
    Likes Received:
    261
    Location:
    Home :-)
    I think seo spyclass can do that.. paid version
     
  6. Nuz25

    Nuz25 Junior Member

    Joined:
    Aug 20, 2010
    Messages:
    129
    Likes Received:
    100
    Occupation:
    I'm a student
    Here's a simple solution for you.

    Download SEOquake

    Personally what I do is I go to preferences and I turn everything off except the page rank.

    Than I populate the search and I export to an excel file.

    The exported file is opened by excel but under text format, so usually I save it as "temp.csv" file.

    Then I create another excel file, I go to data - from text.

    Click next, uncheck the tab box and check the semicolon box.

    Next, finish,ok.

    And you have a nice sheet with all the backlinks and their page rank in excel.

    It may sound a bit complicated but when you do it once you'll see it's very simple. And you can compile all your files like that.

    Hope it helps!