For the love of grocery lists and spreadsheets

What you see above is my new and improved grocery list. It makes me ridiculously happy. So does talking about grocery list habits (totally serious). So let’s talk about it. 

Let me answer a few questions. Yes, the columns are arranged by aisle content at my Trader Joe’s. And yes, our most frequently purchased items are listed according to where they are in the store. And yes! there is a spot for listing meals and items to purchase elsewhere (Target/other grocery store) at the bottom. I KNOW. 

Designing a grocery list template like this is something I had on my mental to-do list forever. Finally I made the time to do it. And like many things that I put off, it ended up taking maybe 30 minutes and I wondered why it had taken me so long to do it.

To make the template I created a spreadsheet in Excel and organized the columns to reflect the aisles at our Trader Joe’s (where we shop each week). Since I had the room, I have most columns reflect just one side of one aisle. So if I were a tiny shopper in this spreadsheet I’d be walking down the line dividing the columns, grabbing jam from the right and vitamins and toilet paper on the left.

Then I added our frequently bought items on the correct “aisle.” I was able to do this mostly from memory but as I find a frequent item that I missed I just update the template. I’m also finding that our frequently bought items change over time, so I’ll update the template accordingly.

To make a grocery list I indicate an item that we need by circling it. If we need something that’s not already on the template I’ll write it on the correct “aisle” and then circle it. I prefer to take a highlighter to the grocery store and cross items off that way. Because I’m adventurous that way.

The best part about this layout is that it’s exactly how my mom made our grocery list when I was growing up. So now you know where I get it.

I printed about 10 of these and have them clipped to the side of the fridge. Also on the side of the fridge is a small white board where we jot down items we run out of or need throughout the week. So when I sit down to make a grocery list I grab a grocery list template and first circle or write in any items from the whiteboard.

At the bottom I write out dinner ideas or anything special we are going to make (like if we are hosting friends for dinner).  Then I circle or write in and circle items that we’ll need for those meals/recipes and round out the grocery list with anything else we need. Such as BOURBON for maple bourbon ciders on my big Christmas Eve/Christmas shopping list above. 

And if you are not already convinced to give this a whirl, have I mentioned that one day at Trader Joe’s a 60s-ish man stopped to admire my grocery list and proceed to ask if he could take me home with him? Still got it, guys. But honestly, it was not creepy and he kept exclaiming to his wife throughout his shopping trip about my organized list. This is the kind of first impression you want to make on people! 

I’d love to hear how you make your grocery list! I’ve tried an app but I hate having to take my phone out a million times at the store and keep waking it up. For now old fashioned paper is working for me. Grocery list-making is one of those weird topics that seems mundane but that completely fascinates me. So do tell!

