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.

      What is your Brand Authority?
      Moz

      What is your Brand Authority?

      Check yours now
    • 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.

      • SEO Q&A

        Insights & discussions from an SEO community of 500,000+.

      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
    1829
    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

      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

        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

          Chris, does this help?

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

          Chris.Menke 1 Reply Last reply Reply Quote 0
          • 1 / 1
          • First post
            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

          • Rawaluij

            Unsolved Can links tracking lists help to crawl high authority backlinks by Moz 2024

            links link tracking list

            Hi i am create a link tracking list for my domain, but Moz don,t crawel after 2 weeks completed.

            API | | Rawaluij
            1
          • 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 | | adrianTNT
            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 | | willadogy
            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 | | juanitajb9
            0
          • Gandoo1

            How to crawl backlinks manually in Moz

            My question is how to index link in Moz fast?

            API | | Gandoo1
            0
          • AndrewMicek

            Frequency of Moz page authority updates?

            I have some new pages on my site, and Moz gives them a very low PA ranking. I am wondering if these scores are updated monthly or quarterly? I'm not sure how frequently to check back for updated scoring.

            API | | AndrewMicek
            0
          • SteveWarren

            Extracting MOZ Domain Authority

            Hi
            I have looked but cannot find any reference to this, so I hope someone can help me.
            Is it possible to upload a list of domain URLs and retrieve their MOZ Domain Authority?
            Many thanks
            Steve

            API | | SteveWarren
            0
          • KJMM

            Is there a MOZ app for iPhone?

            Is there a MOZ app for iPhone?

            API | | KJMM
            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
          • 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.