A client library for the SQLizer.io file conversion service. Use this library to convert CSV, JSON, Excel or XML files to SQL tables within your python projects.

Install the library using pip, by typing at the command line:

pip install sqlizer-io-client

To use the converter, import the sqlizer module, then set your API Key value. You can find your API keys on the SQLizer.io Account Page. Create a sqlizer.File object passing in the conversion parameters. Finally, call convert(). For example:

import sqlizer

sqlizer.config.API_KEY = 'your-api-key'

with open('example.xlsx', mode='rb') as file_content:
    converter = sqlizer.File(file_content, sqlizer.DatabaseType.MySQL, sqlizer.FileType.XLSX, 'example.xlsx', 'my_table')
    converter.convert(wait=True)
    print(converter.download_result_file().text)