table2sql

Python CLI tool which allows you to convert file with table (CSV and Excel) to SQL insert statements.

Docs

Basic usage

some.csv

a,b,c,dint,str,float,sql1,2,3,(SELECT id FROM another.table WHERE name = 'Paul')5,6,7,(SELECT id FROM another.table WHERE name = 'Paul')

Command:

table2sql some.csv --output-table some.table --has-types-row

Result:

INSERT INTOsome.table (a, b, c, d)
VALUES (1, '2', 3.0, (SELECT id FROManother.tableWHERE name ='Paul')), (5, '6', 7.0, (SELECT id FROManother.tableWHERE name ='Paul'));

Install

pip install table2sql