buemura/excel-to-sql

excel-to-sql

Excel Sheet to SQL Insert Query

Convert Excel sheet to SQL Insert Query

Setup

Create virtual environment:

virtualenv venv
source venv/Scripts/activate

Install the dependencies

pip install -r requirements.txt

Add a .xlsx file in input directory with the following structure:
row 1: Table name
row 2: Columns name
row >= 3: Data to insert

How it works

After the Setup process is done, run the main.py script.

python main.py

The script will generate a .txt file in output directory with the SQL Insert query according to .xlsx file added in input directory.

Author

• Bruno Hideki Uemura linkedin, Github