Excel_to_MySQL_Webapp

In this project i have designed a webapp which will take an Excel file, Database Name, Table name as an input from user and update that excel data into the MySQL database at backend.

Features

• Light/dark mode toggle
• Validates whether the uploded file is Excel file or not
• Fullscreen mode
• Cross platform

Screenshots

Home Page of Website

Once Excel data get sucessfully updated into MySQL

When user select other than Excel file

updated data into MySQL

Tech Stack

Client: HTML, CSS, Bootstrap CSS, Javascript.

Server: Flask, MySQL.

Used By

This project is used by the following companies:

• Reliance Jio Infocomm Limited.

Run Locally

Clone the project

  git clone https://github.com/rushibaswade/Excel_to_mysql-Flask-Webapp/blob/main/Excel.py

Go to the project directory

  cd my-project

Install dependencies

  pip install pandas, Flask, Mysql_connector

Start the server

    python Excel.py

Installation

Install my-project with npm

  npm install my-project
  cd my-project

Lessons Learned

While creating this project i got hands on exposure to Python Flask framework, And MySQL database.

Feedback

If you have any feedback, please reach out to us at rushib12344@gmail.com