This example shows how to import an excel file into an Sqlite table with pandas and sqlsoup

excel2sql.py

import pandas as pd
import sqlsoup

db = sqlsoup.SQLSoup('sqlite:///pandas.db')
engine = db.engine

# Read Excel
df = pd.read_excel('excel_file.xlsx',
                   0,  # Sheet
                   index_col=None,
                   na_values=['NA'],
                   skiprows=1  # First row is invalid
                   )

# Store as SQL
df.to_sql('excel_file_table', engine, if_exists="replace")