Card view in the Excel mobile app shows one row of an Excel table as a single card with a field for each column, so you can fill in an expense without scrolling sideways across a wide grid. It needs your data to be a proper Excel table, and it is a feature of the phone apps rather than the desktop program. Menus move between app versions, so look for the Card View option on the table's tools and confirm in your own app.
What do I need before card view will help?
Card view works on a table, not on loose cells. On a computer, click any cell in your expense list, press Ctrl+T, tick My table has headers and press OK. Keep the columns few and in the order you would answer them: Date, Amount, Category, Paid by, Note. Five fields fit on a phone card comfortably; fifteen do not.
Save the workbook to OneDrive. That is what lets the phone and your computer see the same file, and it saves your entries as you go.
How do I open a table in card view?
- Open the workbook in the Excel app on your phone and go to the sheet with the table.
- Tap a cell inside the table.
- Look for the Card View option on the table's tools; in some versions it is an icon near the table, in others it is under the table options. If you cannot see it, update the app and check again.
- Each card shows the columns of one row. Edit a field, then use the arrows to go to the next or previous row.
- To add an expense, use the new-row control on the card screen, or tap the last row of the table and type below it.
Where is card view available and where is it not?
It is in the Excel apps for phones. I am not aware of a same-named feature on the Windows or Mac desktop programs, and the web version may differ, so test it before you plan a routine around it. On a desktop, Windows Excel has an older Form command that gives a similar one-record-at-a-time screen. It is not on the ribbon by default; add it to the Quick Access Toolbar through Customise, All Commands, Form.
Can I pair it with dropdown columns?
Yes, and that is where the speed comes from. On your computer, select the Category column cells in the table and open Data, Data Validation. Set Allow to List, and type the source as Food,Fuel,Rent,Medical,Travel,Other, or point it to a range of your own categories. Do the same for Paid by with Cash,UPI,Card.
Whether a validation list appears as a dropdown on the card depends on your app version, so try it. If it does not, you still get the benefit of consistent spelling, because a bad entry is refused rather than saved as "Foood". Keep the list short, since every extra option is more thumb work.
| Column | Entry type | Why it helps |
|---|---|---|
| Date | Date, defaulting to today by typing the date | Dates stay real dates, so month totals work |
| Amount | Number only | No rupee sign or commas typed as text |
| Category | Dropdown list | One spelling per category |
| Paid by | Dropdown: Cash, UPI, Card | Cash spends are the ones most likely to be forgotten |
| Note | Free text | Optional; skip it if you are in a hurry |
When does a sheet stop being the right tool?
Card view fixes typing; it does not fix remembering. If most of your spends are card and UPI transactions that already appear on a bank statement, SpendixAI lets you upload that statement as PDF, CSV or Excel and review the rows before saving, and it also lets you add expenses by hand, one or several at once, which suits cash. The same workspace opens on web and mobile.
A quick setup checklist
- Data is a table with a header row.
- Five or six columns, in the order you would answer.
- Dropdowns for Category and Paid by.
- Workbook saved on OneDrive.
- Tested once with a real entry on the phone before you rely on it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


