Connect Excel to MySQL When the Get Data Connector Is Missing
Question details
Connect Microsoft Excel to a MySQL database when the built-in MySQL connector is not available in Get Data.
- Product
- Microsoft Excel for Microsoft 365 Family
- Device & OS
- not provided
- Scenario
- The user wants to import MySQL database data into Excel without upgrading solely to obtain the built-in connector.
- Observed behavior
- The MySQL database connector is missing from the Excel Get Data menu, but an ODBC connection may provide an alternative.
Check whether Excel offers Data > Get Data > From Other Sources > From ODBC. Have your MySQL server address, database name, credentials, and any required network access available.
Connect Excel to MySQL through an ODBC data source
Use the free MySQL Connector/ODBC as an alternative when Excel's built-in MySQL connector is missing.
The availability of Excel's data connectors can vary by platform, version, and Microsoft 365 plan. The ODBC option must be available in your installation for these steps to work.
Download and install MySQL Connector/ODBC from the official MySQL website. Choose a driver compatible with your operating system and Excel's 32-bit or 64-bit architecture.
Open your operating system's ODBC data source administrator and add a data source using the MySQL ODBC driver. Enter the server address, database name, and authentication details, then use the test option if available.
In Excel, select Data > Get Data > From Other Sources > From ODBC.
Choose the configured data source, provide credentials if prompted, and select the database tables you need. Choose Load to import them or Transform Data to edit the query first.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight, easy-to-use alternative with a familiar interface and compatibility with Microsoft Office formats, making it easy to move existing spreadsheets. It does not restore Excel's missing MySQL connector.

Frequently Asked Questions
Why is the MySQL connector missing from Excel Get Data?
Connector availability can vary by Excel version, platform, and Microsoft 365 plan. If the MySQL option is missing, check Data > Get Data > From Other Sources for the From ODBC option.
Do I need to upgrade Microsoft 365 to connect Excel to MySQL?
Not necessarily. If your Excel installation supports From ODBC, you can install the free MySQL Connector/ODBC, configure a data source, and connect through Data > Get Data > From Other Sources > From ODBC.
Which MySQL ODBC driver should I install?
Install a MySQL Connector/ODBC driver compatible with your operating system and Excel's 32-bit or 64-bit architecture. In Excel, you can check the architecture under File > Account > About Excel.
What should I check if Excel cannot connect to the MySQL data source?
Test the data source in your ODBC administrator and verify the server address, credentials, network access, and database permissions. Also check that the driver architecture matches Excel.




