Skip to content
    Moz logo Menu open Menu close
    • Products
      • Moz Pro
      • Moz Pro Home
      • Moz Local
      • Moz Local Home
      • STAT
      • Moz API
      • 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.

      Discover Brand Authority
      Moz Pro

      Discover Brand Authority

      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?

      Take the quiz
    • 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+.

      June 3 & 4, 2024, Seattle
      MozCon

      June 3 & 4, 2024, Seattle

      Get tickets
    • 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: Moz Pro

      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

    Using excel to pull MOZ data about links

    API
    2
    3
    1746
    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

          • Umair123321

            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 | | Umair123321
            3
          • Tindol

            When I click into the moz bar on our website www.essexparts.com it shows that the URL is Canadian and shows a Canada flag. The website and company are in the US. Can someone please explain this?

            When I click into the moz bar on our website www.essexparts.com it shows that the URL is Canadian and shows a Canada flag.  The website and company are in the US.  Can someone please explain this? Also does the location have any bearing on how it shows up in google? XNQOQoJ

            API | | Tindol
            0
          • Roman-Delcarmen

            Moz Api Integration with Google Data Studio

            I want to automate my competition research process. Right now my competition research is completely manual which is ok if working in a small project. Usually, start looking at Google for the best sites for a specific niche. In an excel sheet insert the URL in a column and start to put information in next columns, information such as DA, PA, backlinks, page speed, schemas validation and stuff like that. As I mentioned for a small project I usually take 10 websites as a reference to analyze how difficult can be rank a website. The problem starts when I have to scale when I have to evaluate 100 or 200 or even more websites in different niches or target location or industry. Does not make sense keep doing manually. So my question is there any way to connect the Moz API to Google Data Studio or Google Sheet

            API | | Roman-Delcarmen
            2
          • TheKatzMeow

            Integrating Moz with DashThis

            I'm trying out DashThis as a way to visualize data for clients with whom we do a combo of SEO, PPC, and SEM work. I like the main Moz Pro campaign dashboard page for distilling top-level information and the rankings page for tracking keyword ranks. In an ideal world, I'd love to be able to sort replicate these within DashThis. I see that DashThis does integrate with Moz but looking at the Mozscape API documentation I couldn't tell if this type of integration is possible in DashThis. I realize this is a super specific question, but I thought I'd ask the community if this integration is possible or if I have more limited range of options.

            API | | TheKatzMeow
            0
          • Storfiskaren

            Is there an easy way to get MOZ data into Google Sheets?

            Is there any way to pull data directly from MOZ to Google sheets, like a plug-in for sheets?

            API | | Storfiskaren
            2
          • silvacarl

            Does anyone have an example of using the Moz API with curl in bash?

            Does anyone have an example of using the Moz API with curl in bash?

            API | | silvacarl
            0
          • moon-boots

            Moz Not Accounting for Google Tags

            The main problem I have is that the most serious issues facing my site have been dealt with using Google Tags, but Moz doesn't take this into account (this has been verified by a Moz employee) so I can't get an accurate account of what crawl issues need fixing and which ones are resolved. Does anyone know a way to make Moz Tools account for Google Tags?

            API | | moon-boots
            0
          • chickenjoy2013

            MOZ API Developer

            Hi Moz Fans, Can you recommend someone who can develop an app/tool as similar to Hubspots Marketing Grader Functionality http://marketing.grader.com/ using MOZ API? I appreciate all your help guys Thanks, Tony

            API | | chickenjoy2013
            0
          Moz logo
          • Contact
          • Community
          • Free Trial
          • Terms & Privacy
          • Accessibility
          • Jobs
          • Help
          • News & Press
          • MozCon
          © 2021 - 2024 SEOMoz, Inc., a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz, Inc.

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