need the code for insert pyexcel solution if you could insert an id field to act as the primary keyit can be mapped using sqlalchemy' ormsqlite /tmp/stack db sqlitecreate table allproteins id intprotein_id char( )protein_key intvalue_of_key int )here is the data mapping script vis sqlalchemymapping your database via sqlalchemy from sqlalchemy import create_engine from sqlalchemy ext declarative import declarative_base from sqlalchemy import columnintegerstring from sqlalchemy orm import sessionmaker checkout for different database server engine create_engine("sqlite:////tmp/stack db"base declarative_base(class proteins(base)__tablename__ 'allproteinsid column(integerprimary_key=trueautoincrement=true<-appended '-field protein_id column(string( )protein_key column(integervalue_of_key column(integersession sessionmaker(bind=enginehere is the short script to get data inserted into the databaseimport pyexcel as from itertools import product data insertion code starts here sheet get_sheet(file_name="csv-to-mysql-in-matlab-code csv"delimiter='\ 'sheet name_columns_by_row( sheet name_rows_by_column( print(sheetcsv-to-mysql-in-matlab-code csv+++++ +======+========+========+========+========= +++++ +++++ +++++results [for protein_idprotein_key in product(sheet rownamessheet colnames)results append([protein_idprotein_keysheet[str(protein_id)protein_key]](continues on next page support the project