KEMBAR78
Export SAP Data to Excel Guide | PDF
Scribd
Upload
180 views3 pages

Export SAP Data to Excel Guide

The document provides new steps for exporting data from SAP to Excel. After generating a report, users must select the Spreadsheet option from a drop-down menu and then choose Excel (In Existing XXL Format). The data will then be exported to an Excel spreadsheet where it can be saved.

Uploaded by

templove123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
180 views3 pages

Export SAP Data to Excel Guide

The document provides new steps for exporting data from SAP to Excel. After generating a report, users must select the Spreadsheet option from a drop-down menu and then choose Excel (In Existing XXL Format). The data will then be exported to an Excel spreadsheet where it can be saved.

Uploaded by

templove123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

How to export data from SAP to Excel Issued 8/31/07

To follow are new steps that you must use when exporting data from SAP into an Excel
Spreadsheet.

After generating the report, click . The drop-down list will display several options.

After selecting the option for Spreadsheet, the Select Spreadsheet pop-up box appears.

Click and from the drop down, select Excel (In Existing XXL
Format).

Click check box IF you would like this to be your


default.

Click displays the following message to indicate that any data manipulation; sorts, filters,
totals, etc., will not be exported to the spreadsheet.
Click . The Export list object to XXL pop-up box appears.

Select Table from the Export list object to XXL pop-up box to display Excel spreadsheet
or Pivot table to display Excel Spreadsheet Pivot table.

Click . Export list objects to XXL pop-up box appears, confirming Excel.

Click . Excel will open and display the data from the report in the spreadsheet format you
selected. The Information pop-up box appears with the message Save the data in the
spreadsheet. Select Microsoft Excel from your task bar and save your spreadsheet.

If you do not save your report in Excel prior to clicking the in the Information pop-up box,
the exported data will not be saved.
Click to return to the report screen.

You might also like