An Excel shopping list template is a worksheet for tracking what to buy, how much you need, where to find it, and whether it is already in your cart. In Excel for Microsoft 365 on Windows, create one with columns for category, item, quantity, price, and status; then turn the range into a filterable table and print or use it on your phone.
What an Excel shopping list template does
A shopping list spreadsheet is more than a typed list when it records useful details alongside each item. A basic version might have just an item name and a checkbox or status. A more flexible template can group groceries by aisle, record quantities and preferred brands, estimate the basket total, and distinguish planned purchases from items already bought.
Excel is useful when your list changes from week to week or when you want to sort, filter, copy, or reuse it. Unlike a paper list, a worksheet can keep a recurring pantry list and let you temporarily filter it to show only this week’s items. Unlike a dedicated grocery app, it does not require you to adopt a particular store or list-sharing system. The trade-off is that you must maintain the layout yourself.
There is no single official format that suits every household. A person shopping for one may need a compact list, while someone planning several meals may want quantities, recipes, and a budget estimate. Start with the information you actually use; extra columns are only helpful if you keep them up to date.
Choose columns that match your shopping routine
For a practical grocery template, make one row per item and use clear column headings. A useful starting set is:
- Category: Produce, dairy, pantry, frozen, or another grouping that matches the store.
- Item: The product name, such as apples, oats, or dish soap.
- Quantity: A count, weight, or package quantity, such as 6, 500 g, or 2 bags.
- Unit price: An optional estimated price for one unit or package.
- Line total: An optional estimate for the quantity in that row.
- Status: A simple choice such as To buy or Bought.
- Notes: Optional details such as a preferred brand, size, or substitution.
Keep quantity and unit price separate if you want a meaningful estimate. For example, “2” in Quantity and “3.49” in Unit price is clearer to calculate than typing “2 packs at $3.49” into one cell. If you do not care about estimated spending, omit the price columns and keep the list shorter. A notes column can also hold dietary or package details, but avoid putting essential instructions only in a note if you need to see them at a glance.
Build the template in Excel for Microsoft 365
In a blank workbook, enter the headings in row 1, starting in cell A1. For example, use Category, Item, Quantity, Unit price, Line total, Status, and Notes. Add a few example rows, then replace them with your own items. Leaving a number of blank rows is not necessary if you make the range an Excel table: the table can expand as you add new entries.
- Select the headings and any sample rows, then choose Insert > Table.
- Confirm the selected range and check My table has headers, then select OK.
- Use the table’s filter buttons to show one category or status at a time. You can sort the Category column to group similar items.
- Adjust column widths by dragging the boundary between column letters. Make Item and Notes wide enough to read without making every column unnecessarily large.
- Use View > Freeze Panes > Freeze Top Row if the list is long and you want the headings to remain visible while scrolling.
Tables provide filter controls and extend their formatting when rows are added. They also make it easier to keep the header row distinct from the data. On Excel for Mac, the ribbon names and table creation process are similar, although the exact placement of controls can vary slightly by release. Excel for the web also supports tables, but some desktop print and formatting controls may be arranged differently.
Add a status dropdown instead of a complicated checkbox
A status column makes it possible to mark items Bought while shopping and filter them away later. In Microsoft 365 for Windows, select the cells in the Status column, choose Data > Data Validation, select List as the validation type, and enter To buy,Bought as the source. Confirm the dialog. The selected cells will offer those choices, helping prevent variations such as “done,” “bought,” and “purchased” from being treated as different statuses.
In Excel for Mac, Data Validation is also available from the Data tab, though dialog wording or placement can differ by version. Some current Microsoft 365 releases also offer in-cell checkboxes from Insert > Checkbox. That feature’s availability can depend on the Excel version and update channel, so a dropdown is a straightforward fallback if the command is missing or if text status values are easier to filter.
Choose one approach rather than adding both a checkbox and a status field unless you have a specific reason. Two ways to record the same state create extra work and can disagree. If several people will edit the list, simple labels are often easier to understand than a visual mark with no explanation.
Calculate estimated costs with simple formulas
Cost columns are optional, but they can help compare a planned basket with a spending limit. Enter prices as numbers and format the relevant cells as currency using Home > Number options. Do not include a currency symbol as part of text you intend to calculate; use number formatting instead. Treat the result as an estimate because package sizes, discounts, taxes, and shelf prices may differ from what you entered.
With Quantity in C, Unit price in D, and Line total in E, enter this in E2: =C2*D2. If C2 contains 2 and D2 contains 3.49, the result is 6.98. Copy the formula down the Line total column for other rows. Keep quantities numeric for multiplication; a value such as “2 bags” is text and will not work as a number in this calculation.
With estimated line totals in E2:E20, enter =SUM(E2:E20) in a cell below the list to add them. For example, if E2 is 6.98 and E3 is 2.49 and the remaining cells are blank, the result is 9.47. Update the range if your list extends beyond row 20. Blank cells are ignored by SUM, but a text entry in the cost range will not be added as a numeric price.
Excel tables can make formulas more convenient as a list grows, but ordinary cell references are easy to inspect and work in a simple template. If you insert a total row inside the table, it may be included in sorting or filtering; place the total outside the item rows or use the table’s built-in Total Row option instead.
Choose or customize a template
A preformatted template can save time, but inspect its columns before relying on it. Some templates are designed for meal planning, inventory, or household budgets and may include fields that are irrelevant to a shopping trip. In Excel, available starter templates can vary by version, account, and connection. You can use a blank workbook and the steps above if you do not see one that fits.
Choose the simplest layout that answers the questions you ask in the store. A category column is valuable if you shop by aisle; a store column can help if you make one list for several shops. A Recipe or Meal column is useful when ingredients are tied to planned meals, but may clutter a quick restocking list. If you shop at different locations, filtering by store can separate items without maintaining multiple workbooks.
For a reusable weekly list, keep recurring staples in a separate sheet called Pantry or Regular Items, and copy only what is needed into the current trip list. Do not assume an item should be purchased just because it appears on a recurring list: check stock at home first. A date or Trip column can distinguish separate shopping runs if you keep a history, but remove old rows from the active view so the current list stays clear.
Make the list readable on screen and on paper
Use bold, contrasting headings and a consistent number format, but keep decoration restrained. A large title, merged cells, and many colors can take space away from the actual list and may make filtering or copying less convenient. Conditional formatting is optional; the Status dropdown is often enough to identify what remains to buy. If you do use colors, do not rely on color alone to communicate meaning.
For printing in Excel for Windows, select the relevant cells and choose Page Layout > Print Area > Set Print Area. Use Page Layout > Orientation to choose Portrait or Landscape, and review the print preview before printing. If the list spans pages, Page Layout > Print Titles can repeat the header row on each printed page. Keep the print area limited to the useful columns so notes or blank worksheet space do not create extra pages.
On Mac, the Page Layout tab also contains page setup and print-area controls, though print dialogs and command placement can differ from Windows. In Excel for the web, printing is available, but detailed page setup may be more limited than in the desktop app. If a list is too wide, hide columns you do not need for the trip or make a separate print-friendly sheet rather than shrinking the text until it is difficult to read.
Common problems and practical fixes
- Items appear out of order: Sort or filter the table by Category, but make sure you sort the whole table rather than one column alone. Sorting only Item can detach names from their quantities and notes.
- Formula results look wrong: Check that quantity and price cells contain numbers, not text with units or currency symbols typed into them. Confirm that the formula refers to the intended row.
- New rows lack formatting: Add them directly below the Excel table so it can expand, rather than typing far below the table in an unrelated range.
- Printed text is tiny: Reduce unnecessary columns or use landscape orientation before scaling the entire sheet to fit one page. Readability is more useful than forcing a wide worksheet onto a single sheet of paper.
- The list has duplicate items: Decide whether different sizes, flavors, or stores count as separate products. Include those distinctions in the Item or Notes field so you do not accidentally merge purchases that are not interchangeable.
A common misconception is that a spreadsheet will automatically know what is in your pantry or the current price at a store. It will only calculate or filter information you enter. Treat inventory and costs as user-maintained estimates, and verify quantities and prices when accuracy matters.
Sharing and alternatives
A workbook can be stored in OneDrive or SharePoint and shared with other people using Excel’s sharing controls, subject to the account and organization settings. Shared editing is useful for a household list, but agree on simple conventions first: who removes bought items, whether completed items remain visible, and how to handle edits during a shopping trip. Saving a separate copy for each week can preserve a record without making the active list unwieldy.
Excel may be more structure than you need for a short list. A notes app or paper is quicker for a few items, while a grocery-list app may offer features such as barcode entry or store-specific organization that a plain worksheet does not. A spreadsheet is a good fit when you value a customizable format, reusable categories, printable lists, or cost estimates. The best option is the one people who shop with the list will reliably update.
Frequently Asked Questions
How do I make a simple shopping list in Excel?
Enter Item, Quantity, and Status as headers in row 1, add one product per row, and use Insert > Table to make the list sortable and filterable. Add categories or prices only if you need them.
Can Excel add up the cost of my shopping list?
Yes. Put numeric quantities and unit prices in separate columns, calculate each line total by multiplying them, and use SUM to add the line totals. The result is an estimate based on the prices and quantities you entered.
Can I check off items in Excel?
Use a Status dropdown with values such as To buy and Bought. Some Microsoft 365 versions also provide in-cell checkboxes through Insert > Checkbox; use the dropdown if that feature is unavailable.
How do I print an Excel shopping list on one page?
Set a print area, choose an appropriate orientation, and check print preview. If the list is too wide or long, remove unnecessary columns or use more than one page rather than making the text unreadably small.
Can I reuse the same Excel list every week?
Yes. Keep a separate master list of regular items, then copy the items needed for the current trip into the active list. Check your supplies before copying so the template does not turn into an automatic order.
Related
- Excel Quick Border: Add Cell Borders Fast in Microsoft 365
- Excel Print Zoom to Fit Page: Setup and Common Fixes
- Excel Print: Keep Row and Column Headers on Every Page
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Turn Off Flash Fill in Excel (and Keep Manual Fill)Yes. In Excel for Microsoft 365 on Windows, go to File > Options > Advanced, clear Automatically Flash…
- ISNUMBER in Excel: What It Checks and How to Use ItIn Excel, ISNUMBER checks whether a value is stored as a number and returns either TRUE or FALSE.…
- Conditional Formatting: Apply Rules to Entire RowsYes. In Microsoft Excel for Microsoft 365 on Windows, conditional formatting can highlight an entire row when a…
- Excel Scatter Plot: How to Create, Format, and Read ItTo make a scatter plot in Excel for Microsoft 365 on Windows, place your X values in one…
- How to Hide a Text Box Border in Excel Without Deleting ItTo hide a text box border in Excel for Microsoft 365 on Windows, select the text box, open…
- Consolidate Data in Excel: Methods and StepsTo consolidate data in Excel for Microsoft 365 on Windows, choose Data > Consolidate, select a summary function…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.