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

[blackhatgorilla]

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

 

[nata0292]

ask @Shaunm

 

[blackhatgorilla]

ask @Shaunm

thanks for tagging, i found a extract website (convertcsv...) but the site get always a time out and can't handle the request

 

[Shaunm]

I don't think there is a way. The URLs can all be different depending on the CMS and the version of the CMS.

 

[satyr85]

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'

 

[blackhatgorilla]

thank you guys, worked fine, everything done <3