So you have SAP data that you need to place into an Excel spreadsheet? Luckily for you, there are several options available to choose from. The only trick is to figure out which approach works best for your organization.
One clear-cut method is to copy each individual record from SAP, one-by-one, and enter that data into an Excel spreadsheet. This, however, takes a lot of time and effort. Once you start working with the data and creating more complex spreadsheets, you’ll find yourself needing a faster, more robust solution.
Alternately, your SAP ERP system contains several inherent functions that allow users to export SAP data into an Excel-friendly format. This is much easier than manual entry, but formatting this data to your specifications can be a timely endeavor.
This is where SAP-certified third party applications such as Compleo Suite can come in handy. With Compleo Suite, you can automatically convert an SAP spool file into a formatted Excel file.
Let’s take a look at two main ways you can transform SAP data.
Without Compleo Suite
1.) Right click the list you’re working with and select “Local File”:
2.) Save as a spreadsheet:
3.) Open the file in Excel:
1.) Click List –> Export –> Local File:
2.) Save the list in the clipboard:
3.) Paste the contents of your clipboard into an Excel spreadsheet, either by using CTRL + V or right-clicking and selecting “paste”:
If you really want to get into some more nuanced options for converting SAP-Excel, check out this SAP blog post.
Using Compleo Suite
1.) First, send an output request to a device that is being monitored by Compleo Supervisor (this example uses a list of sales orders):
2.) Ensure your Compleo Supervisor scenario is configured correctly (you can skip this step if you’ve already set it up.)
Once that’s done, Supervisor will automatically run the scenario after it receives the spool.
Here’s the scenario in action:
This scenario runs a Compleo Explorer template, which converts the spool file to an Excel file using the following settings:
**Note: If your Supervisor scenario and Explorer template are already configured, the Excel files will automatically start being created using the Explorer template once Supervisor detects the output request.**
3.) Next, the report is sent via email:
Clicking on the attachment brings us a report that looks like the following:
Converting SAP data to Excel Spreadsheets can be a time consuming task. SAP-Certified applications like Compleo Suite can expedite operations by automating the entire process (with only a little prep-work needed beforehand). SAP also includes a few different options for you to export data into an Excel format, giving your company a chance to choose the ideal solution for your needs.
You can also get a more detailed look at managing SAP data in our SAP Insider video here.