Skip to content
The title slide and first slides of the Grocery List template

Grocery List

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Bold
Difficulty
Beginner
Updated
November 6, 2026

Every slide (4)

Overview

This template is a shopping list that works out its own costs. The Grocery list tab has one row for each item, with its aisle, quantity and estimated price. The line total is worked out for you, and a tick box marks what is in the basket.

The Dashboard shows the estimated total, the shop budget and what is left, with a chart of cost by aisle. The Shop budget tab holds the amount you plan to spend. It comes with sample data. Make a copy, then replace the sample rows. Formulas, dropdowns and charts update on their own.

Useful for

  • Keeping a weekly shop inside a set budget
  • Shopping in aisle order to save time in the store
  • Comparing the cost of a list before you go

What's included

  • 4 tabs: Dashboard, Grocery list, Shop budget, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Grocery list: a table
  • Shop budget: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Grocery list tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this Grocery List template free?

Yes. Download the template and use it in Google Sheets or Excel at no cost.

Does it work in Excel?

Yes. Download the .xlsx file to open it in Excel. The formulas, dropdowns and charts work in both Excel and Google Sheets.

Are the prices exact?

No. The prices are estimates you type in. Update them from your receipts to make the totals more accurate.

  • #meal-planner
  • #grocery-list
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Business operations

All business operations templates
Get this template

Preparing your template…