FelipedelosH

This is a simple way to read Excel and export data like a insert sql.

HOW to run

0 -> install pandas

if you need upgrade pip run in terminal:

Python -m pip install --upgrade pip
Python -m pip install pandas

1 -> settings in main.py

insert a excel file in root folder
set path route of ecxel
set a name of target table sql
put all col names
select a type of cols: int, float, string, bool, date ...
set if you need drop a headers

3 -> Run and execute main.py

if you exceute all values of excel convert in sql. view file: 'output.sql'