Spreadsheets

Microsoft Forms to Excel: log expenses from your phone

Build a Microsoft Form tied to an Excel workbook in OneDrive to log expenses from your phone, then add a summary tab that reads the responses without editing them.

Editorial illustration for Microsoft Forms to Excel: log expenses from your phone

To log expenses from your phone with Microsoft Forms and Excel, create a form with a date, category, amount and payment mode, then open its responses in Excel. Excel stores them in a workbook in OneDrive, in a table that grows with each submission. Build your totals on a separate summary tab and leave the response table alone.

How do I create the form?

  1. Sign in to Microsoft Forms with your Microsoft account and start a new form named Expense log.
  2. Add a Date question, a Choice question for category, a Text question for amount, and a Choice question for payment mode.
  3. On the amount question, open its settings and turn on Restrictions, choose Number, then a condition such as greater than 0, so a typed word cannot get in.
  4. Mark the first four questions Required. Add an optional Text question for a note.
  5. Keep category names short and spelled exactly as you want them in totals.

There is a second route. In Excel, Insert > Forms > New Form creates a form and a workbook already connected, and the menu names can differ slightly between versions. Either way you end up with a form and an Excel file that fills itself.

How do the responses get into Excel?

In the form, open the Responses tab and choose to open the results in Excel. Excel creates a workbook in your OneDrive. It holds a table with one row per response, and the table grows as each person submits. Besides your questions, the table normally carries columns such as an ID, a start time and a completion time, so check yours.

How do I use it from my phone?

Open the form link in your phone's browser and add it to your home screen from the browser menu, so it opens like an app. For each expense you pick the date, tap a category, type the amount, tap the mode and submit. The Excel table gets the row after a short delay, so you may not see it at once.

How do I build a summary tab on top?

Add a tab named Summary. Excel tables can be referred to by name and column title, so a formula keeps working as rows are added. Click inside the response table and look at Table Design to read its name. Suppose it is Table1 and the columns are Category, Amount and Completion time.

  • Total for one category: =SUMIFS(Table1[Amount], Table1[Category], A2), where A2 holds the category name.
  • Total for a month, with the first of the month in E1: =SUMIFS(Table1[Amount], Table1[Category], A2, Table1[Completion time], ">="&$E$1, Table1[Completion time], "<"&EDATE($E$1, 1))
  • Cash only: =SUMIFS(Table1[Amount], Table1[Mode], "Cash"), with your own column title for the payment mode.

Say E1 holds 1 December 2026 and a category has entries of 350 and 275 in December and 500 in November. The monthly formula returns 625, because the November row falls before the first of the month.

What should I watch for?

IssueWhy it happensWhat to do
Amounts treated as textThe amount question allows anythingUse the Number restriction on the question
The date you chose differs from the submit timeThe table stores both a completion time and your date answerTotal by the date question when it matters, and say so in the sheet
Category count grows messyEdits to choice options after launchAdd a new option, but do not rename an old one mid-month
The workbook is not on your computerIt lives in OneDriveOpen it from OneDrive; a downloaded copy will not update

Who can fill it and who can see the workbook?

A form can be opened by the people you share its link with, and you pick whether they must sign in. The workbook is a different thing: it holds every answer, so share it only with people who should see your spending. Anyone you share the form with does not automatically get the workbook.

What if I want statements and not just manual entries?

A form is good for the cash and small spends you would otherwise forget. The card and UPI debits are already on your bank statement, and typing them again doubles the work. SpendixAI accepts statements as PDF, CSV or Excel and lets you check each row before saving, with manual entries available for cash.

Start-up checklist

  1. Submit a test entry from your phone and find it in the workbook.
  2. Confirm the amount lands as a number.
  3. Check that your summary formula returns the test value.
  4. Delete the test row, and confirm the next submission still lands in the table.
SPENDIXAI JOURNAL

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

Explore your reports