Step by step how to exporting data from SAP into an Excel Spreadsheet with screenshot.
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 select
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.
