---
title: How to Convert an Excel Workbook Created with the SAP BEx Analyzer
description: "Find out how to convert an Excel workbook created with the SAP BEx Analyzer: the conversion process, settings, and protocol to follow."
image: https://blog.sap-press.com/hubfs/How%20to%20Convert%20an%20Excel%20Workbook%20Created%20with%20the%20SAP%20BEx%20Analyzer.png
---

[![rheinwerk-sappress-logo-header-1](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://blog.sap-press.com/) [Blog](https://blog.sap-press.com)

- Books 
    - Get an overview of our books and courses on every relevant SAP topic. 
          - [Programming](https://sap-press.com/programming/)
          - [Administration](https://sap-press.com/administration/)
          - [BI](https://sap-press.com/business-intelligence/)
          - [Finance](https://sap-press.com/finance-controlling/)
          - [Logistics](https://sap-press.com/logistics/)
          - [HR](https://sap-press.com/human-resources/)
          - [CRM & Sales](https://sap-press.com/marketing-sales/)
          - [HANA](https://sap-press.com/hana/)
          - [Introductions](https://sap-press.com/introductions/)
          - [E-Bites](https://sap-press.com/e-bites/)
          - [Certification Guides](https://www.sap-press.com/certification-guides/)
          - [Rheinwerk Courses](https://www.sap-press.com/online-courses/)
- Book Subscription 
    - Get unlimited access to all SAP PRESS books! 
          - [SAP PRESS Subscription](https://sap-press.com/subscriptions/)

[Business Intelligence](https://blog.sap-press.com/tag/business-intelligence)

# How to Convert an Excel Workbook Created with the SAP BEx Analyzer

![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg)  by [SAP PRESS](https://blog.sap-press.com/author/sap-press)

In addition to creating workbooks from scratch in SAP Analysis for Microsoft Office, you can also convert existing workbooks created with SAP BEx Analyzer 3.5 or 7.0 into an SAP Analysis for Microsoft Office workbook.

 

When doing this conversion, you can define which SAP BEx objects should be converted in the conversion settings. The possible options are described in this post. You can also specify whether a log should be created for the conversion. We’ll discuss the conversion protocol too.

 

## Converting a Workbook

To convert a workbook created with the SAP BEx Analyzer, as shown in the figure below, follow the path **File >** **Analysis** (1) and then select **Convert BEx Workbook** (2).

![2004_09_014](https://blog.sap-press.com/hs-fs/hubfs/2004_09_014.png?width=1031&name=2004_09_014.png)

 

Then, select the SAP NetWeaver system on which the workbook created with the SAP BEx Analyzer is located and confirm your selection by clicking on the **Next** button. Enter the user name and password that you use to log on to the system. You can then search for the description or technical name of the workbook you want to use or select it directly via the corresponding folder. SAP BEx Analyzer workbooks are displayed with the arrow icon. Below shows an example.

 

![Selecting an SAP BEx Analyzer Workbook](https://blog.sap-press.com/hs-fs/hubfs/2004_09_015.png?width=1041&name=2004_09_015.png)

 

After you’ve confirmed your selection by clicking the **OK** button, the conversion begins. SAP BEx Analyzer objects are converted into SAP Analysis for Microsoft Office objects.

 

The table below provides an overview of convertible SAP BEx Analyzer objects with their corresponding counterparts in SAP Analysis for Microsoft Office.

![List of Convertible Objects](https://blog.sap-press.com/hs-fs/hubfs/2004_table_09_001.png?width=1330&name=2004_table_09_001.png)

 

After the conversion, the workbook is opened in SAP Analysis for Microsoft Office. You can save it as a new workbook and start your analysis.

**9**

## Conversion Settings

You can specify which SAP BEx Analyzer objects should be converted and whether a conversion log is to be created. First, switch to the settings by choosing **File >** **Analysis**. Then, select the **Options** option from the **Customize Analysis** dropdown list, as shown in this figure.

 

![Adjusting SAP Analysis for Microsoft Office Options](https://blog.sap-press.com/hs-fs/hubfs/2004_09_016.png?width=679&name=2004_09_016.png) 

Under the **Conversion** tab (1), maintain the settings shown here.

![Conversion Options](https://blog.sap-press.com/hs-fs/hubfs/2004_09_017.png?width=702&name=2004_09_017.png)

In the **Conversion Settings** dropdown list (2), you can choose between the following options:

- **Convert All**: All objects in the workbook are converted.
- **Convert Data Sources and Crosstabs**: Data sources and crosstabs are converted.
- **Convert Data Sources Only**: Only data sources are converted.

In the **Refresh Workbook** dropdown list (3), you can select from the following settings:

- **Always**: The workbook is refreshed after the conversion.
- **Never**: The refresh after the conversion does not take place.
- **Use Workbook Setting**: After conversion, the workbook is updated according to the settings in the SAP BEx Analyzer.

In the **Conversion Log** dropdown list (4), you can choose between the following options:

- **Disabled**: No log is created.
- **Create on New Visible Worksheet**: A log is created and displayed on a new worksheet.
- **Create on New Hidden Worksheet**: A log is created, but the worksheet is hidden by default.

Finally, select the **Show Save Dialog After Conversion** checkbox (5) to control whether the save dialog box should be displayed automatically after the conversion.

 

## Conversion Protocol

The conversion log displays the conversion status of all objects in an SAP BEx Analyzer workbook. In the settings configured above, you can specify whether a log should be created during the conversion and whether this log should be added to the workbook as a visible or hidden worksheet. The next figure shows an example.

 

![Conversion Log](https://blog.sap-press.com/hs-fs/hubfs/2004_09_018.png?width=1102&name=2004_09_018.png)

 

In the upper area, a message will indicate whether the conversion was successful or not (1). Below this area, the ID of the SAP BEx Analyzer workbook (2) and the selected conversion settings (3) will be displayed. In the settings, you can specify whether all objects, data sources, and crosstabs or only data sources should be converted.

 

The objects of the SAP BEx Analyzer workbook are then listed together with the conversion status. One list is generated for DataProviders, one for planning objects, and one for all other objects in the workbook. The list consists of several columns.

 

First, the status is displayed in the **Status** column (4). The following statuses are possible: **Converted**, **Not Converted**, and **Ignored**. Next, the type of the object is displayed in the **Type** column (5), for example, **DATAPROVIDER**, **GRID**, or **NAVIGATION\_PANE**. In the **Text** or **Name** column (6), the description or technical name of the object is displayed.

**9**

The **Data Provider** or **Alias** column (7) displays the alias of the DataProvider. If the conversion status is **Not Converted** or **Ignored**, a message is displayed in the **Message** column (8). For example, if the status is **Ignored**, the message **Object was not converted due to current conversion settings** will be displayed. Finally, the **Sheet Range** column (9) displays the range of the object. You can click the hyperlink to go to the object in the workbook.

 

Now you know how to convert Microsoft Excel workbooks for use in SAP!

 

[Learn more about SAP data management on this page](https://learning.sap-press.com/sap-data-management).

 

*Editor’s note*: This post has been adapted from a section of the book[*SAP Analysis for Microsoft Office—Practical Guide*](https://www.sap-press.com/sap-analysis-for-microsoft-office-practical-guide_5155/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=chapter9&utm_content=2004)by Denis Reis.

## Recommendation

[![SAP Analysis for Microsoft Office—Practical Guide](https://blog.sap-press.com/hs-fs/hubfs/social-suggested-images/f.hubspotusercontent00.nethubfs57072002004-1.jpg?width=170&name=f.hubspotusercontent00.nethubfs57072002004-1.jpg)](https://www.sap-press.com/sap-analysis-for-microsoft-office-practical-guide_5155/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=chapter9&utm_content=2004)

**SAP Analysis for Microsoft Office—Practical Guide**

Managing your SAP data in Microsoft Excel? This is your guide to using SAP Analysis for Microsoft Office! Get started with the basics, from creating your first workbook to navigating through reports. Then, follow step-by-step instructions to process data, analyze data, develop planning applications, customize reports, and work with tools such as formulas and macros. Including details on troubleshooting, UI customization, and more, this book is your all-in-one resource!

[Learn More](https://www.sap-press.com/sap-analysis-for-microsoft-office-practical-guide_5155/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=chapter9&utm_content=2004)

![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg)

**by [SAP PRESS](https://blog.sap-press.com/author/sap-press)**

SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP IBP, intelligent technologies, SAP Business Technology Platform, and more!

[Business Intelligence](https://blog.sap-press.com/tag/business-intelligence)

[![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](https://www.facebook.com/share.php?u=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-convert-an-excel-workbook-created-with-the-sap-bex-analyzer%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on linkedin](https://7528302.fs1.hubspotusercontent-na1.net/hub/7528302/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/linkedin-color.png?width=24&name=linkedin-color.png)](https://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-convert-an-excel-workbook-created-with-the-sap-bex-analyzer%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-convert-an-excel-workbook-created-with-the-sap-bex-analyzer%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-convert-an-excel-workbook-created-with-the-sap-bex-analyzer%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Share on email](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/email-color.png?width=24&name=email-color.png)](mailto:?subject=Check+out+https%3A%2F%2Fblog.sap-press.com%2Fhow-to-convert-an-excel-workbook-created-with-the-sap-bex-analyzer%3Futm_medium%3Dsocial%26utm_source%3Demail&body=Check+out+https%3A%2F%2Fblog.sap-press.com%2Fhow-to-convert-an-excel-workbook-created-with-the-sap-bex-analyzer%3Futm_medium%3Dsocial%26utm_source%3Demail)

### Comments

### Latest Blog Posts

[![Phases in SAP BW/4HANA Conversion](https://blog.sap-press.com/hs-fs/hubfs/Phases%20in%20SAP%20BW4HANA%20Conversion.png?height=600&name=Phases%20in%20SAP%20BW4HANA%20Conversion.png)](https://blog.sap-press.com/phases-in-sap-bw4hana-conversion)

[Business Intelligence](https://blog.sap-press.com/tag/business-intelligence)

## [Phases in SAP BW/4HANA Conversion](https://blog.sap-press.com/phases-in-sap-bw4hana-conversion)

[Read More](https://blog.sap-press.com/phases-in-sap-bw4hana-conversion)

[![Technical Configuration of SAP Analysis for Microsoft Office](https://blog.sap-press.com/hs-fs/hubfs/Technical%20Configuration%20of%20SAP%20Analysis%20for%20Microsoft%20Office.png?height=600&name=Technical%20Configuration%20of%20SAP%20Analysis%20for%20Microsoft%20Office.png)](https://blog.sap-press.com/technical-configuration-of-sap-analysis-for-microsoft-office)

[Programming](https://blog.sap-press.com/tag/programming)

## [Technical Configuration of SAP Analysis for Microsoft Office](https://blog.sap-press.com/technical-configuration-of-sap-analysis-for-microsoft-office)

[Read More](https://blog.sap-press.com/technical-configuration-of-sap-analysis-for-microsoft-office)

**Subscribe to our blog!**Get notified about future blog updates.

- <https://www.facebook.com/sappress>
- <https://twitter.com/sappress>
- <https://linkedin.com/company/sap-press>
- <https://www.instagram.com/sap_press/>
- <https://blog.sap-press.com/rss.xml>

### The official SAP PRESS Blog

As the world’s leading SAP publisher, SAP PRESS’ goal is to create resources that will help you accelerate your SAP journey. The SAP PRESS Blog is designed to provide helpful, actionable information on a variety of SAP topics, from SAP ERP to SAP S/4HANA. Explore ABAP, FICO, SAP HANA, and more!

### SAP Blog Topics

- [All Topics](https://blog.sap-press.com)
- [Logistics](https://blog.sap-press.com/tag/logistics)
- [Programming](https://blog.sap-press.com/tag/programming)
- [FICO](https://blog.sap-press.com/tag/fico)
- [Administration](https://blog.sap-press.com/tag/administration)
- [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence)
- [What Is?](https://blog.sap-press.com/tag/what-is)
- [Featured](https://blog.sap-press.com/tag/featured)
- [CRM & Sales](https://blog.sap-press.com/tag/crm-sales)
- [Video](https://blog.sap-press.com/tag/video)
- [Human Resources](https://blog.sap-press.com/tag/human-resources)

### Blog curated by

[![Rheinwerk Publishing & SAP PRESS Logo](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://sap-press.com) [Visit the SAP PRESS Store](https://sap-press.com)

### About

- [Home](https://sap-press.com/)
- [About Us](https://sap-press.com/the-publisher/)
- [Contact](mailto:info@rheinwerk-publishing.com)
- [Legal Notes](https://sap-press.com/legal-notes/)
- [Privacy Policy](https://sap-press.com/privacy/)
- [Terms of Use](https://sap-press.com/terms/)
- [Guest Posting](https://blog.sap-press.com/guest-posting)

© 2026 Rheinwerk Publishing, Inc. | Change Privacy Options

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "SAP PRESS",
    "url" : "https://blog.sap-press.com/author/sap-press"
  },
  "dateModified" : "2026-08-26T15:41:43.671Z",
  "datePublished" : "2021-08-30T13:00:00.000Z",
  "headline" : "How to Convert an Excel Workbook Created with the SAP BEx Analyzer",
  "image" : [ "https://blog.sap-press.com/hubfs/How%20to%20Convert%20an%20Excel%20Workbook%20Created%20with%20the%20SAP%20BEx%20Analyzer.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.sap-press.com/how-to-convert-an-excel-workbook-created-with-the-sap-bex-analyzer",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.sap-press.com/hubfs/Logo-1.jpg"
    },
    "name" : "Rheinwerk Publishing, Inc."
  }
}
```