We want you to harness SQLizer’s powerful file conversion engine in your own projects with our open-source client libraries:

The SQLizer API lets you easily and securely convert Excel, JSON, CSV and other files into SQL databases with table definitions and multiple INSERT statements. Build powerful data migration and conversion workflows with SQLizer.

.NET client

Add it to your project with:

dotnet add package sqlizer-client-dotnet --version 0.0.23

See: The NuGet package page for the SQLizer .NET Client.

Python library

Requires: Python >=3.6

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. Call convert(), then download_result_file(). 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)
    

Please dive in and contribute on Github if there are things you’d like to see or improve.