How Do You Convert the Microsoft Money Files to the Microsoft Excel Files?

Microsoft Money is a program that was used by many people in the past to manage their personal or family finances. However, since Microsoft stopped creating new versions of this program in November of 2010, users have to adjust accordingly by switching to Microsoft Excel files. You can still get the files you created in that platform although it is no longer being updated. One thing with Microsoft Money is that it would allow you to export your finalized data or information into a spreadsheet.

However, you need to know the steps you follow to convert the Microsoft Money files and turn them into Microsoft Excel files.

• First, you need to input the budget and money spending information right into the Microsoft Money. This will cover the entire period which you used the program in managing your personal finances.
• Second, you create a report in the Microsoft Money, and this is done by right-clicking on the file name within the file directory. After that, you pres “Export” in order to create a text document. You then save the information to a separate file right within the directory.
• The other step is that you get out of this file and then call up the Microsoft Excel program you are using. By simply selecting the file and then pressing “Open” you will be able to pull in the resulting text file right into your Microsoft Excel format.
• Access the second line that is found near the bottom of that Window, and then go to “File” and navigate to “Save As” in order to save your file into Excel.
• After that, select the line which says “Save As Type” and this will allow you to pick the version of Excel you want to use from the choices offered. Now select” Data” and then press “Import External Data”. By doing this, you will open up "Text Import Wizard." At this stage, you will need to save your file as "Delimited Text."
• After you have saved the file, you can view the resulting file in order to see how it has been transferred. At times, when you transfer a text file to Excel, it may not bring out all of the formatting the same way. For example, text files may not often paste into same columns meaning that they could be found in one giant sentence or a paragraph.
• If there is any formatting you need to make, you can make the chances while you are viewing the file on the screen. You may want to separate the data into columns, cells, and rows in order to suit your needs and formatting style.

The other method is that, you may choose a file from where you need information without the need for converting it. You achieve this by going to Microsoft Money, and then opening the file in "Report View." Using your mouse, you highlight the cells which you need to copy and then right-click on the mouse and choose to copy data. Now you right-click again when in the new Microsoft Excel workbook and choose “Paste”. Your copied text will then appear.

Any of these two methods are important if you are doing some sort of bookkeeping for another person.