So I would like to know if its possible to create a gsa list from ahrefs? Like I already have the report .csv of backlinks from some sites and I would like to use those same ones on gsa, how can I sort them or something to work properly?
Yes, thank you for the answer , but my friend who gives me the ahrefs reports had everything Index,Ahrefs Rank,Domain Rank,IP from,Refering Page URL,Refering Page Title,Internal Links Count,External Links Count,Last HTTP Code,Link URL,TextPre,Link Anchor,TextPost,Size,Type,NoFollow,Image,Site-wide,Alt,First Seen,Previous Visited,Last Check,Ordinal and that is like in one line in ahrefs and it's not just the website all this are separated with a comma on one line,
@forthewin - it seems you use openoffice to view the file, i did the same. To view the report you will need ms excel, ron's editor (30 days free) or another software.
@RayBan thanks man using ron's editor fixed it, one more question, for example because these are obviously the links pointing to the article or whatever is it like blabla.com/blabla-349(if for example thats the article number or something) does this matter? for example do I need to remove the 349 and how do I do that?
The easiest way is to just use the 'text to columns' function in excel (found in the 'Data' tab). Use the "," as a delimiter, then just copy the column with the urls into a new workbook/notepad and do what you want with them.
yes, thank you I did fix that, one more question, for example because these are obviously the links pointing to the article or whatever it's like blabla.com/blabla-349(if for example thats the article number or something) does this matter? for example do I need to remove the 349 and how do I do that?
If you wanted to you could import them into scrapebox and use the 'trim to root' function, but you don't really need to remove anything, just import it into SER as it is.
Comments
thanks and sorry for bothering