ExcelToDB

Upload an excel file and store its contents to a MySQL database using Python-Flask.

Requirements

• Python
• Pip
• Flask
• xlrd
• mysql.connector
• MySQL
• Xampp (or similar application)

Steps

Download Python from official website. Install the dependencies and start the server.

$ pip install pip
$ pip install Flask
$ pip install xlrd
$ pip install mysql-connector-python

Start Xampp or MySQL server application

$ python main.py

Go to your localhost to see the app running.