Skip to content

Making a list from ahrefs?

forthewinforthewin
in Need Help
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?

Comments

  • davbeldavbel UK
    Just import them into a project or use Options -> Advanced -> Tools -> Import URL.  SER will then then try and to identify anything it can post to.
  • forthewinforthewin
    yes but is .csv does gsa accept that?
  • donaldbeckdonaldbeck Advanced SER Videos -> http://bit.ly/1ySrbwu | Learn SER For Free Step By Step -> http://sertips.com
    Put the URLs in a text file.
  • forthewinforthewin
    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,

    like 

    2,54.000000,49.000000,217.21.184.230,http://site.com(the target),Blablabla? - Indialogue Blog,47,986,,https://www.therankingsite,,niche,,48644,Text,False,False,False,,2014-02-19,2014-02-19,2014-03-03,1015

    or is there a way to get only the link so I can tell my friend to get it that way?
    thanks and sorry for bothering
  • KaineKaine thebestindexer.com
    edited March 2014
    I can clean that for you.

    Send me a link in PM.


    EDIT:

    Quick after i go sleep ...
  • RayBanRayBan
    @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.
  • forthewinforthewin
    @Kaine thanks for the offer bro but I fixed it
    @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?
  • 2Take22Take2 UK
    edited March 2014
    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.
  • forthewinforthewin
    @2Take2

    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?
    What I mean is lets say this is https://forum.gsa-online.de/discussion/comment/65751/ but the forum domain is forum.gsa-online.de how can I remove the /discussion/comment/65751 part?

    hope you understand, thanks!
  • 2Take22Take2 UK
    edited March 2014
    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.
  • forthewinforthewin
    @2Take2 oh thanks so much, looks like gsa is a helluva thing :D thank you for the help
Sign In or Register to comment.