To find which restaurants take most of your delivery money, put your order history or statement rows into a sheet, clean the merchant names so each place appears one way, build a pivot table with merchants as rows and the sum of amount as values, then sort from largest to smallest. The first five rows are your answer.
Where does the data come from?
Check whether your delivery app lets you download or view an order history that lists the restaurant and the amount. If it does, that is the best source because it names the restaurant. If not, your bank or card statement shows the app's name but not always the restaurant, so you would be ranking apps, not places. In that case, use email receipts from the app for the restaurant names.
Step by step in Excel or Google Sheets
- Make a sheet with three columns: Date, Restaurant, Amount. Put a header in the first row and no blank rows inside the data.
- Clean the names. Sort the Restaurant column and make the same place spelled one way, for example the branch name removed.
- Select the data and insert a pivot table. In Excel use Insert then PivotTable. In Google Sheets use Insert then Pivot table.
- Put Restaurant in Rows and Amount in Values, summarised by SUM. Add Amount a second time summarised by COUNT to see the number of orders.
- Sort the Sum of Amount column from largest to smallest and read the first five lines.
If you prefer formulas, list unique restaurant names in a column and use =SUMIF($B$2:$B$500,E2,$C$2:$C$500) beside each, where column E holds the name. Then sort the result.
A made-up result
Say the pivot looks like this for a few months of orders.
| Restaurant | Orders | Total | Average per order |
|---|---|---|---|
| Restaurant A | 9 | ₹3,150 | ₹350 |
| Restaurant B | 7 | ₹2,240 | ₹320 |
| Restaurant C | 6 | ₹1,980 | ₹330 |
| Restaurant D | 5 | ₹1,175 | ₹235 |
| Restaurant E | 4 | ₹1,520 | ₹380 |
These five add up to ₹10,065 (3,150 + 2,240 + 1,980 + 1,175 + 1,520) across 31 orders. If total delivery spend over the same period was ₹18,500, the five places take about 54 per cent of it.
What should you notice?
- Frequency against size: Restaurant E has the fewest orders but the highest average, so it is a treat, while A is a habit.
- A concentration: if a few places take over half the money, a cheaper alternative for those dishes can matter more than cutting every order.
- A long tail: many places with one order each means spend is scattered and a weekly cap is the better tool.
- A name you did not expect in the top five.
Watch for the same kitchen under two names
One restaurant may appear under several spellings, or a single kitchen may run more than one brand on the app. Merge names only when you are sure, since two brands with different menus might be worth seeing separately. Also check that the amounts include fees consistently, because a mix of item totals and bill totals will shuffle the ranking.
Can a tracker do this for you?
If you upload statements, SpendixAI keeps each transaction with its merchant and category, and its Report builder lets you filter and group. You can also add merchant aliases so one place that appears under two names is counted once. It cannot see inside an order, so restaurant names depend on what your statement shows. A sheet with order history is still the way to rank restaurants themselves.
What to do next
Pick one place from the list and decide a rule for it, for example only on Fridays, or a home version of its best dish once a week. Re-run the pivot after a month, and compare the totals.
The exercise takes about half an hour the first time and ten minutes afterwards, once the sheet is set up and you only need to paste the new rows.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


