The simplest Excel Copilot alternative for sorting expenses is a keyword table plus a lookup formula, which works in any recent Excel or Google Sheets and costs nothing extra. Excel Copilot is usually described as a paid AI feature inside Excel for Windows and Mac. If your goal is to label each bank row as Food, Fuel or Rent, a rules table does that predictably, and you can see exactly why every row got its label.
How do you set up the keyword table?
Put your statement in columns A to C: Date in A, Narration in B, Amount in C, with headers in row 1 and data from row 2 to row 500. On a second sheet or in columns E and F, list keywords and categories. For example E2 holds SWIGGY and F2 holds Food; E3 holds IRCTC and F3 holds Travel; E4 holds BESCOM and F4 holds Utilities. Keep keywords short and in the form that appears in your narrations.
Which formula labels each row?
In D2, enter this formula and fill it down to D500:
- =IFERROR(INDEX($F$2:$F$30, MATCH(TRUE, ISNUMBER(SEARCH($E$2:$E$30, B2)), 0)), "Review")
SEARCH looks for each keyword inside the narration, ISNUMBER turns hits into TRUE, MATCH finds the first TRUE and INDEX returns its category. Rows with no match say Review. In Excel 365 and Excel 2021 this works as typed. In older versions, confirm it with Ctrl+Shift+Enter. In Google Sheets, wrap it in ARRAYFORMULA or enter it through the array route.
How do you total by category?
- In H2 type a category name, such as Food.
- In I2 enter =SUMIFS($C$2:$C$500, $D$2:$D$500, H2).
- Add a month filter with a start date in K1 and an end date in K2: =SUMIFS($C$2:$C$500, $D$2:$D$500, H2, $A$2:$A$500, ">="&$K$1, $A$2:$A$500, "<="&$K$2).
- Check that the sum of all category totals plus the Review rows equals SUM($C$2:$C$500).
That last check catches misses. Say Food shows ₹14,200, Travel ₹5,800, Utilities ₹3,100 and Review ₹2,400, and the statement total is ₹25,500. Then 14,200 plus 5,800 is 20,000, plus 3,100 is 23,100, plus 2,400 is 25,500. It ties.
Where does an AI assistant help and where does it not?
An assistant can suggest labels for the Review rows or draft formulas. It can also guess wrongly, so check suggestions against the statement. Verify with Microsoft's own pages what plan and app version you need, what is sent to which service and what it costs today, since none of that is stated here.
When does a sheet stop being enough?
A sheet is fine for one account and a few hundred rows. It gets heavy when you import every month, fix the same merchants again, and also want budgets, receipts and a duplicate-charge check. A tracker like SpendixAI imports PDF, CSV or Excel statements, applies your rules and history first, and uses AI only if you leave it on, with a monthly AI budget if you want one.
Which Excel habits keep the sheet reliable?
- Keep the raw statement on one sheet and never type over it.
- Keep keywords on a separate sheet, one row per keyword.
- Fix the range, such as $A$2:$A$500, and extend it each month.
- Freeze the header row and keep dates as real dates, not text.
When this app is not the right fit
- You enjoy and need full control of every formula and layout.
- You want an AI assistant to write analysis in your own workbook.
- You want a bank link or SMS reading.
A one-hour plan
Build the keyword table with your twenty most common merchants, paste in one statement, and see how many rows say Review. Add keywords until it is under ten percent, then total by category.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


