Making Meal Planning Easy: Recipe Spreadsheet

Ohey!

I have a little confession to make - on Tuesday we ditched the meal plan and had a Dominos. It was completely indulgent and did break the food budget we set for the month, but we've been so good at cooking every night and doing our best to stay healthy that a lazy meal just sounded too good to pass up. We did apply some sensible principles to the splurge though - it was Two for Tuesday meaning we got 2 pizzas each and lunch was sorted for the next day. Also upon seeing that his pizzas cost twice the price of mine Chris even swapped to getting gluten free pizzas himself, so it was under £15 for 4 pizzas. Not cheap, but not break the bank either.

Even though it was contrary to our budget, it did make me appreciate how our routine since moving over has helped us save a lot of money, time and hassle just by keeping us organised. It's only when you stop using something, even for a moment, that you realise just how useful it is! So I wanted to share with you just how we're planning our meals and keeping things on-budget.

Introducing our recipe spreadsheet..

It's a work-in-progress, but it's working well so far!

This is one tab of a much larger spreadsheet where we keep our entire lives organised. It contains everything from our meal plans and recipes to our monthly budget, upcoming travel plans to home maintenance tasks to keep on top of. Basically if there's something that needs to be planned or organised in our lives, it has a tab!

There are two tabs that relate to our meal planning - the one above that contains all of our favourite recipes and another where we plan our meals for the week and create our shopping lists. I say lists because even those are broken down further - regular shopping, a list for the market (there's a weekend market nearby that has some amazing food when we want to make something special!), and lists for pantry items, cleaning items and misc. At the moment we also have a furniture list, but that will go once we've finished furnishing the house (and no news there either I'm afraid).

It sounds a little extreme to be this organised, but with so much going on and such variation in my fatigue it has really helped me remember things that would otherwise be forgotten. We also keep this spreadsheet on Google Docs so that Chris and I both have access to it and can edit it from either laptops or our phones when we're on the go. It's been incredibly useful for coordinating when he's at work!

So how do you set up something like this? It's quite simple and quick to do if you already have some favourite recipes bookmarked but even if you don't it doesn't take long to put together.

The set up

First you'll need to decide on a spreadsheet programme - Google Docs is easiest to access from anywhere, but Excel or Sheets works too. Then set up the top row much the same as I have, with the following columns:

Recipe Name - This might be the name the recipe book/site gives it, or the name you've given it yourself.

Main Ingredient - By having this column you can quickly look up recipes with a specific ingredient if you have an excess of something to be used up.

Cooked On - Similarly, having this column makes it easy to see what equipment you'll need for a recipe. For example if you're going to be out for the day and want a simple meal waiting for you then sorting by slow cooker will be useful!

£/Portion - This is something we're interested in as if we like a recipe and it has a low cost per portion it's gonna fast become a family favourite! We're aiming to get most of our meals to £1/portion or less.

Rating - This is what you and other family members think of the recipe. If anything gets less than a 3 then just delete it - over time you'll want to be cultivating a spreadsheer full of low-cost 4s and 5s.

Notes/Changes - These are changes you make to the recipe - for example we use sweet potato instead of normal a lot, or switch out beef mince for pork. Or if you add extra seasoning, be sure to mention it here so you can make it the same next time.

Link - This is simply a link to the recipe online. You could also keep a note of which cookbook/page the recipe is on if you have a physical copy.

Filling it in

This can be done all at once or over time. I've been keeping a folder of bookmarked recipes on my laptop for a long time anyway so I went through those and copied across ones I knew we would use regularly. Then it's just a case of keeping it updated as you find new recipes you like or want to try. I'm thinking of adding a baking section as we've got quite a few recipes we want to try like Apple Granola Bars and Sweet Potato Muffins.

It's also a great excuse to discover new recipes if you have an excess of a particular ingredient or find something on sale at the shop. We usually use the weekend to make something a little more ambitious, so we'll pick something we have in the freezer and maybe a style of cooking and see what the internet has to offer us. Chris searches for recipes during downtime at work and this was how we ended up with an amazing Harissa Chicken recipe! :)

Using it

I'm planning to write a blog on meal planning sometime soon which will go into this a bit better, because it's one of my favourite ways to get organised and save money. There are so many little tricks you can use to cut down your food budget without losing out on amazing meals it definitely deserves it's own blog! But the beauty of this spreadsheet is in its' simplicity.

Need a chicken recipe? Sort by the main ingredient column and select one. Looking for something to throw in the slow cooker and go out for the day? Sort by the cooked on column. Budget looking a little tight this month? Pick all the lowest cost per portion recipes you've collected over time (if you've bothered with this one)!

The hardest part is getting into the habit of using it, but once you see how easy it is and how much faster it makes everything I'm convinced you'll be as sold as I am. :)

How do you keep your recipes in order? Or do you just wing it? Any you think I should add to the list? Let me know in the comments! I'm always looking for yummy new recipes to try, especially on weekends when we can put a little more effort in. :)

Love,
Ami
xx