May 23, 2011

Food Blogging - Organizing and tracking your recipe index.

If you have been food blogging for a while, the time comes where the list of things you need to blog to get caught up spirals out of control. Don't believe me? Take a look at my recipe index.

407 Recipes! -- I just updated this list and now I'm at 415+. Bleh.

Curious how many I've blogged about? About half. 'Ouch' and 'my brain hurts' is all I can say in response. If you are in need of a way to keep track of what food you have made and if you have blogged about it yet, I have a few tips for you.

The title of this spreadsheet is fitting, no?
  1. First, you need to start a spreadsheet. If you don't have an Excel sort of program, head over to Gmail, then go to the 'documents' tab to start one.
  2. Open up your recipe index on your blog. Highlight and copy the entire index. Click back over to the spreadsheet, click into the first box, and paste.
  3. If necessary, delete any rows that were your category headers, like "Desserts" or "Main Dish". All we want is the name of the recipe. That's it! If you use Google docs it should auto save, but be sure to save as you go to be safe.
  4. Next you are going to add in the recipes that you have made but not blogged about. You will want to compile the links ahead of time. Save them to a new folder to your bookmarks menu, or gather up all your print outs and you will be all set to go.
  5. Now that we have a giant list of our recipes, you want to sort the rows so they are displayed A-Z vertically.  You should be able to skim through the list quickly and see if there are any doubles and delete the extra entry.
  6. Click to the left (or you can go to the right) of your recipe column and insert one column to the left. This is where we will add in an 'X' to signify that the recipe has been blogged about.
  7. Go through your recipe index online and quickly mark each recipe with an 'X' if it has been blogged about.
  8. Be sure to save as you go along. Update this weekly or monthly and you are good to go.
Tip: When you are inserting or deleting a row, be sure that you are inserting/deleting an entire row. You do this by right clicking on the number of the row and selecting "Insert one above/below" or "remove row". The reason this is important is if you want to be sure that your two columns match up correctly and you don't accidentally mess the whole list up. That would be super sucky.

If you have any tips please leave a comment!

Party buttons can be found here. I'm linking up to:  

