Convert Microsoft Money Transactions for the Money in Excel Template
Question details
The user wants to transfer transactions from an old Microsoft Money file into the Money in Excel template.
- Product
- Microsoft Money and Money in Excel
- Device & OS
- not provided
- Scenario
- The user wants to continue reviewing historical financial transactions in an Excel workbook.
- Observed behavior
- Microsoft Money is discontinued, and Excel does not provide a direct migration tool for importing its files into the Money in Excel template.
Check that Microsoft Money can still open the original file and identify the accounts you want to export. Money in Excel was discontinued on June 30, 2023, so its connected services no longer work.
Export Microsoft Money transactions and prepare them in Excel
Use this approach to preserve and review historical transactions in a spreadsheet, even though Money in Excel can no longer connect to financial institutions.
Microsoft Money commonly exports transactions as QIF files, which Excel does not directly import as a structured transaction table. If your version offers CSV export, use it; otherwise, convert the QIF export to CSV with a trusted tool.
The retired Money in Excel template may not accept pasted transactions in its original connected-data tables. You can keep the prepared transactions on a separate worksheet instead; this does not restore the template's connected features.
Open the file in Microsoft Money, choose File > Export, and follow the prompts to export an account. Repeat for each account you need, noting which export belongs to which account.
If the export is a QIF file, use a reputable QIF-to-CSV converter to create a CSV file. Research the tool before downloading it, and check how it handles financial data.
In Excel, choose Data > From Text/CSV, select the exported or converted CSV file, preview the columns, and select Load. Import each account file as needed.
In the imported worksheet, label or arrange columns for dates, descriptions, categories, account names, and amounts. Add an account-name column if the export does not include one.
Compare the worksheet with Microsoft Money, checking dates, categories, transfers, amount signs, and account totals. If you have the old Money in Excel workbook, copy the reviewed table to a separate worksheet in that workbook.

Review exported Money transactions in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and organizing converted transaction files. Its Excel format compatibility makes it easy to move your spreadsheet data between applications, though it cannot restore the discontinued Money in Excel service.

Frequently Asked Questions
Can I import a Microsoft Money file directly into Money in Excel?
No direct migration tool is available. Export the transactions from Microsoft Money, convert them to CSV if necessary, and import the CSV into Excel using Data > From Text/CSV.
Can Money in Excel still connect to my bank?
No. Microsoft discontinued Money in Excel on June 30, 2023, and its connected services no longer work. Historical transactions can still be reviewed in a separate spreadsheet.
What should I do if Microsoft Money exports a QIF file?
Convert the QIF file to CSV with a reputable tool, then use Excel's Data > From Text/CSV command to load it. Review the converter's privacy practices before sharing financial data.
Will exported transactions reproduce my account balances exactly?
Not necessarily. An export may omit opening balances or other details. Compare transaction totals and transfers with the original accounts in Microsoft Money.




