Spreadsheets

Excel on mobile: enter expenses faster with table card view

How to enter expenses faster in the Excel mobile app using a table in card view, where it works, where it does not, and how to set up dropdown columns.

Editorial illustration for Excel on mobile: enter expenses faster with table card view

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?

  1. Open the workbook in the Excel app on your phone and go to the sheet with the table.
  2. Tap a cell inside the table.
  3. 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.
  4. Each card shows the columns of one row. Edit a field, then use the arrows to go to the next or previous row.
  5. 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.

ColumnEntry typeWhy it helps
DateDate, defaulting to today by typing the dateDates stay real dates, so month totals work
AmountNumber onlyNo rupee sign or commas typed as text
CategoryDropdown listOne spelling per category
Paid byDropdown: Cash, UPI, CardCash spends are the ones most likely to be forgotten
NoteFree textOptional; 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports