An open source python software which let you open any excel file, view the data, copy or modify if required, download the modified data in excel, generate SQL query for inserting the raw data in database and close it.

It will directly generated a SQL query for inserting the whole data in database from a table grid so you don't have to mannually insert the data or develop a functionality to do this.

Step 1 : Download the depency which are required:

Python must be install in system. Dowload libraries PyQt6, pandas using command

It is recommended to use virtual environment

  pip install pandas
  pip install pyqt6

Step 2 : Run using terminal:

python3 Main.py

Window will appear

Step 3 : Open the excel file you want to view,edit,modify:

Step 4 : Excel data is loaded.:

Step 5 : give the table name :

Step 6 : Click on generate query button :

Query is generated. Modify if required

Step 6 : Copy using copy button or ctrl+c :

Step 7 : Paste the query into database query tool window:

Step 8 : Execute the query:

Please note if nan value appears either remove the column and replace with the desired value.

Data is inserted in db:

Modify excel data using double click:

Download the updated excel data: