undefined
Skip to content
Moz logo Menu open Menu close
  • Products
    • Moz Pro
    • Moz Pro Home
    • Moz Local
    • Moz Local Home
    • STAT
    • Moz API
    • Moz API Home
    • Compare SEO Products
    • Moz Data
  • Free SEO Tools
    • Domain Analysis
    • Keyword Explorer
    • Link Explorer
    • Competitive Research
    • MozBar
    • More Free SEO Tools
  • Learn SEO
    • Beginner's Guide to SEO
    • SEO Learning Center
    • Moz Academy
    • SEO Q&A
    • Webinars, Whitepapers, & Guides
  • Blog
  • Why Moz
    • Agency Solutions
    • Enterprise Solutions
    • Small Business Solutions
    • Case Studies
    • The Moz Story
    • New Releases
  • Log in
  • Log out
  • Products
    • Moz Pro

      Your all-in-one suite of SEO essentials.

    • Moz Local

      Raise your local SEO visibility with complete local SEO management.

    • STAT

      SERP tracking and analytics for enterprise SEO experts.

    • Moz API

      Power your SEO with our index of over 44 trillion links.

    • Compare SEO Products

      See which Moz SEO solution best meets your business needs.

    • Moz Data

      Power your SEO strategy & AI models with custom data solutions.

    NEW Keyword Suggestions by Topic
    Moz Pro

    NEW Keyword Suggestions by Topic

    Learn more
  • Free SEO Tools
    • Domain Analysis

      Get top competitive SEO metrics like DA, top pages and more.

    • Keyword Explorer

      Find traffic-driving keywords with our 1.25 billion+ keyword index.

    • Link Explorer

      Explore over 40 trillion links for powerful backlink data.

    • Competitive Research

      Uncover valuable insights on your organic search competitors.

    • MozBar

      See top SEO metrics for free as you browse the web.

    • More Free SEO Tools

      Explore all the free SEO tools Moz has to offer.

    NEW Keyword Suggestions by Topic
    Moz Pro

    NEW Keyword Suggestions by Topic

    Learn more
  • Learn SEO
    • Beginner's Guide to SEO

      The #1 most popular introduction to SEO, trusted by millions.

    • SEO Learning Center

      Broaden your knowledge with SEO resources for all skill levels.

    • On-Demand Webinars

      Learn modern SEO best practices from industry experts.

    • How-To Guides

      Step-by-step guides to search success from the authority on SEO.

    • Moz Academy

      Upskill and get certified with on-demand courses & certifications.

    • MozCon

      Save on Early Bird tickets and join us in London or New York City

    Unlock flexible pricing & new endpoints
    Moz API

    Unlock flexible pricing & new endpoints

    Find your plan
  • Blog
  • Why Moz
    • Small Business Solutions

      Uncover insights to make smarter marketing decisions in less time.

    • Agency Solutions

      Earn & keep valuable clients with unparalleled data & insights.

    • Enterprise Solutions

      Gain a competitive edge in the ever-changing world of search.

    • The Moz Story

      Moz was the first & remains the most trusted SEO company.

    • Case Studies

      Explore how Moz drives ROI with a proven track record of success.

    • New Releases

      Get the scoop on the latest and greatest from Moz.

    Surface actionable competitive intel
    New Feature

    Surface actionable competitive intel

    Learn More
  • Log in
    • Moz Pro
    • Moz Local
    • Moz Local Dashboard
    • Moz API
    • Moz API Dashboard
    • Moz Academy
  • Avatar
    • Moz Home
    • Notifications
    • Account & Billing
    • Manage Users
    • Community Profile
    • My Q&A
    • My Videos
    • Log Out

The Moz Q&A Forum

  • Forum
  • Questions
  • Users
  • Ask the Community

Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

  1. Home
  2. Moz Tools
  3. API
  4. Using excel to pull MOZ data about links

Moz Q&A is closed.

After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.

Using excel to pull MOZ data about links

API
2
3
1.8k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as question
Log in to reply
This topic has been deleted. Only users with question management privileges can see it.
  • ChrisClayts
    ChrisClayts last edited by Nov 12, 2013, 6:52 PM

    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!

    1 Reply Last reply Reply Quote 0
    • Chris.Menke
      Chris.Menke @Chris.Menke last edited by Nov 12, 2013, 9:25 PM Nov 12, 2013, 9:25 PM

      or maybe this:

      http://www.aleydasolis.com/en/search-engine-optimization/seo-dashboard-google-docs-seomoz-analytics/

      1 Reply Last reply Reply Quote 1
      • Chris.Menke
        Chris.Menke last edited by Nov 12, 2013, 9:21 PM Nov 12, 2013, 9:21 PM

        Chris, does this help?

        http://moz.com/ugc/updated-tool-seomoz-api-data-for-google-docs

        Chris.Menke 1 Reply Last reply Nov 12, 2013, 9:25 PM Reply Quote 0
        • 1 / 1
        1 out of 3
        • First post
          1/3
          Last post

        Got a burning SEO question?

        Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.


        Start my free trial


        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.

        • See all categories

        Related Questions

        • Skys

          Unsolved MOZ API for domain authority

          api da

          I am using the MOZ API to check domain authority (DA). Recently, I noticed a discrepancy: the DA value retrieved via the API differs from the result on the MOZ homepage. Specifically, the API returns a DA of 10, while the homepage shows "NO DATA." Additionally, other services like Ahrefs report a DA of 0. I relied on the MOZ API's result when purchasing this domain and now feel misled. I would like to understand the exact reason for this inconsistency.

          API | Nov 19, 2024, 10:53 AM | Skys
          0
        • adrianTNT

          Unsolved How to get Domain Authority using API ?

          api domain authority

          I wanted to test the API and while looking on the documentation urls, I cannot find details on how to get Domain Authority. is that not available to query ? was it replaced by Brand Authority ? is it only available for the paid API or for the free one too ? I looked at many documentation pages but I find it very confusing and frustrating, there are many versions of the documentation and various URLs and not clearly labeled, I understand some are V1, V2, V3, etc, but I didn't find sample API calls for Domain Authority. Thank you.

          API | Nov 23, 2024, 6:04 PM | adrianTNT
          0
        • NickAndrews

          Unsolved Regarding Moz API token password update

          moz api access token

          Hi, In March we have updated password for MOZ API and used in our application it worked, but currently the updated password is not working and in the MOZ site the old password is shown and its active. We are using Legacy username and password.
          We see that 5 tokens can be added for API, if we add 2 tokens both will be active.
          We are currently using free services. Please help us resolve this issue.

          API | May 22, 2024, 3:43 PM | NickAndrews
          0
        • willadogy

          Unsolved Moz API returning incorrect PA data

          api page authority

          So I've been attempting to figure out Moz API to allow for batches of URLs to be searched and the data to be nicely put into a google sheet. I've setup the MOZ API for sheets add-on and everything appears to work, but after spot checking some of my data, I've found that for some reason, the page authority data returned by Moz API appears to be way off the actual number presented by other Moz tools, such as the tool bar and main site.
          Screenshot 2023-06-01 at 9.38.25 AM.png
          Screenshot 2023-06-01 at 9.41.43 AM.png As you can see, in this one example off my list, the returned PA value is 6 points lower than the value returned from the Moz tool bar and website analysis.
          If the data returned is incorrect, how is Moz API useful? Am I missing something? Would love some help or advice, as this tool would be very useful in a functioning state!

          API | Jun 1, 2023, 2:45 PM | willadogy
          0
        • CarolinaRen

          Unsolved Can I get Moz keywords via API?

          api keywords

          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 | Apr 22, 2022, 6:46 PM | CarolinaRen
          0
        • juanitajb9

          How to remove bad or spammy links from Moz?

          My website has gotten some bad and spammy links. I know how to disavow bad links from Google. But I reviewed Moz and haven't got any disavow option.
          Have any disavow option on Moz? How can I remove the bad links from Moz? Thanks

          API | Apr 15, 2021, 3:46 AM | juanitajb9
          0
        • eBrandz

          Seo moz api request problem [401 error_message Your authentication failed]

          Hello Team, I have moz pro account. I'm getting following error for seomoz call using your 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"} The link that we are using is:
              http://lsapi.seomoz.com/linkscape/url-metrics/ And following bits are requested during the call: 68719476736 34359738368 32 2048 16384 The error is intermittent. It comes and goes. There were no issues with results 3 days ago. I suddenly started getting this error. Could you please investigate into it and let me know the cause of issues and its correctiveness. It will great if you can provide us a support email Id for immediate response. Thanks,

          API | Jul 25, 2014, 7:32 PM | eBrandz
          0
        • jessential

          What is Moz's Error.aspx?aspxerrorpath HTTP Status 302 error message?

          Hi, I am not sure what this error message is: "Error.aspx?aspxerrorpath". It immediately follows pages that are given at 302 status in Moz's crawl report. The same pages have never had this error before: | http://www.homedestination.com/news/2013/Minneapolis-home-price-appreciation.html | | http://www.homedestination.com/mortgage-worksheet.html | | http://www.homedestination.com/foreclosure-eligibility.html | Each page has a 100% score with WC3.  Could you give me more insight as to what Moz may suggest I do to give the page a 200 HTTP status as before? Thanks.

          API | May 6, 2014, 3:49 PM | jessential
          0

        Get started with Moz Pro!

        Unlock the power of advanced SEO tools and data-driven insights.

        Start my free trial
        Products
        • Moz Pro
        • Moz Local
        • Moz API
        • Moz Data
        • STAT
        • Product Updates
        Moz Solutions
        • SMB Solutions
        • Agency Solutions
        • Enterprise Solutions
        Free SEO Tools
        • Domain Authority Checker
        • Link Explorer
        • Keyword Explorer
        • Competitive Research
        • Brand Authority Checker
        • Local Citation Checker
        • MozBar Extension
        • MozCast
        Resources
        • Blog
        • SEO Learning Center
        • Help Hub
        • Beginner's Guide to SEO
        • How-to Guides
        • Moz Academy
        • API Docs
        About Moz
        • About
        • Team
        • Careers
        • Contact
        Why Moz
        • Case Studies
        • Testimonials
        Get Involved
        • Become an Affiliate
        • MozCon
        • Webinars
        • Practical Marketer Series
        • MozPod
        Connect with us

        Contact the Help team

        Join our newsletter
        Moz logo
        © 2021 - 2025 SEOMoz, Inc., a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz, Inc.
        • Accessibility
        • Terms of Use
        • Privacy

        Looks like your connection to Moz was lost, please wait while we try to reconnect.