Using Google Spreadsheets for SEO
I’m a big fan of spreadsheets… mainly Excel which is great for all sorts of SEO activities like monthly reporting, goal setting, keyword research and ontology, and on and on. I’m also a big fan of Excel’s slower, clunky competitor: Google Spreadsheets (GS). Fortunately what GS lacks in the speed department are made up for in the collaboration and live web data departments. At times GS is slow, loading-forever-copy-and-paste-finicky, but there are some really useful upsides to this tool as well. Being able to collaborate on docs in real time is pretty awesome. Another great feature is live the ability to pull in webdata. GS allows for importing of RSS feeds and almost any content via the Import XML function which allows for importing web content via Xpath.
Here are some great Google Docs for SEO found from around the web and listed below. Simply click on FILE>MAKE A COPY to test any of these.
Need help brainstorming? With this document you can see what is popular and being talked about right now across several different types of sites. This can lead to ideas and inspiration of what Ito write about.
From Majestic SEO: “The tool grabs the list of the backlinks you have lost during the previous month. Then it filters the list to harvest the domain names where your links have been deleted.” – See more
From Chris Le. Chris’s spreadsheet/ tool is great because it allows you to aggregate data from SEOmoz, Google Analytics, Twitter, and more into one Google Spreadsheet
Hopefully some of these gogole docs will inspire your own, custom SEO creations. There is also a very informative post at distilled.net that teaches how to use Xpath to import live content into your GS. Do you have a cool GS for SEO? Tell us about it in the comments below!