

# Connect to Amazon DocumentDB from Microsoft Excel
<a name="connect-odbc-excel"></a>

1. Ensure that the Amazon DocumentDB driver has been correctly installed and configured. For additional information, refer to [Setting up the ODBC driver in Windows](https://docs.aws.amazon.com/documentdb/latest/devguide/connect-odbc-setup-windows.html).

1. Launch Microsoft Excel.

1. Navigate to **Data** > **Get Data** > **From Other Sources**.

1. Choose **From ODBC**:  
![The Get Data dropdown shows the From Other Sources submenu. The From ODBC option is selected.](http://docs.amazonaws.cn/en_us/documentdb/latest/devguide/images/excel-odbc-1.png)

1. Select the data source from the **Data source name (DSN)** drop down menu that is associated with Amazon DocumentDB:  
![The Data source name dropdown with the DocumentDB DSN option selected.](http://docs.amazonaws.cn/en_us/documentdb/latest/devguide/images/excel-odbc-dsn-select-1.png)

1. Choose the collection from which you want to load data into Excel:  
![The Navigator interface with the salaries table selected and a preview of its data.](http://docs.amazonaws.cn/en_us/documentdb/latest/devguide/images/excel-odbc-collect-1.png)

1. Load data into Excel:  
![Excel spreadsheet showing five rows of data from the selected salaries table.](http://docs.amazonaws.cn/en_us/documentdb/latest/devguide/images/excel-data-load-1.png)