The lowest price on the shelf is not always the best grocery deal. A larger package can cost more upfront and still be cheaper per item, pound, or ounce. This free Google Sheets grocery price comparison template helps you compare package prices and quantities at three stores.
To find the best grocery deal, divide each store's package price by its package quantity using the same measurement unit. Grocery Tracker 2.0 does this automatically and identifies the lowest valid unit price. You can download a free copy and enter your own prices below.
What Is Included in Grocery Tracker 2.0?
Edit store names in Settings and compare products from up to three stores.
Enter each store's package price and quantity separately.
See the lowest valid price per unit and its store.
Review items compared, best-value store counts, and estimated comparison savings.
The workbook includes four tabs: Dashboard, Price Comparison, Start Here, and Settings. It has room for 100 grocery items, including sample rows you can replace.
How to Use the Free Grocery Price Comparison Spreadsheet
Use the Open Free Google Sheets Template button near the end of this guide. After reviewing the spreadsheet, choose File → Make a copy to save an editable version to your Google Drive.
Go to Settings and replace Walmart, Target, and Costco with stores you actually visit.
In Price Comparison, fill in the item, category, unit, and Need qty. For example, choose ct for eggs and enter 24 if you need two dozen.
Each store has its own Price and Pack qty fields. For example, a 12-count carton and an 18-count carton should have different package quantities. The sheet computes the unit cost independently for each store.
Check Best value store, Best / unit, and the savings columns on the right. Open Dashboard for the summary.
Why Package Size Matters More Than the Sticker Price
Imagine three egg cartons with the following illustrative prices. Each carton contains a different number of eggs:
$3.42 for 12 eggs
$0.285 per egg$4.14 for 18 eggs
$0.230 per egg$6.25 for 24 eggs
$0.260 per eggStore B has the lowest unit price, even though Store A has the cheapest package. This is the difference between comparing shelf prices and comparing true unit costs.
For any one item, use the same unit for every store: ounces with ounces, pounds with pounds, counts with counts. The tracker does not automatically convert pounds to ounces or gallons to fluid ounces. Convert quantities first when stores display different measurement units.
How the Tracker Chooses the Best-Value Store
Grocery Tracker 2.0 divides the package price by its package quantity for each store. Only valid positive numeric prices and package quantities are included in the unit-price comparison. It then selects the lowest available unit price and displays the corresponding store name.
If two stores tie for the lowest price per unit, the template displays the first tied store in its left-to-right store order. A missing store price does not automatically count as a free item.
Understand the Dashboard and Potential Savings
The Dashboard summarizes how many items have comparison results, how many valid store prices have been entered, which store wins the most individual comparisons, and estimated savings. These estimates compare the highest and lowest available unit prices for the quantity you enter as Need qty.
The workbook does not optimize exact package counts or calculate the cost of buying complete packages. It also does not include taxes, loyalty discounts, travel costs, membership fees, or minimum purchase requirements. If an item has fewer than two valid prices, there is no meaningful highest-versus-lowest savings comparison.
Tips for Getting More Useful Results
- Start with groceries you buy regularly instead of tracking every item.
- Compare equivalent products and quality; brand, freshness, and variety can matter.
- Check package quantities carefully, especially for bulk purchases.
- Refresh prices periodically: store prices and specials change.
- Use the results to inform your choice, not as a reason to drive to multiple stores for a tiny saving.
Get Your Free Grocery Price Tracker
You can use the ready-made template without building formulas from scratch. Make your own copy, replace the sample products, and enter prices from your local stores.
Grocery Price Tracker 2.0
Compare prices across three stores using each store's package size, automatically find the best price per unit, and review potential savings on your shopping list.
Open Free Google Sheets Template ↗Preview the template first. To edit your own copy, choose File → Make a copy in Google Sheets.
Enjoyed this free template?
Give this template a heart and follow Egglover Desk for more free tools.
Connecting likes…
Frequently Asked Questions
Yes. You can make a personal copy of the linked Google Sheets template at no charge.
Can I change the three store names?
Yes. Edit the names on the Settings tab.
Can I compare 12-count and 18-count egg cartons?
Yes. Enter each store's different package quantity and use “ct” as the shared unit for that item.
Does the tracker automatically convert ounces to pounds?
No. Convert the values into a consistent unit before entering them.
Does the cheapest unit price always mean the lowest total checkout cost?
No. You may have to purchase a whole package, and promotions, fees, or your actual needed quantity can change the best decision.
Do I need to know spreadsheet formulas?
No. The core price-per-unit and best-value calculations are already included.
Comparing grocery prices is easier when package sizes are accounted for. Grocery Tracker 2.0 gives you a simple way to compare three stores, identify the lowest unit price, and use your own shopping quantities to estimate potential savings.
Last reviewed: October 2026. Template documentation: the included Start Here tab. Prices shown in this article are illustrative, not live store quotes.
More Free Templates from Egglover Desk
Keep organizing your money with these free and beginner-friendly Google Sheets templates.