Moz Open Site Explorer Template in Microsoft Excel

This template allows you to pull data from Moz Open Site Explorer (OSE) into Excel using Power Query (Get & Transform in Excel 2016).

Moz OSE is an online tool that allows you to see what sites link to a given site (known as a backlink). Links to a site is one of the top ranking factors for search engines like Google. More backlinks from higher quality sites means higher search ranking!

This is a great tool for anyone with a website trying to increase their search rankings as it will allow you to find out what links your competitors have. If a site has linked to your competitor, then they may be interested in linking to your site also. You can read more about it here and thanks to Neil Patel for the inspiration!

For this template to work, you will either need to have the Power Query add-in installed or have Excel 2016.

  • Input the URL of the site which you want to pull Moz Open Site Explorer data from.
  • Input the page number of the results you want.
  • Press the Get Moz Data.
  • Data is loaded into the Output tab.
  • Clear data from the Output tab by pressing the Delete Table button on the Input tab.

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Subscribe

Subscribe for awesome Microsoft Excel videos 😃

John MacDougall

I’m John, and my goal is to help you Excel!

You’ll find a ton of awesome tips, tricks, tutorials, and templates here to help you save time and effort in your work.

Related Posts

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