top of page
  • Zach Pfeffer

Export MySQL to Excel with Python


Overview

Verified Python code for creating and exporting 2 MySQL tables to Excel using mysql.connector and openpyxl.

Code

References

Excel icon from: https://www.microsoft.com/en-us/store/d/excel-2016/cfq7ttc0k5f3

MySQL icon from: https://www.mysql.com/products/connector/

OpenPyXL icon from: https://openpyxl.readthedocs.io/en/default/

Python icon from: https://www.python.org/

bottom of page