Show TOC

Procedure documentationExporting to Spreadsheets Locate this document in the navigation structure

 

You can export the list in different formats for spreadsheets. The following list shows the most important of these formats, as well as file name extensions that identify the files:

Format

File name extension

Excel (in MHTML format)

MHTML

Excel (in MHTML format for 2000/97)

MHTML

Star Office (in ODS format 1.0)

ODS

Excel (in Office 2003 XML format)

MHTML

SAP internal XML format

XML

SAP Standard (internal table)

XML

Excel (in previous XXL format)

XLS

Note Note

If a format is not available on your computer, then that entry is not offered. The system administrator can also restrict the list of possible formats or reduce the export to one specific format.

End of the note.

If you export the list on one of these formats, by default a file with the name export is created with the relevant file name extension. The parts of the list that are exported to the file depend on the format:

The data that is exported to the file depends on the format:

  • In MHTML and XML format you export, for example, exactly the data that is displayed in the list on the screen. Column number, selection, and order, as well as the sorting, filtering, and calculations, are included during the export.

  • In Excel XXL format, the functions that you already used on the list are not taken into consideration. The file contains all columns, sorting, filtering, and calculations are ignored.

Prerequisites

A special program is installed in order that you can view the file you created with the export and, if necessary, to process it again.

Procedure

Exporting the List

  1. Choose Export (Export) and the entry Spreadsheet in the selection list. In fullscreen mode, choose   List   Export   Spreadsheet  .

    If you can choose between different formats, the dialog box Select Spreadsheet opens.

  2. On the Select Spreadsheet dialog box, choose the format in which you want to save the exported data.

  3. Confirm your settings.

  4. In the following dialog box, enter the path and name of the file and save the file.

    In some formats you must make more specific entries about the final file.

  5. Enter the necessary settings.

    If a program is installed that is connected with the selected file name extension, this program is started automatically and the file that was created is opened.

Retaining Settings

If you always intended to use the same format for spreadsheets, you can save the settings for the format. In this way you skip the Select Spreadsheet dialog box mentioned above and speed up the exporting of the list.

  1. Proceed as described above in steps 1 and 2.

  2. In dialog box Select Spreadsheet, set the Always Use Selected Format flag.

  3. Confirm your settings and proceed as described above.

    If you export the list as described above in future, you skip the Select Spreadsheet dialog box and jump straight to saving the file.

  4. To be offered the Select Spreadsheet dialog box again during export, choose Spreadsheet in the context menu of the list.

    The dialog box is opened and the Always Use Selected Format flag is not set.