33 responses to “For the love of grocery lists and spreadsheets”

  1. Katie Avatar

    I use our grocery store app. Carrying my phone is the worst part, but the benefits outweigh it for me. The app is from our actual grocery store so everything is organized by aisle, and it gives you a total which is so helpful for budgeting purposes. Also, my husband and I can each update the list whenever, which is super convenient.

    1. Kelsey Avatar

      Oh nice, an app from the grocery store itself does sound convenient. If TJ comes out with an app I’d for sure try that.

  2. Julie Avatar

    I love Grocery Pal! You can organize by store, aisles and favorites!

    1. Kelsey Avatar

      I love being able to organize everything by aisle!

  3. Lindsey Avatar

    I totally agree that waking up a phone a million times at the store gets annoying, but I use the Wunderlist app because two benefits outweigh everything else I’ve tried. First, the grocery list is shared with my husband so if we’re tag-teaming weekend errands it’s readily accessible from either of our phones. Second, I don’t tend to sit down and write a list but instead I tend to think of things throughout the week. I like being able to pull out my phone or a browser tab at work and add things as I think of them instead of waiting (and forgetting) to write them on the paper/fridge. Before shopping, I always reorganize the items on Wunderlist to be in the order I shop the store.

    1. Kelsey Avatar

      I love hearing everyone’s solutions to this “universal problem”!

  4. Kat Avatar

    This is great. I’ve actually been working on a post that talks a bit about our meal planning and how I write out our grocery list but your strategy is next level! I always use paper (grocery apps have never made sense to me), but the most detail we get into is splitting up what food comes from which store (we go to ALDI first and then fill out our pantry with items from TJ’s and a general retailer). Happy shopping!

    1. Kelsey Avatar

      Before I had the spreadsheet I would still write out all the items in the order of how I moved through the store, so it’s been a process. I think posts about meal planning and grocery shopping are fascinating (obv) so I’ll look forward to seeing yours!

  5. S Avatar

    I just hand write mine in a small notebook. At the top of the page, I list lunch, dinner, and any other relevant plans (eg- going to the gym after work means I don’t want to plan a more elaborate dinner recipe!) Then I create columns for fruit and veggies, meat and dairy, frozen, aisles, and other. I shop at different stores different weeks because I like each store for different reasons; the weekly menu sometimes determines what store I go to, but sometimes the store I decide to go to, and what’s best there, will determine the week’so menu! Some things I prefer to buy at specific places (eg- olive oil and frozen items at trader Joe’s, fresh produce at the farm market), and some items aren’t sold at each place (eg- no cereal or meat at the farm market), so for non-perishables or frozen things I just have to buy a bit more than needed on the weeks I do go to the shops that sell those. I’ve contemplated switching to some sort of app, but this is just easy, especially since at the store I can just leave the notebook open on my cart and not fidget with my phone. For non-food items, I’m experimenting with a checklist on an app, where I’ve listed every item (TP, shampoo, toothpaste, etc), and moving the items back and forth between the ‘need to buy more’ and the checked off ‘don’t need to buy right now.’ And then whenever I’m planning a trip to target, I can run through the checked-off section and decide if there’s anything I should get while I’m there.

    1. Kelsey Avatar

      I love getting peeks into how other people organize all this – managing different items, different stores, etc. I love seeing all the different solutions!

  6. Meg Avatar

    This is majestic. I love it. I use an app called Buy Me a Pie which is customizable to how I like things organized. Loosely, my categories are: produce (including non-produce things in the produce section like nuts and nice cheese), dry goods, eggs and dairy, meat, frozen, and household items. This is basically how my mom does it too. I don’t really do paper any more because I tend to forget my list if I do. On the side of our fridge, we have small whiteboard for stuff we’ve run out of and a whiteboard sticker thing with days of the week that we use for planning out what we’re eating. I think I got it at HomeGoods. Before my son was born, we used to grocery shop for two weeks at a time. We live rurally, so it made sense since it’s a 30 minute drive one way to the store and it felt like a real burden to go every weekend. These days we’re lucky to remember that we need a meal plan at all, and tend to shop once a week again, but only one of us goes while the other stays home with the baby. We’re working on having some “healthy defaults” when it comes to meals, especially since we tend to revert to whatever is easy now that we have a baby. One strategy I’ve used successfully is to make double batches of everything and freeze a portion. It’s rarely more difficult to make twice as much soup or tomato sauce or pizza dough and it saves my sanity on another day. The only trouble is that I tend to get bored with food easily so I’m making peace with having meals repeatedly for a month or two and then moving on to something else that then gets repeated for another month or two. If I get burned out on a food, I don’t want to eat it again for years, which defeats the purpose.

    1. Kelsey Avatar

      Haha “majestic”! I LOVE that, thank you! I really want to do freezer meals…I think an issue is that lately we haven’t been making recipes very much, just kind of one-off meals. Have not found a ton of recipe meals that the boys will consistently eat so hesitant to make a ton. But one day that will change! And LOVE the concept of healthy defaults, I think about that a lot and it makes such a huge difference.

  7. Nicole M. Avatar

    Oh my gosh, this is awesome. I love your level of excitement for grocery lists! And love the story about the older gentleman 🙂 I need to get my grocery list process under control. I typically just use a little list that I’ve written out on a scrap of paper… which is doing the job I guess… but I like your approach better. I usually write my items down in the order of how I go through the grocery store (also a habit from my mom), as opposed to all willy-nilly… but I may try to recreate your spreadsheet idea 🙂

    1. Kelsey Avatar

      The spreadsheet is so satisfying, I highly recommend it. Or before this I had a half-sheet sized notebook dedicated just to grocery shopping. On a two-page spread I would meal plan on the left and the write my grocery list on the right, everything in order of the store aisles. that could be a step before a spreadsheet even!

  8. Catherine Short Avatar

    And that’s why everyone should shop at Trader Joe’s. 😉

    1. Kelsey Avatar

      Haha!

  9. Casandra Avatar

    Geeking out on grocery lists?…I’m totally here for that! I use the Out of Milk app which 1) allowed me to create custom categories that corresponds to my Trader Joe’s aisles and 2) prevents the phone from going to sleep while the app is open

    1. Kelsey Avatar

      I’ve heard of that one, hey that is so smart that it prevents it from going to sleep. Clearly they heard from people like me!

  10. Sarah Avatar

    My mom made her grocery lists like this when I was growing up! Organized by aisle and everything. I remember her complaining when the store would occasionally switch things around — ha. Sadly I’ve never done this myself. And only partially related but whyyyyy do I not have a Trader Joe’s near me? Every time you talk about TJ I get so mad I don’t have one in my part of Houston. Grr! Perhaps the TJ gods will hear this comment and get on that…

    1. Kelsey Avatar

      Oh I wish they would open one near you!! Are they in the area at all…could be worth a monthly trip, or just a fun little solo trip for you. Especially during the holidays it’s a magical place. Oh my gosh, my Trader Joes totally reorganize a couple years ago, sometimes I’m still thrown off by where things are.

  11. Mere Avatar

    Love this!! I use Wunderlist, but I love that his is organized by aisle. I’ll have to try it out!! 🙂

    1. Kelsey Avatar

      Organizing by aisle is next level. Once you try it you won’t want to go back! 😉

  12. Feisty Harriet Avatar

    Figuring out a grocery/meal planning system that works!? SO PRICELESS!!! xox

    1. Kelsey Avatar

      Definitely agree! This one is definitely making me so happy…we’ll have to discuss at our hiking date.

  13. Michelle Avatar

    I love this topic, I get just as excited as you! I use an oversized notecard and on one side I meal plan for the week. Then I write on the back what ingredients I need to make the meals. I start the list with the items we are out off (which I track with a magnet pad on my fridge that my husband and I jot down items when we run out of them). My biggest challenge is that I don’t have a car (I live in a very urban environment) and have to carry all my groceries, so I can’t buy too many heavy things at once. Because of this we usually don’t have a lot of drinks and don’t do a lot of canned items. Even still, I usually have to grocery shop twice a week, or take the husband with me to carry half.

    1. Kelsey Avatar

      that is a challenge! I wonder, is biking an option at all? We have occasionally done grocery trips via bike and hauled groceries in our trailer.

  14. Amber Avatar

    I do this basically the same way but just keep it on the desktop computer in the kitchen. I also have the price of items to the right with totals so we don’t go over budget on groceries. Most of my shopping is done at a warehouse chain and another chain with lots of options so I don’t want my spending to go overboard. The paper list with prices helps me stay on track.

    1. Kelsey Avatar

      Ohhhh, that is SO SMART and I love it!! Hmm, now you have me thinking. Maybe I will do a reiteration with prices, I love the idea of planning ahead what you will spend and seeing where you can cut back if you are over. I think Chris will especially love this. Thanks so much for this idea!

  15. Bridey Avatar

    Genius! I really need to get my grocery list sorted out, and might just have to give this a try.

    1. Kelsey Avatar

      I hope you will, let me know

  16. Betsy Avatar

    I love thinking about grocery lists— if only they didn’t always ending in cooking (which I don’t love…thinking about OR doing!) I had my techie husband build me a spreadsheet with a bunch of special formulas. Basically I input all my stars recipes. Then each week I go in and filter down the ones I want to make that week and it provides me with the recipes I need for them all. I use that as the base of my grocery list and normally have another column that has the weekly standard that I just plan to buy each time. I fell out of practice using this handy too, so I am glad to have read this post to inspire me to get back at it! Now, if I only had a personal chef to cook all said groceries…..

    1. Kelsey Avatar

      Haha! I love the use of favorite recipes, that is so smart.

  17. Kristine Avatar

    Are you willing to share a link to your spreadsheet? I would love to try it. 🙂

Leave a Reply