If you’re already a connoisseur, feel free to hit the menu in the sidebar. If you have no idea why Google docs is the perfect platform for SEO tools, keep reading.

Most digital marketing professionals rely on spreadsheets from simple calculations to complex home-made CRMs.  We live in spreadsheets, whether it’s in Excel or Google docs, they are a marketer’s best friend.

Why Google sheets over Excel?

It’s hard to point out any faults with Excel, it’s reliable, fast, and capable of doing almost anything.  There are reasons for using both, but for the sake of building custom SEO tools, here’s a quick list of things Google sheets does better:

  • Cloud based
  • Free
  • Connects to other Google products we use daily (Google Analytics, Gmail,  Drive) seamlessly
  • Provides us with Google apps script (essentially JavaScript) to build custom scripts
  • Seamless collaboration & permission sharing with library support and revision history

Excel is amazing, and we won’t detract from that. However, for the purpose of building SEO tools, here’s where it falls behind Google sheets:

  • Uses VBA for custom functions / macros which is less documented and harder to learn
  • Documentation and support falls short for custom functions (JavaScript is widely covered around the web)
  • Not cloud based
  • Not free

Need convincing? We’re not surprised..

We’ll show you why Google docs sheets might be your new best friend. We also don’t expect you to warm up to the idea just because we-told-you-so, we’ll show you step by step how to use Google sheets like you use Excel and then take you to the next level.

Brand new to Google sheets?

Start here: https://gsuite.google.com/learning-center/products/sheets/get-started/

Excel Junkie?

Get started by understanding some of the difference between common operations in Excel vs Google Docs

APImethods
October 27, 2017

How to find a list of old URLs for any domain using the Wayback CDX API

How many times have we had to correct a bad migration? Don’t you wish you…

methodssearch console
June 26, 2017

How to fetch and render a page in a test or staging environment safely

This question comes up a lot, and it isn’t that hard to execute a fetch…

Google Apps ScriptGoogle Docs
June 25, 2017

Extract URLs from XML Sitemaps in Google sheets

Get the Script > GitHub repository here Installation Copy the code from the GitHub repository onto your…