Linking Moz with Excel to compare links enmass

[Sam.at.Moz]

Hi all,

I'm looking for a solution which will allow me to sort a list of links by pagerank.

There seems to be a couple of solutions online but neither work for me due to various updates since they were created.

Can anyone give me a solution which will work today - Perhaps using Google Sheets/Excel?

I have a Moz Pro subscription.

Thanks,

Sam

[Sam.at.Moz]

Will this only work on a link by link basis?

To confirm I have a list of 300 links I've scraped from Google into Excel, how can I display the PA for all of these sites within Excel?

[jameskais]

Exporting a search from Open Site Explorer by hitting "Request CSV" will do the trick!

[Sam.at.Moz]

Thanks James,

That's great. What's the best way to bring in my PA into Excel?

[jameskais]

Hello there - is there a specific type of sort you are trying to perform? If not just by using the default Filter Icon in Excel/ Google Sheets will be fine:

http://screencast.com/t/BLnkZPUkrD3c

Hitting the sort button will allow you to manipulate the order which you see the PA displayed. In excel if you need to run a double sort simply hit Data -> Sort and enter the details in the dialog.