Free Way to Sort and Get PageRank for a list of URLs

[Joshua]

If you don't have scrapebox to grab the domain for you then you can always use a simple excel formula.  Just copy your links into excel and use this formula...

=MID(A2,FIND("//",A2,1)+2,FIND("/",A2,FIND("//",A2,1)+8)-(FIND("//",A2,1)+2))

In this example the full URL that I was extracting the domain from was in cell A2. It is very easy to get a list with just the domain names this way.  I sometimes use this so I can go back and use my PR checker program to get the page ranks for the domains rather than the actual pages since obviously most of the actual signup pages will be n/a or 0.  The PR checker program I use is free and you can get it at http://www.cleverstat.com/en/page-rank-software.htm .... Just another alternative to Scrapebox....

[quadjack]

If you don't have scrapebox to grab the domain for you then you can always use a simple excel formula.  Just copy your links into excel and use this formula...

=MID(A2,FIND("//",A2,1)+2,FIND("/",A2,FIND("//",A2,1)+8)-(FIND("//",A2,1)+2))

In this example the full URL that I was extracting the domain from was in cell A2. It is very easy to get a list with just the domain names this way.  I sometimes use this so I can go back and use my PR checker program to get the page ranks for the domains rather than the actual pages since obviously most of the actual signup pages will be n/a or 0.  The PR checker program I use is free and you can get it at http://www.cleverstat.com/en/page-rank-software.htm .... Just another alternative to Scrapebox....

So where do i paster my urls and where do i paste the above formula? Sorry for the noob question, but you did drop a bomb with no other insight... Thanks in advance!

[Joshua]

All of the info you needed was in my previous post.  Though I could have been a bit more specific I guess.

Just paste all the URL's you want to process into an excel spreadsheet in column A.  Then use the mentioned formula in column B.  In this example I had a header so the first cell with a URL in it was A2.  I put the formula in B2 and then used the auto fill to paste the formula down the rest of the column and process all of the URL's in my list.  The formula just takes the URL and extracts the domain.

Then you can plug your list of domains into the PaRameter software mentioned if you want to get the domain PR of each one.  You should be able to export the data from that program in the same order you entered it and then just paste the PR of the pages into column C of your original Excel sheet.  Then you can sort the URLs as needed.

[social joe]

Hey Joshua,

tried implementing your code but getting repeated error messages.

Could you upload a copy of your spreadsheet?

Thanks

[derhul]

hi guys...

This is just my opinion...Bust Scrapebox is a MUST HAVE!!! it's worth the $57..trust me..(No I'm not an affiliate)

let me just put it this way...

I just got through scraping a list of 207 expression-engine blogs (3-10 PR) that I will use with ABB. It took me a little over 1 min.

Worth the money!!

[qwerty]

If you don't have scrapebox to grab the domain for you then you can always use a simple excel formula.  Just copy your links into excel and use this formula...

=MID(A2,FIND("//",A2,1)+2,FIND("/",A2,FIND("//",A2,1)+8)-(FIND("//",A2,1)+2))

In this example the full URL that I was extracting the domain from was in cell A2. It is very easy to get a list with just the domain names this way.  I sometimes use this so I can go back and use my PR checker program to get the page ranks for the domains rather than the actual pages since obviously most of the actual signup pages will be n/a or 0.  The PR checker program I use is free and you can get it at http://www.cleverstat.com/en/page-rank-software.htm .... Just another alternative to Scrapebox....

Hi Joshua

Nice bit of coding you have there, thanks for that. Please can you post the code again but also leaving in the 'http://' part at the front. I have tried to play around with the code with no success.

Thanks

[junkyour925]

simple, just add it back 

="http://" & MID(A2,FIND("//",A2,1)+2,FIND("/",A2,FIND("//",A2,1)+8)-(FIND("//",A2,1)+2))

[junkyour925]

btw, here is another way to use Excel to "trim to root" (this version will preserve the http://)

=LEFT(C54,SEARCH("/",C54,8))

where cell C54 contains your url to trim to root.  For example

http://www.articlesbase.com/tools-and-equipment-articles/tip-and-tricks-for-traing-your-dog.html

will become

http://www.articlesbase.com/

only gotcha for it to work is that there must be at least one forward slash "/" after the http:// and http:// must be in the original url to trim

[CSWA]

Joshua, thank you for the page rank checker link. It always amazes me about the sites that someone knows, uses, and recommends, and yet I've never heard of them. That's the bonus with reading these posts. Again, thanks!

Candace

[theshed]

been using this code but it is deleting the end /
do i need to have the last / for things to work correctly?

thanks

[SternRichard]

If you want to know the page rank of your site then you may go for "Mikesearchengine" and it is free also.