When exporting data from MPM, you need to specify:
Output format
Output delimiters
Output filename and location
Format file
Export files can be created in several popular formats:
Excel version 5 or 7 format (.XLS)
ASCII text with fields separated by commas (.CSV)
ASCII text with fields separated by tabs (.TXT)
HTML text for use on a web page (.HTM)
User-defined Separated Value (*.EXP)
You can also send the data from an export to the printer or the Report Viewer, where you can manipulate, reorganize, or reformat the data. See Orientation to the Report Viewer Window for more information on how to use the Report Viewer.
The column separation character is inserted between each field in the export file. For example, data exported in CSV (Comma Separated Values) format might look like this:
21-110,102,3,START,0,20080101,N,65,25
If you choose the CSV format, the column separator is a comma. If you choose HTM, XLS or ASCII formats, the column separator is a tab. When using these formats, you cannot change the column separator or the text delimiter.
If you choose the User-defined separators (EXP) format, you can specify the column separator character to be used. You can choose any ASCII character to be the column separator except space. For example, if you enter * as the separator, the data would look like this:
21-110*102*3*START*0*20080101*N*65*25
The text delimiter character is inserted before and after each text field in the export file. For example, if you export with the text delimiter set to quotation marks, the record would look like this:
*21-110*,102,3, *START,FINISH*,0,20080101,N,65,25
The text delimiter is inserted by MPM in case there are delimiting characters used inside the text field (such as the comma inside START,FINISH). For example, if you enter * as the text delimiter (and comma as the column separator), you would see the following:
*21-110*,102,3,*START,FINISH*,0,20080101,N,65,25
You can choose most any ASCII character to be the text delimiter except space. You can only set the Text Delimiter if you choose the EXP format.
Once you have specified all the required options, enter the file name
for the export file being created, and if necessary specify the location
using 
Browse.
Then run the export. If you selected either the output format Printer
or Report Viewer, MPM sends the
exported data directly to the printer or into the Report Viewer instead
of creating an export file. In the Viewer, you can reorganize, reformat,
analyze, or subtotal the data as desired.
Most of the exports require that you specify or create a format file. A format file is a map of the output data. See Using Format Files for details.
Exporting data to .XLS files works well, allowing you to edit the files in Excel. However, after making edits in Excel, you must save the file in .CSV format if you wish to import the data back into MPM. You cannot import a .XLS file directly into MPM.