# Testing Microsoft Excel Connection

## Prerequisites
* [Download and install](../../README.md) OpenSearch SQL ODBC Driver.
* [Install and configure](https://docs-beta.opensearch.org/opensearch/install/index/) OpenSearch.
* Open ODBC Data Source Administrator. Click on **System DSN** > **OpenSearch SQL ODBC DSN** > **Configure**.
* Set all connection options & Click on **Test**. Connection test should return `Connection Successful`.

## Microsoft Excel Connectivity

There are multiple ways to load data from OpenSearch in Microsoft Excel.
* [ODBC as Data Source](odbc_data_source_connection.md)
* [Microsoft Query](microsoft_query_connection.md)
* [Query Wizard](query_wizard_connection.md)
* [Data Connection Wizard (Legacy)](data_connection_wizard.md)

## Use Microsoft Excel with data loaded from OpenSearch

* [Refresh the data](refresh_data.md)
* [Exporting CSV files](exporting_csv_files.md)