Manually Converting a Microsoft Money File to Excel
Both Microsoft Money and Microsoft Excel feature import and export functions, and these can be utilised to convert data from one application to the other.
The first step in converting a Microsoft Money file to Excel is to export a report in Money. The report you create should include all of the data you wish to export. Right-click the report and select Export, then select the location you wish to save the file to – select a folder you can easily find, and give the file a meaningful name.
Once complete, you’re ready to move onto the second step – importing the data.
In Excel, create a new workbook, and on the Data menu select Import External Data. Depending on your version of Excel, you will then need to select either Import Data or Import text File.
Use the dialogue box to browse for the export file you created in Money. Once selected, the Text Import Wizard will begin. You will need to follow this to complete the import.
On the first screen, select Delimited - Characters such as commas or tabs separate and then click Next; on the second screen, under Delimiters select Tab, and click Next to progress; finally, click Finish.
Your .MNY file is now ready for use in Microsoft Excel!