📎 Webclip
How I use Excel for organizing recipes, meal planning, food inventory and grocery lists
The post explains how the author uses Excel spreadsheets to stay organized with recipes, meal planning, food inventory, and grocery shopping. The need grew during Coronavirus disruptions, when empty shelves and shopping limits made planning further ahead more useful.
Reading notes#
- The author made spreadsheets for favorite recipes, monthly meal planning, food inventory, grocery shopping, and price comparison.
- The favorite recipes sheet stores category, recipe name, source URL or binder reference, staple ingredients, other ingredients, prep and cooking time, optional photo, and family rating.
- The meal planner can be used for monthly planning or for weekly planning by using only the first row.
- A detailed meal planner includes breakfast, lunch, dinner, and snacks, and supports multiple lines in a cell with Alt + Enter.
- The food inventory sheet tracks pantry, freezer, and fridge items, and highlights cells blue when quantity drops to 0 or 1.
- The pre-filled grocery list contains more than 220 common items, calculates expected total cost automatically, and can be duplicated for later use.
- A blank grocery list is also included for building a list from scratch.
- The price comparison sheet compares up to 3 shops and highlights the cheapest price for each item, along with the average price.
- The spreadsheets can be used in Microsoft Excel, Google Sheets, and Numbers for Mac, and the post gives steps for opening them in Google Sheets or Numbers.
