Connect BI Tools >
Connect from Microsoft Excel

Connect from Microsoft Excel¶

On this page

Prerequisites
Procedure

You can import data from a MongoDB collection into a Microsoft Excel spreadsheet with the MongoDB Connector for BI and an ODBC data connection.

Prerequisites¶

Create a 64-bit system Data Source Name (DSN).
If your BI Connector and MongoDB deployment are running with authentication enabled, install the MongoDB C Authentication Plugin for your platform.

New in version 2.2.

Procedure¶

Before beginning this tutorial, make sure you have a running mongosqld instance.

1

Start Excel¶

Start Microsoft Excel and open a blank worksheet.

2

Select the Data Tab¶

Select the Data tab to open the Data toolbar.

3

Open a Data Connection Wizard Dialog¶

Click the Get External Data button on the left side of the toolbar.
Click From Other Sources.
Select the From Data Connection Wizard option.

Screenshot of the Data Connection Wizard option

4

Select ODBC DSN¶

Select ODBC DSN from the list of data source options and click Next.

Screenshot of data source options selection box

5

Select Your DSN¶

Select the DSN which connects to your BI Connector instance and click Next.

6

Select a Database and Table¶

Select a database from the dropdown list and a collection from which to import data. Click Next when finished.

7

Save the Connection File¶

Save the data connection file and click Finish. If you wish to re-use this connection in the future, you can select it from the Data -> Get External Data -> Existing Connections menu.

8

Specify Worksheet Format¶

In the final dialog window you can specify a format for your worksheet. Click OK when finished.