How to Convert MS Money to MS Excel

MS Money is personal finance software and MS Excel is a spreadsheet that can store numerical data. MS Money saves data in .MNY files, while MS Excel saves data in .XLS files. MS Money files must be converted in order to be opened by MS Excel. The conversion process can be easily done by saving the data from MS Money in text format.

Instructions

1. Launch Money and open the report that you wish to convert. The process should proceed from the "Money Reports" area.

2. Click the "Export" menu, and indicate the file name and location to save the data.

3. Launch Excel, and open a new workbook.

4. If you are using Excel 97 or earlier, click the "File" menu and select the "Open" menu. If you are using Excel 2000, click "Import External Data" on the "Data" menu, and then "Import Text File." If you are using Excel 2002 or later, click the "Data" menu, click "Import External Data," and then select "Import Data."

5. Locate the text file that you have saved through Money, and click "Import."

6. A "Text Import Wizard" will appear. Click the "Delimited - Characters such as commas or tabs separate each field" box, and click "Next."

7. Click the "Tab" box under "Delimiters" and click "Next."

8. Click "Finish." The data from Money should be displayed in a spreadsheet.

9. Click the "File" menu and select "Save" to save the information as an .XLS file.

References

• Microsoft Support