Loading...
Build a shopping list grouped by aisle and download it as a printable spreadsheet with a running total.
A grocery list template is a reusable structure for a shopping list: what to buy, how much of it, and which part of the shop it comes from. Grouping by section is what turns a list of items into a route, so you walk the shop once rather than crossing it repeatedly.
Sections you have not used are left out, so a short list stays short.
One spreadsheet, two sheets, already grouped and ready to print. Nothing you type is sent to a server.
1. Shopping list
One row per item with a tick column, quantity and estimated price, grouped under a heading for each section of the shop.
2. By section
How many items and how much estimated spend sits in each part of the shop, which is where an unexpected total usually comes from.
The estimated total is a live SUM rather than a typed number, so deleting a row you decided against updates it instead of leaving a figure that is quietly wrong.
Excel
Double click the download. If Excel shows a yellow protected view bar, click Enable Editing so the formulas calculate.
Google Sheets
Upload it to Drive and open it, or use File then Import then Upload inside an existing sheet. Formatting and formulas both carry across.
Numbers on a Mac
Open it directly. Numbers converts the workbook and keeps the totals working, though the yellow header fill may shift slightly.
Formula
list = items grouped by section, sections ordered by the route through the shopsection = the department an item lives in. The one field most templates omit and the one that saves the walking
route order = produce at the entrance, edges for fresh, middle for packaged, frozen last so nothing thaws
quantity = written as you buy it, so 200 g and 1 bunch rather than a bare number that means nothing at the shelf
estimated price = optional. Worth the effort only if you are shopping to a budget, since it is a number you have to maintain
Worked Example
Ten items, written in the order they were thought of
Did you know? Supermarket layouts are deliberate: staples like milk, bread and eggs are usually placed far apart and away from the entrance, so reaching all three walks you past most of the shop. A list sorted by section is the simplest defence against a floor plan designed to keep you in it.
Build a chore chart that rotates automatically and shows how many turns each person gets.
Build a cleaning rota from how often each job is really needed, spread over four weeks so no day is overloaded.
Set a countdown with start/pause/reset and audio alert. Quick presets included.
Generate formatted standup updates with yesterday, today, and blockers for async teams.
Write up a standup and download a Word file that opens in Google Docs, filled in.
Sort tasks by urgency and importance into four action quadrants.