How to Create a Simple Blog Content Audit Spreadsheet

on October 12, 2012 in Blogging

Recently we talked about the basics of blog content audits. In the comments, Joanna Haugen asked about using spreadsheets to track your plans and progress as you go through the content audit process. I promised a simple tutorial on creating one, and that's what you'll find here.

Export Your WordPress Data

The first thing you'll want to do is export key data from WordPress. You can automate this process using WordPress plugins which can pull your post titles, publication dates, authors, custom fields, and more quickly and easily.

For this tutorial we're going to use theΒ Export to Text plugin (currently at version 2.2).

Install this plugin as you would any other WordPress plugin:

  • Click or mouseover "Plugins" in your WordPress admin area (in the left navigation column).
  • Click "Add new."
  • Search for the "Export to Text" plugin.
  • Click "Install Now."
  • Click the OK button if you get a prompt.
  • Click the link to activate the plugin.

Once you've activated the Export to Text plugin, you can find its settings under "Tools" in the left column menu in your WordPress admin area.

Click the "Export to text" link as demonstrated in the screenshot above. You'll be taken to the following screen where you can choose your export settings.

Check the settings you want. Anything you check will end up in your spreadsheet, so choose the things that are relevant to the kind of content you want to audit (just blog posts, posts in a certain date range, posts from a particular author, posts in a certain category, etc.).

Then click the "Download as TXT file" button near the top right of your screen.

Access and Edit Your Spreadsheet

Now that you've downloaded a TXT file of your data, open your spreadsheet software. Then open the TXT file you downloaded in that program.

You should get something that looks like this:

Want to remove these ads? Login or register now.

You can see the exported fields (and you can adjust the width for each of them as appropriate).

The last field called "Content Updates?" is one I manually added for audit purposes. It's where I can quickly mark Y (for yes) or N (for no) when I look at the content and ask myself "does this post need to be edited or updated?"

The only problem I found with this export plugin is that all custom fields are lumped into one category. That means my meta title, description, and keywords for each post are all displayed in one field.

That might be fine if your concern is whether or not those things were added. But if you want to see the content of those SEO-related fields quickly for editing purposes, it will be a bit clunky.

In that case, I'd recommend using the WordPress SEO plugin Sharon Hurley Hall previously mentioned here. It lets you easily view and edit meta data in your post archives right from your WordPress admin area.

Of course you can add more fields than the one I added for this tutorial. For example, you might add fields like:

  • Comment count
  • Tweets (number of times it was shared)
  • Google +1s
  • Facebook Likes
  • Link Updates? (Are there broken links that need to be adjusted? -- I use the Broken Link Checker plugin for this.)
  • Formatting Issues? (Is the post consistent with sitewide formatting rules?)
  • Incoming links (Check third party sources for estimates so you know which posts are attracting links, and which need offsite SEO help.)
  • Attachments, downloads, or images for the post

What you add will depend on the kind of content audit you're interested in and what you're looking to improve (SEO? Social Interaction? On-site consistency?).

What else would you add to a blog content audit spreadsheet? Do you use other WordPress plugins to export this kind of data? Share your tips, suggestions, or recommended resources with us in the comments to help other readers learn about their options.

Thanks for sharing!
Tweet about this on TwitterGoogle+Share on FacebookPin on PinterestShare on LinkedIn
Short URL:
The following two tabs change content below.

Jennifer Mattern is a professional blogger, freelance business writer, and indie author. Through her company, 3 Beat Media, she operates All Indie Writers,,, and numerous other blogs.

Jenn has over 15 years experience writing for others, over 11 years experience in blogging, and 9 years experience in indie e-book publishing. She is an Active member of the Horror Writers Association.

Subscribe to the All Indie Writers newsletter to get personal updates from Jenn in your inbox.


  1. Sharon Hurley Hall
    Sharon Hurley Hall October 12, 2012 Reply

    Ooh, thanks for this, Jenn. I like the look of this plugin and it seems to me it could be used for all kinds of other purposes, like exporting post text for a book of your blog, for example.

    • Jennifer Mattern October 12, 2012 Reply

      Definitely. I think that’s a great way to use a plugin like this! πŸ™‚

  2. Anne Wayman October 12, 2012 Reply

    love it… worked the first time I tried your instructions… now to figure out what it all means πŸ˜‰ Thanks, Jenn

    • Jennifer Mattern October 12, 2012 Reply

      Awesome. I was worried I’d complicate things even more and the first comments would be “this didn’t work with my spreadsheet software.” πŸ™‚

  3. Cathy Miller October 13, 2012 Reply

    Wow-love this. I had no idea something like this was available. Thanks, Jenn!

  4. Steve Costello January 24, 2013 Reply

    Came to this from Cathy Millers Google+ post:

    I was just think about something like this and was going to attempt to start one myself. These tips should make things much easier for me.

    I am relatively new to WordPress and keep finding so much stuff.

    • Jennifer Mattern January 28, 2013 Reply

      Thanks for stopping by Steve (and thank you Cathy for referring him). Happy to have you here. πŸ™‚

      I hope you come up with the perfect content audit spreadsheet for you needs, and I’m glad this post might help.

      I’ve been using WordPress for quite a few years now, and I’m still learning and finding new things to do with it. That’s half the fun! πŸ™‚

  5. Mitchell Allen January 28, 2013 Reply

    Wow, Jennifer, I wish I had seen this before I started my own project. Well, that would have involved time-travel, as I started the blog to ebook project in Sept., 2012. LOL

    Still, I will look at this plug-in and see it it simplifies the process.



Add comment

By using this comment form you agree to the site's Comment Policies.

Leave a Reply

Your email address will not be published. Required fields are marked *