SHOPLIX: Grocery List Template for Google Sheets

Shoplix is a grocery list with a calculator built in. Every line multiplies quantity by estimated price, the estimated total runs against the budget you set, and an aisle column keeps the list in the same order as the store. By the time you grab a cart, you already know roughly what the register will say.

Inside the grocery list template

The Grocery List tab opens with the money: a budget cell you set, an estimated total the sheet computes, and the balance between the two, which turns red the moment the list outgrows the budget. The table below has seven columns: Aisle, Item, Qty, Unit price, Est. cost, In cart and Notes. Est. cost is the only formula you'll see in the row, a simple quantity-times-price that stays blank until both numbers exist. The aisle dropdown draws from the Lists tab, which ships with nine store sections (produce, bakery, dairy, meat and fish, frozen, pantry, drinks, household, personal care), all editable to match how your supermarket is actually laid out. A counter tracks how many items are already in the cart, and each In cart mark turns its row green.

How to use this grocery list in Google Sheets

Open the XLSX in Google Sheets (the import guide explains the three ways), set your budget, and write the list: item, aisle, quantity, and a rough unit price. Prices don't need to be exact — close is enough for the total to be useful. Sort the table by the Aisle column before leaving and the list walks the store in order. While shopping, mark In cart as things land in the basket; the green rows shrink the remaining list at a glance. The sample file carries a small budget and fourteen everyday items so the formulas and the formats are visible from the first open.

A shopping list template that adds up before checkout

The quiet win of a priced shopping list is the conversation it forces while you're still at the kitchen table: if the balance goes negative, something gets crossed off now, not at the register. Over the weeks, the unit prices you've already typed become your own reference list — you start noticing when the usual coffee quietly costs more.

The grocery list in 12 languages

Shoplix is published in twelve languages, each download with aisles, labels and sample items translated and the currency formatted for that locale. It works best downstream of a plan: decide the week's dinners in the weekly meal plan template, carry the ingredients over, and browse the rest of the meal planning templates for the surrounding pieces.