Free online tool · Food & Entertaining
Grocery List Generator & Merger
Combine duplicate rows and sort the list by aisle.
FreeNo sign-upRuns in your browserExportable results
Your inputs
Change any value — everything below recalculates immediately in this tab.
Saved on this device
Items to buy
| Item | Qty | Unit | Aisle | Remove |
|---|---|---|---|---|
Duplicate items with the same unit and aisle are merged into one line.
Unique lines3after merging
Input rows4as entered
Aisles2shopping zones
Manual checks0missing quantities
Sorted shopping list
| Aisle | Item | Qty | Unit | Merged |
|---|---|---|---|---|
| Dairy & eggs | Eggs | 6 | pcs | — |
| Pantry | Olive oil | 1 | bottle | — |
| Pantry | Pasta | 3 | pack | 2 rows merged |
Rules
- Merge key = item + unit + aisle, all compared case-insensitively. Change any of the three to keep a separate line.
- Rows with no quantity are counted as manual checks rather than silently dropped.
All results are calculated from the values above using the documented rules. Nothing is uploaded, and there is no AI model behind this tool.
How this tool works
- The merge key is item + unit + aisle, compared case-insensitively.
- Quantities are summed as plain numbers; no unit conversion is attempted.
- Rows with a missing or non-positive quantity are counted as manual checks instead of being dropped.
Read the full guides
The step-by-step guides behind this tool, from the Howcompass library.
Questions & answers
Can it convert cups to grams?
No. Use the Recipe Scaler & Kitchen Converter for unit conversions, and put the resulting unit into this list.
How do I keep two identical items separate?
Give them a different unit or aisle — the merge key includes both.
Does it know store aisles?
No. The aisle is whatever label you type, so the list matches the shop you actually use.
Privacy & limits
Your list stays in this browser tab. Nothing is uploaded.
Tools are added in batches and every tool links to real guides in our library. Browse all free tools.