{M) Melt in Your Mouth Mon, Motivate Me MonMaking the World Cuter, Made By You Mon, Made By You Mon, Made by Me Mon, Made With Love Mon, Share Mon, Market Yourself Mon,  Craft-O-Manic Mon, Amaze Me Mon, Metamorphosis Mon, Get Your Craft On, This Week's Cravings, Unwasted Homemaking, Making Mon Marvelous, Mad Skills, Craftastic Mon, DIY Project Parade, Inspire Me Mon, Make Something Mon, Link Party Mon, Mangia Mon, Marvelous Mess Mon, Mad Skills Mon, Homemaker Mon, Mouthwatering Mon, Food'e' Friend Mon, Momspiration Mon, Hunk of Meat Mon, {T} Show Me What You Got,  Tempt My Tummy Tues, Take A Look Tues, Handmade Tues, Show and Tell, All Thingz Related, Anti Procrastination Tues, Tutorial Tues, Tell All Tues, Ten Buck Tues, Too Cute Tues, It's Sew Fun Tues, Tues Time Out, Delectable Tues, Ten on Tues, Toot Your Horn, Tip Me Tues, A Little Birdie Told Me, {W} Whatever Goes Wed, Creative Share Wed, Sugar And Spice, Show Off Your Stuff, Wed Link Party, Hoo's Got Talent, We Did It Wed, Linkin' with Luna, Link Party, Inspired by You Wed, What I Whipped Up Wed, Whassup Wed, Getting Crafty, Anything Goes, Made It On Mon, Whisking Wed, What I Made Wed, Wow Me Wed, {Thur} Strut Your Stuff ThurI'm So Crafty, Crazy Cute Thur, Hookin' Up, Thrifty Thur, A Crafty Soiree, Frogs & Snails, Transformation Thur, Making It with Allie, Catch A Glimpse Thur, It's a Keeper Thur, Things I Love ThurGet Your Craft On , Full Plate Thur, Sweet Treat Thur, Almost Fri Flaunts, Creative Juice Thur, Recipe Swap Thur, {F} Sweet Tooth Fri, Sweets This Week, Frugal Fri, Feature Yourself Fri, Foodie Fri, Home and Family Fri, I'm Lovin' It Fri, Show and Tell, Fri Favorites, Fantastic Fri, Show and Share Day, Fun with Food Fri, Weekend Wrap-Up, Pity Party, Simply Link Party, Lovely Crafty Weekend, Tickled Pink, What's Cooking In the Kitchen, Everything But the Kitchen Sink, Hodgepodge Fri, Favorite Things Fri, Fri Link Party, Inspiration Fri, For the Kids Fri, Whatcha Got Weekend, Make and Share, Fri Free for All, Flaunt it Friday, Who Made What Weekends, Weekend Wander, Foodie Fri, Simply Creations Fri Link Party, Finer Things Fri, Frugalicious Fri , Fancy Fri, Fantabulous Fri, Food on Fri, Weekend Show Off, Fat Camp Fri {Sat} Check Me Out Sat, Sundae Scoop, Show and Tell Sat, Sat Spotlight, Sat Nite Special, Sat is Crafty Day, Shindig Sat, Sat Swagger, Sweets for Sat, Summer Lovin' Sat Soiree, Sat Swap, {Sun} Sun Showcase, Sun Favorites, Sister Sister Sun, Recipe Link Party, Just Something I Whipped Up, Sew Darn Crafty, Think Pink Sun, Not Baaad Sun, Sun Linky Party, Nifty Thrifty Sun, Sun at One Food Club, Your Kitchen, My Recipe, Potluck Sun, Sweet Indulgences Sun, So Sweet Sun, Savory Sun


  1. Thanks for your sweet comments on my blog, and for following too! I've really enjoyed poking around your blog a bit, your recipes look consistently delicious! Following you back!

  2. Ali! It's so nice to have found you again. I was on Pinterest looking at your account because it was suggested to me on the friend finder, and I was thinking... I know this person. :)

  3. Yay Jodi! Glad that you found me too. :) I need to check back at your blog this afternoon and drool over the photography. :D

  4. Thanks for coming by my place. I have really enjoyed checking out your recipes and there are some good ones here. Your blog looks really great. Have a great week.

  5. Whoa that is a long list of recipes indeed! Very informative article. Thanks for sharing!

  6. LOVE this idea! Thanks for the tips! (:

  7. I have zero tips for you, but you just gave me a BUNCH! Thanks. So glad to have found your blog. Anyone who created a blog title after Luke is tops with me. :)

  8. I am using a spreadsheet to organize the recipes I've already posted into an index, and within one spreadsheet I have lots of little tabs to divide them into categories. Lots of work!

  9. Thanks for the tip. I don't do many posts about food, but I can definitely see ways I can you use to keep track of other posts and especially my recipes.

  10. How lovely. Following you from blog hop via Trendy House.. Hope you can stop by sometime.. CUTE blog :))

  11. That is awesome! I feel like I can never find the recipe or I don't know what to make. This way everything is right in front of me! Thanks for sharing over at Tuesday Tell All!


  12. I am loving your blog name and description so cute!! I so have jam hands all over with my 2 year old and it drives me nuts! There should be rag hands for mommies that have to follow around wiping down walls. I am happy to be your newest follower. Please stop by for book club if you're interested--connie,

  13. You're a woman of many talents! Thank you for keeping us organized, motivated and inspired!

    Jenn/Rook No. 17

  14. This is awesome! Thanks for sharing this great idea! You have some great stuff on your blog- I am excited to see what you post next! I am your newest follower and I would love to have you stop by my blog and check it out . . . and follow back if you would like! :)
    Camille @

  15. Thanks for this! I was having problem with my Excel and I just wanted something simple to use to catalog my massive collection of recipes!!

  16. Thank you so much for the organizing tips and linking this up as well!