Linking Moz with Excel to compare links enmass
-
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
-
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?
-
Exporting a search from Open Site Explorer by hitting "Request CSV" will do the trick!
-
Thanks James,
That's great. What's the best way to bring in my PA into Excel?
-
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.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Unsolved Can I get Moz keywords via API?
Hi, my boss is asking if you "have any API for keyword research -- e.g., as soon as a user creates a card title in [our application], we can auto-recommend keywords from Moz within [the application]. I shared a link with him to your Links API page, but he says he doesn't think that API does the above. Can you help? Thank you, Renae
API | | CarolinaRen0 -
Moz not working properly
I'm using MOZ BAR extension . It's not working properly on this https://brokescholar.com Can anyone tell me that is it/not showing da...
API | | sathoiue80 -
Why Moz Giving Error, Permission Denied in Excel Sheets
I am Using Moz Pro just Installed Moz Addon in Google excel Sheets integrated properly with keys. But when I put Links for Bulk DA PA and Hit the Get Data within few seconds it says Error! Permission denied. Even My URLS are below 200 Links always giving this error. Any other way to use Moz API for Bulk DA PA Checking
API | | Umair1233213 -
Is the chat with Expertise option available in MOZ?
I dont find a chat option in the MOZ site. Is it available so i could chat with some expertise on MOZ API integration
API | | Dotcomcontent0 -
Moz api request problem fail (status 401)
Hello! I'm getting an error for seomoz call using API: {"status":"401","error_message":"Your authentication failed. Check your authentication details and try again. For more information on signed authentication, see: http://apiwiki.moz.com/signed-authentication"} Can you help me?
API | | leoh0 -
Use of Moz with non-latin characters
Hey there, I am new member with Moz and i have to say that you are doing very good job. Three days ago, i have learnt that the On-page Grader and On-Page Optimization tools are useless for me because i am using no-latin keywords (greek characters) in order to optimize my SEO. From that moment i dont know how to properly use moz pro in order to optimize my SEO score (if this still can be done) so i would like to ask: Without these two powerfull tools how can i use the Moz Pro in order to optimize my (greek) website? Is this possible to do it with out these two tools? should i try to do it manually? if yes what i have to read/learn in order to do it manually? What other tools can i use in order to help me rank my website instead of On-Page grader and optimization? Thanks in advance
API | | tsalatzi0 -
Using excel to pull MOZ data about links
I have a list of links 500 in excel that I would like to get the number of backlinks, PA and DA for the relevant link, is there a pre-built excel sheet that utilises the Moz Api that can pull this data easily? Thanks!
API | | ChrisClayts0