Microsoft KB Archive/302382

= Money: How to Export a Money Report to an Excel Worksheet =

Article ID: 302382

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Money 2004 Deluxe Edition
 * Microsoft Money 2003 Deluxe Edition
 * Microsoft Money 2002 Deluxe Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Money 2001 Standard Edition
 * Microsoft Money 2000 Standard Edition
 * Microsoft Money 99 Standard Edition
 * Microsoft Money 98 Standard Edition
 * Microsoft Money 97 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Money 2000 Business & Personal Edition

-



This article was previously published under Q302382



SUMMARY
This article describes how to export a Microsoft Money report to a Microsoft Excel worksheet.



MORE INFORMATION
Microsoft Money offers many different reports that you can use to track your finances. When you export a report from Money, it is saved as a tab-delimited text file. That is, the columns of the report are separated by tabs. After you export a report, you can open and work with it in another program, such as a word processing, spreadsheet, or tax preparation program.

To export a Money report to Excel, you must export the report to a text file, and then import the file into an Excel worksheet. To do this, follow these steps.

NOTE: Money reports may contain some extra information that Excel does not recognize.

Step 1: Export a Money Report to a Text File

 * 1) Start Money, and then open the report that you want to export.
 * 2) If you are running Money 97, click Export.

If you are running Money 98 or later, right-click the report, and then click Export.
 * 1) In the Export Report dialog box, specify a location where you want to save the file. In the File name box, type a name for the file, and then click OK.

Step 2: Import the Text File to an Excel Worksheet

 * 1) Start Excel, and then open a new workbook.
 * 2) If you are running Microsoft Excel 97 or earlier, click Open on the File menu.

If you are running Microsoft Excel 2000, point to Import External Data on the Data menu, and then click Import Text File.

If you are running Microsoft Excel 2002, point to Import External Data on the Data menu, and then click Import Data.
 * 1) In the Look in box, locate the drive, folder, or Internet location that contains the report file that you just exported and saved, and then click Import.
 * 2) In the Text Import Wizard – Step 1 of 3 dialog box, click Delimited - Characters such as commas or tabs separate each field, and then click Next.
 * 3) In the Text Import Wizard – Step 2 of 3 dialog box, under Delimiters, click to select the Tab check box, and then click Next.
 * 4) In the Text Import Wizard – Step 3 of 3 dialog box, click Finish.
 * 5) In the Import Data dialog box, choose where you want to put the data, and then click OK.

Additional query words: Money98 Money99 Money2000 Money2001 Money2002 Money2003 Money2004

Keywords: kbinfo KB302382

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.