Data Import & Export

How to Import Microsoft Money Data into Money in Excel

Rana GarciaRana Garcia Nov 3, 2026 871 views

Question details

Users want to transfer historical financial transaction data from Microsoft Money Plus directly into the Money in Excel add-in.

How to Import Microsoft Money Data into Money in Excel
Product
Excel
Device & OS
not provided
Scenario
Transitioning from legacy Microsoft Money Plus software to the newer Money in Excel template for personal finance tracking.
Observed behavior
Money in Excel does not provide a built-in direct migration tool to automatically import data from Microsoft Money Plus.
Before you start

Ensure you have access to your legacy Microsoft Money Plus software to perform a data export before attempting to populate your new Excel template.

Solution 1Recommended

Manually Export and Import via CSV

Since there is no direct migration tool, you need to export your transactions from Microsoft Money to a compatible format like CSV, then clean and import them into Excel manually.

Microsoft has not built a native integration between the discontinued Microsoft Money Plus and the newer Money in Excel template. To preserve your historical data, a manual workaround using Comma Separated Values (CSV) files is required.

1
Export from Microsoft Money Plus

Open Microsoft Money Plus, navigate to 'File' > 'Export', and choose to export your transaction data as a CSV file. Save this file to an easily accessible location on your computer.

2
Open the CSV in Excel

Launch Excel, go to 'File' > 'Open', and select the CSV file you just exported. You may need to change the file type dropdown to 'All Files (*.*)' or 'Text Files (*.prn;*.txt;*.csv)' to see it.

3
Format and Clean the Data

Review the imported data. Remove any unnecessary columns, fix date formats, and ensure the columns match the layout expected by the Money in Excel template.

4
Transfer to Money in Excel

Copy the cleaned rows from your CSV workbook and carefully paste them into the appropriate transaction table within your Money in Excel workbook.

Manually Export and Import via CSV
Feature Requests: If you wish to see a direct import feature in the future, you can submit feedback through the Excel UserVoice page or the Microsoft Feedback Hub.
Free Microsoft Office alternative

Manage Your Financial Spreadsheets with WPS Office

If you are managing complex financial exports from legacy software like Microsoft Money, WPS Spreadsheet provides a free, lightweight, and powerful alternative to Microsoft Excel. It effortlessly handles CSV imports, data cleaning, and advanced financial tracking without the subscription cost.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and click on 'Spreadsheet' to start a new document or open an existing one.
  2. 2. Import Your Data: Go to 'Data' > 'Import Data' to easily bring in your exported CSV files from legacy financial software.
  3. 3. Organize and Track: Use built-in formulas, pivot tables, and chart features to manage your budgets and financial records.
Seamless compatibility with Microsoft Excel (.xlsx) and CSV formats.Completely free with a familiar user interface, requiring zero learning curve.Lightweight design that runs smoothly on all devices, even older computers.Includes hundreds of free personal finance and budgeting templates.
microsoft office alternative - wps office

Frequently Asked Questions

Is Microsoft Money Plus still supported by Microsoft?

No, Microsoft Money Plus was officially discontinued and is no longer supported or updated by Microsoft. This is why newer tools like Money in Excel lack direct integration with it.

Can I import QIF files directly into Money in Excel?

Money in Excel does not natively support importing QIF (Quicken Interchange Format) files. You must first convert the QIF file to a CSV format using a third-party conversion tool before importing it into Excel.

How do I set up a new account in Money in Excel?

To set up Money in Excel, open the template, click on the 'Money in Excel' pane on the right side, and follow the prompts to securely connect your financial institution using the Plaid plugin.