Majestic

  • Sign Up for FREE
  • Plans & Pricing
  • Login
  • Language flag icon
    • English
    • Deutsch
    • Español
    • Français
    • Italiano
    • 日本語
    • Nederlands
    • Polski
    • Português
    • 中文
  • Get started
  • Login
  • Plans & Pricing
  • Sign Up for FREE
    • Summary
    • Ref Domains
    • Map
    • Backlinks
    • New
    • Lost
    • Context
    • Anchor Text
    • Pages
    • Topics
    • Link Graph
    • Related Sites
    • Advanced Tools
    • Summary
      Pro
    • Backlink History
      Pro
    • Flow Metric History
      Pro
    • Topics
      Pro
    • Clique Hunter
      Pro
  • Bulk Backlinks
    • Keyword Generator
    • Keyword Checker
    • Search Explorer
      Pro
  • Neighbourhood Checker
    Pro
    • Index Merger
      Pro
    • Link Profile Fight
      Pro
    • Mutual Links
      Pro
    • Solo Links
      Pro
    • PDF Report
      Pro
    • Typo Domain
      Pro
  • Submit URLs
    • Summary
      Pro
    • Similar Profiles
      Pro
    • Profile Backlinks
      Pro
    • Attributions
      Pro
  • Custom Reports
    Pro
    • Get started
    • Backlink Checker
    • Majestic Million
    • Browser Plugins
    • Google Sheets
    • Get started
    • Tools
    • Subscriptions & Billing
    • FAQs
    • Glossary
    • How To Videos
    • API Reference Guide External Link
    • Contact Us
    • The Company
    • Style Guide
    • Terms & Conditions
    • Privacy Policy
    • GDPR
    • Contact Us
    • What is Trust Flow?
    • SEO in 2024
    • Link Building Guides
    • Webinars
  • Blog External Link
    • English
    • Deutsch
    • Español
    • Français
    • Italiano
    • 日本語
    • Nederlands
    • Polski
    • Português
    • 中文

Majestic Add-on Extension for Google Sheets

A simple add-on to bring all of your favourite Majestic data into Google Sheets

Import Link Data from Majestic directly into your Google Spreadsheet without having to log on to your Majestic account.

Request the most popular Majestic data, straight from Google Sheets

A one-off connection between Google Sheets and any paid Majestic Account (Lite and above) lets you call the most popular Majestic commands directly into Google Sheets.

Majestic extension option on Google Sheets
Find on Google Workspace Marketplace »
You will need a Majestic subscription
Majestic extension shown on google workspace marketplace

How to find the Add-on

You can either search for "Majestic" on the Google Workspace Marketplace. Or go straight to the Majestic Google Sheets Add-on.

INSTALLING

From then, it's as easy as pressing the "Install" button, then following the installation stages through Google Sheets.

Install page for Majestic extension

Note: We have to ask for a standard set of permissions that will allow us to create new sheets for your Majestic data. Some of those included permissions would, in theory, allow us to see who you share spreadsheets with, and to change those permissions. Please be assured that we have no interest in ever using this link to your account to do anything other than to add new sheets with Majestic data, and only on your explicit request. If you have any concerns, please contact us.

How to link to your Majestic account

Once you have installed your add-on, you can find it in the Google Sheets Extensions menu, under Majestic.

Majestic plugin can be found in the Excel extensions menu

From here your next step is to link the app to your Majestic account. This is a one-time action that lets us know who you are when you request data from Majestic. You will need to visit Majestic, get an OpenApps passcode token, and type it into your Google Sheets extension.

To get started, choose Extensions » Majestic » Setup. Click Request Auth Token and then step though the setup flow, logging into your Majestic account when asked. This setup phase is nearly complete when you land on the Application Authorised page, and have your token.

Setup page for Majestic plugin
Authorization confirmation for giving Majestic plugin access to account
Authorisation request approved for plugin

Once you have your token from Majestic, head back to Google Sheets, paste it into the setup screen, press "Save Token & Start" and you're good to go!

If you have a subscription, you can save token and start

How can you use the Majestic Google Sheets Add-on?

There are two distinct ways to bring Majestic data into your spreadsheets.

The two ways to bring Majestic data is to extract and augment data

If you want Site Explorer-like data on a single domain or URL, then you want to Extract Data.

If you already have a list of domains or URLs and want more info on each one, then you want to Augment Data.

To get started, simply choose whether you want to Extract Data, or Augment Data, and follow the prompts that appear in the sidebar.

Please note that Extracts will use some of your monthly Analysis Units, and Augments will use one Index Item Unit for each domain or URL. The estimated cost is shown in Google Sheets. You can always find out how many units you have on your My Subscriptions page.

Extract Data

(similar to Site Explorer tabs, suitable when you want data for a domain or URL)

When you choose Extract Data, you will see a sidebar with space for a domain, subdomain, or URL. Type your search in there, and choose the type of data you'd like to import. When you press "Get Data", you will receive a brand new tab for each report.

Extract data using the Majestic data extractor

Augment Data

(similar to Bulk Backlinks, suitable for when you need info on multiple domains or URLs)

To augment data to a list of domains you already have, choose Augment Data, and then highlight a range that contains all of the domains, subdomains or URLs that you would like to lookup. Press the "Load URLs" button to fix your selection, then "Get Data". After a short pause, you will have a brand new tab with your new data.

Augment data using the Majestic data augmentor
Find on Google Workspace Marketplace »

Could we improve this page for you? Please tell us

Fresh Index

Unique URLs crawled 331,189,122,665
Unique URLs found 791,452,257,864
Date range 23 Jul 2024 to 20 Nov 2024
Last updated 1 hour 24 minutes ago

Historic Index

Unique URLs crawled 4,502,566,935,407
Unique URLs found 21,743,308,221,308
Date range 06 Jun 2006 to 26 Mar 2024
Last updated 03 May 2024

SOCIAL

  • LinkedIn
  • YouTube
  • Facebook
  • Bluesky
  • Twitter / X
  • Blog External Link

COMPANY

  • Flow Metric Scores
  • About
  • Terms and Conditions
  • Privacy Policy
  • GDPR
  • Contact Us

TOOLS

  • Plans & Pricing
  • Site Explorer
  • Compare Domains
  • Bulk Backlinks
  • Search Explorer
  • Developer API External Link

MAJESTIC FOR

  • Link Context
  • Backlink Checker
  • SEO Professionals
  • Media Analysts
  • Influencer Discovery
  • Enterprise External Link
top ^