Excel

Excel Add-In for SAP Business Warehouse

Connect to live SAP Business Warehouse from Excel

The SAP Business Warehouse Excel Add-In is a powerful tool that allows you to connect with live SAP Business Warehouse data, directly from Microsoft Excel. Use Excel to read SAP Business Warehouse. Perfect for mass imports / exports, data cleansing & de-duplication, Excel based data analysis, and more!

Install the Add-In, configure your SAP Business Warehouse connection, and go!

Download Beta

Your SAP Business Warehouse data, your way!

The Excel Add-In for SAP Business Warehouse provides the easiest way to connect with SAP Business Warehouse data. Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live SAP Business Warehouse tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.

Access SAP Business Warehouse data directly from Excel

Direct Access

Direct access to live SAP Business Warehouse Data from Excel

The Excel Add-In for SAP Business Warehouse is integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click.

Direct access to SAP Business Warehouse data in Excel

Setup

Easy-to-use, straightforward configuration

Install the Add-In
Login with user & password
Select tables

Installing the CData SAP Business Warehouse Excel Add-In creates a dedicated toolbar in Excel, giving users instant access to SAP Business Warehouse data for faster data analysis and reporting. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.

Configure SAP Business Warehouse connection in Excel

Data Selection

Select tables and columns

Once the data connection is configured, just specify the table and the Excel Add-In will populate a new Excel sheet with live SAP Business Warehouse Data.

Select SAP Business Warehouse tables in Excel

Data Analysis

SAP Business Warehouse Data with the full power of Excel

Perfect for mass imports, data cleansing & de-duplication, Excel-based data analysis, and more!

Quickly export and backup data.
Operate on data with Charts and Pivot Tables.

SAP Business Warehouse data analysis in Excel

FAQs

Frequent SAP Business Warehouse Excel connectivity questions

Common questions about integrating SAP Business Warehouse with Microsoft Excel.

How do I connect SAP Business Warehouse to Excel?

The SAP Business Warehouse Excel Connector is fully integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click. Installing the SAP Business Warehouse Excel Add-In creates a new CData data access toolbar in Excel that users can access to connect to remote data. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection to any data source. Once the SAP Business Warehouse Excel integration is configured, just select a table from SAP Business Warehouse and the Excel Add-In will populate a new Excel sheet with live Data.
Can I export SAP Business Warehouse to Excel?

Configuring a SAP Business Warehouse export to Excel is a thing of the past — no more downloading or copying & pasting to make sure you have the freshest data. The SAP Business Warehouse Add-In provides live direct connectivity to SAP Business Warehouse and does not require a SAP Business Warehouse Excel export. Simply click the Refresh button from the Excel SAP Business Warehouse plugin and the tool will download SAP Business Warehouse to excel instantly.
Is it possible to edit SAP Business Warehouse data from Excel?

Our integration enables live, bi-directional access to SAP Business Warehouse data directly from Excel. Easily pull live data into your spreadsheet, make changes, and push updates back to SAP Business Warehouse — all without leaving Excel. Edited cells are automatically highlighted to show differences from the source data. When ready, click the Update Rows button in the CData Add-In toolbar to sync your changes.
Is there a free trial available?

Absolutely. Free trials are available for all CData products. Your 30-day free trial of the SAP Business Warehouse Excel Connector will begin as soon as you have downloaded the SAP Business Warehouse Excel Add-In and completed the intallation process. The trial provides full, unrestricted access to all features and capabilities of the SAP Business Warehouse Excel Connector.
Start your trial today: SAP Business Warehouse Excel Add-In free download.

SAP Business Warehouse Excel Resources:

Take a look at some of our most popular articles from our knowledge base:

For more articles and technical content related to Excel Add-In for SAP Business Warehouse, please visit our online knowledge base.

Download the SAP Business Warehouse Excel Add-In

Building custom dashboards & reports that connect with live SAP Business Warehouse data has never been easier. Download the CData Excel Add-In for SAP Business Warehouse now, and get connected.