Data Import & Export

Convert Microsoft Money Transactions for the Money in Excel Template

Amos GikundaAmos Gikunda Nov 13, 2026 871 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Export an account

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.

2
Convert QIF if needed

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.

3
Import the CSV into Excel

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.

4
Organize the transactions

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.

5
Review the results

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.

Export Microsoft Money transactions and prepare them in Excel
Balances may need separate checking: Transaction exports may not include opening balances or all account details. Compare totals with the original accounts rather than assuming the imported data recreates every balance.
Free Microsoft Office alternative

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.

Open CSV transaction exports and organize dates, categories, and amounts.Work with Microsoft Excel XLS and XLSX formats.Use a familiar spreadsheet interface to ease the move from Excel.Get a free, lightweight Office alternative.
microsoft office alternative - wps office

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.