Fill in your spreadsheet using a database
Connecting to MySQL from Excel (Complete Guide)
Of course, Excel is used for spreadsheets, but did you know that you can connect Excel to external data sources? In this article, we’ll discuss how to connect an Excel spreadsheet to a MySQL database table and use the data in the database table to populate your spreadsheet. There are a few things you’ll need to do to prepare for this connection.
First you need to download the latest Open Database Connectivity (ODBC) driver for MySQL. The current ODBC driver for MySQL can be found at
https://dev.mysql.com/downloads/connector/odbc/
