Simple and short python program to save excel data into mysql database. if you have any excel file and want to make mqsql database from it then you can contine. requirements : python3 installed on your pc then a database server (I have used xammp ) openpyxl python module (pip install openpyxl) mysql-connector python module (pip install mysql-connector)
save excel file in same place where python program exist Edit the python code as per your requirements and run BY simply type < python ./xltodb.py > congratlations work has been done . you can see it in your database.