Is the larger grocery package really the better deal?
A lower shelf price doesn't always mean a lower price for the amount you get.
When products come in different sizes, weights, and volumes, you need to compare their price per unit rather than just their package prices.
This free price per unit calculator for Google Sheets helps you compare groceries and household products using consistent measurements.
You can calculate prices per 100 grams, 100 milliliters, or individual item with automatic formulas.
To find the unit price, divide a product's package price by its quantity. Convert different units to the same measurement before comparing them. Our free spreadsheet automatically converts supported units and identifies the lowest unit price among matching products.
What Is a Price Per Unit Calculator?
A price per unit calculator shows how much you pay for a standardized amount of a product.
For groceries, this may be the price per 100 grams, 100 milliliters, or single item.
This makes it easier to compare packages with different quantities.
What's Included in the Free Calculator?
The template includes two worksheets: Unit Price Calculator and Start Here.
| Feature | What It Does |
|---|---|
| Product name | Groups matching products for comparison |
| Store | Records where each product is sold |
| Package price | Records the total selling price |
| Package quantity | Records the product's weight, volume, or count |
| Unit conversion | Converts supported units into grams, milliliters, or item counts |
| Normalized unit price | Calculates prices per 100g, 100ml, or item |
| Lowest price indicator | Highlights the lowest normalized price for matching products |
| Sample data | Includes rice, yogurt, dish soap, and eggs |
Example: Which Grocery Package Is Cheaper?
Imagine you're comparing the same brand and type of rice at two stores.
Store A sells a 2-pound package for $5.49. Store B sells a 1-kilogram package for $5.95.
Looking only at the package prices, Store A seems cheaper.
But the packages contain different amounts.
$0.605 per 100g
$0.595 per 100g
Result: Store B offers the lower price per 100 grams, even though its package costs more.
Example prices are illustrative and do not represent live grocery prices.
Package prices can be misleading when quantities differ. Comparing prices per equal measurement helps reveal the actual cost difference.
Why Bigger Packages Aren't Always Cheaper
Bulk packages can sometimes offer a lower price per unit. However, this is not guaranteed.
Discounts, different brands, product quality, and store pricing all affect value.
It's also important to consider whether you can use the entire package before the product expires.
Free Price Per Unit Calculator Download
Free Google Sheets Unit Price Calculator
Compare groceries, household products, and package sizes with automatic unit conversion and price calculations.
⬇ Open Free Unit Price CalculatorFree Google Sheets-compatible spreadsheet template. Open the file and make your own copy before entering data.
How to Use the Price Per Unit Calculator
Click the green button above to access the spreadsheet.
In Google Sheets, choose File > Make a copy when available. If it opens as an Excel workbook, download the .xlsx file or save it as a Google Sheets file.
Use the same name for equivalent products that you want to compare.
Enter the store name and the total price for the package.
Type the quantity printed on the package and choose its measurement unit.
The calculator converts the measurements and calculates a normalized price per 100g, 100ml, or item.
The Best price? column marks the lowest normalized price among matching product names and measurement types.
Use identical product names for packages you want compared. For example, enter "Rice - same brand" for both store listings.
Different product names will be treated as separate comparison groups.
Supported Measurement Units
The calculator supports common weight, volume, and count measurements.
| Type | Supported Units | Comparison Basis |
|---|---|---|
| Weight | g, kg, oz, lb | Price per 100g |
| Volume | ml, L, US fl oz | Price per 100ml |
| Count | item | Price per item |
Weight and volume are different measurement categories. Do not compare 100g directly with 100ml unless you have a reliable product-specific density conversion.
The workbook uses US fluid ounces for liquid volume and regular ounces for weight.
How to Calculate Price Per Unit
The basic calculation is:
To compare different packages, convert their quantities to the same measurement first.
Example: Price Per 100 Grams
A 1kg package of rice costs $5.95.
Since 1kg equals 1,000 grams:
$5.95 ÷ 1,000 × 100 = $0.595 per 100g.
Example: Price Per Item
A carton of 12 eggs costs $3.60.
$3.60 ÷ 12 = $0.30 per egg.
Example: Price Per 100 Milliliters
A 1.2-liter bottle of dish soap costs $7.25.
1.2 liters equals 1,200 milliliters.
$7.25 ÷ 1,200 × 100 = approximately $0.604 per 100ml.
When Should You Use a Unit Price Calculator?
Unit Price Calculator vs. Grocery Price Tracker
Both spreadsheets help with grocery budgeting, but they serve different purposes.
| Tool | Best Use |
|---|---|
| Price Per Unit Calculator | Compare prices for different package sizes using matching units |
| Grocery Price Tracker | Record and compare grocery prices across stores |
| Meal Cost Calculator | Calculate the cost of ingredients used in a recipe |
For more effective grocery planning, you can use these tools together.
Start by comparing prices between stores. Then check the unit price to find the better package value.
Finally, use a meal cost calculator to work out the actual ingredient cost of your recipe.
Common Mistakes When Comparing Unit Prices
1. Comparing Different Product Types
Make sure the products are equivalent in type, quality, and purpose.
2. Mixing Weight and Volume
A gram measures weight, while a milliliter measures volume. These units are not automatically equivalent.
3. Ignoring Discounts
Use the actual price you expect to pay, including discounts that apply to your purchase.
4. Assuming Bulk Is Always Better
Large packages may offer a lower unit price, but storage space, shelf life, and potential waste also matter.
5. Using Different Product Names
The spreadsheet groups matching products by name. Use consistent names for correct automatic comparisons.
Frequently Asked Questions
Divide the package price by its quantity. Convert different package sizes into matching units first.
Yes. The shared spreadsheet is provided as a free template.
Yes. It uses spreadsheet formulas compatible with Google Sheets.
Yes. The calculator converts supported weight units into grams for comparison.
Yes. It supports liters, milliliters, and US fluid ounces.
Yes. Select the item unit to calculate the cost per item.
Yes. It marks the lowest normalized price among matching product names and measurement types.
Yes. Comparing unit prices can help you determine whether a larger package offers better value.
The included workbook provides 40 input rows.
No. Enter your own prices. The included examples are for illustration.
More Free Templates From Egglover Desk
Ready to Compare Grocery Unit Prices?
Open the free spreadsheet to compare package sizes, calculate unit prices, and identify the better-value options.
⬇ Get the Free Unit Price CalculatorGoogle Sheets-compatible spreadsheet. Create your own copy before editing.
The cheapest-looking package isn't always the best value. Compare price per 100 grams, 100 milliliters, or item to make more informed shopping decisions. Our free spreadsheet does the calculations for you.
Egglover Desk · November 2026. Example prices are for demonstration only.