1. This website uses cookies to improve service and provide a tailored user experience. By using this site, you agree to this use. See our Cookie Policy.
    Dismiss Notice

GSA: How to exclude/filter links from CSV-Report

Discussion in 'Black Hat SEO Tools' started by blackhatgorilla, Feb 2, 2018.

  1. blackhatgorilla

    blackhatgorilla Regular Member

    Joined:
    Nov 13, 2017
    Messages:
    207
    Likes Received:
    75
    Hi,
    does anybody know or has an idea how to exclude only the links (about 20k gsa backlinks) from a csv report in excel?

    The links inside the file look like this:

    2017-12-18 01:31,"http://000babes.com/external_link/?url=http:/DOMAIN","Whois or Statistics","Indexer","X","X","44","5","79th 25k one time","DOMAIN","2017-12-18 01:31","0","","",""

    So I would only export the url http://000babes.com/external_link/?url=http:/DOMAIN to generate a Disavow File for Google.. (BTW: does Google need the full link or only the Domain?)

    Any Macro-Command, plugin or filter-option?
    I hope you guys have any idea :( thank you

    my site dropped hard (from pos. 12 to 79) since december - i bought links only for tier 2 - 3 subpages
     
  2. nata0292

    nata0292 Power Member

    Joined:
    Jun 24, 2017
    Messages:
    517
    Likes Received:
    121
    Gender:
    Male
    Occupation:
    ----> POWER RANGER!
    • Thanks Thanks x 2
  3. blackhatgorilla

    blackhatgorilla Regular Member

    Joined:
    Nov 13, 2017
    Messages:
    207
    Likes Received:
    75
    thanks for tagging, i found a extract website (convertcsv...) but the site get always a time out and can't handle the request
     
  4. Shaunm

    Shaunm Elite Member

    Joined:
    Mar 27, 2014
    Messages:
    2,293
    Likes Received:
    1,154
    I don't think there is a way. The URLs can all be different depending on the CMS and the version of the CMS.
     
    • Thanks Thanks x 1
  5. satyr85

    satyr85 Jr. VIP Jr. VIP

    Joined:
    Aug 7, 2011
    Messages:
    751
    Likes Received:
    566
    Location:
    Poland
    Easy as 2+2, feel free to PM me your skype, will get this done for you.

    Edit:
    Easiest way is to open this file in excel, select column with links, and copy this column to notepad++ file. You just need to add " in 'Separate by'
     
    • Thanks Thanks x 1
    Last edited: Feb 2, 2018
  6. blackhatgorilla

    blackhatgorilla Regular Member

    Joined:
    Nov 13, 2017
    Messages:
    207
    Likes Received:
    75
    thank you guys, worked fine, everything done :D <3