How to Export Data from SAP to Excel

Learning how to export data from SAP to Excel is a helpful skill to have for all users of SAP.  If you have been having problems with exporting data from SAP to Excel, then you should know that there are a number of ways to perform this.

How to Export Data from SAP to Excel

Exporting Data: Option 1

  • The first thing is to click on the list menu. Once you do that, you should select the Export option and then the Spreadsheet option. This option works when you are in the full-screen mode where the SAP screen is displaying returned data lists.
  • If you have more than one format available with regard to the spreadsheets, then you will see the Select Spreadsheet option open up.
  • Since there are many ways of saving the spreadsheets, you should specify the format, which you prefer on the dialogue box list.
  • Once you select your preferred format, you need to confirm the new settings.
  • You will have to state the name and path of the file you are dealing with then save the changes.
  • At times, you will also be required to make the relevant settings. The program linked to the selected extension on the file name will then open the file you generate after you have completed the exporting process.

Exporting Data: Option 2

  •  You can use the icon for exporting as a shortcut.
  • All you have to do is to click on the exporting icon, which is an arrow pointing to the right, then select the spreadsheet button. Once that happens, your SAP data will be exported to Excel without a problem.

Exporting Data: Option 3

  •  You can make use of the right clicking option to export data from SAP to Excel.
  • Once you have determined the data that you want to export, you need to place your cursor within that data. It does not matter where the cursor lies as long as it is within that data displayed on the screen.
  • You should right click using your mouse, after which you will have access to a drop-down menu. You can then select the spreadsheet option and export that SAP data to Excel.

Setting Excel as the Default Option

If you are not interested in having to follow the lengthy processes when exporting SAP data to Excel, then there are things that you can do to make the process much easier on you. Some of them are outlined below.

  •  In the case of Exporting Data I, you can still use the List>Expert> Spreadsheet option. However, when the Select Spreadsheet dialogue box comes up, you should select the Always use Selected Format option. Once you confirm the settings, you can proceed as usual. Anytime you expert SAP data after that, it will be exported to the preferred settings.
  •  You can also use the command box to reset the default settings to excel ones. In such a case, you can type “&reset_excel” (minus the quotation marks) and then press enter. From then on, your SAP data will always be exported to Excel.

Learning the above methods on how to export data from SAP to Excel will help simplify your SAP experience.

mm
Marissa Hart is the Lead Author & Editor ShareMe. ShareMe is a blog focused on SharePoint Online. SharePoint Online delivers the powerful features of SharePoint without the associated overhead of managing the infrastructure.