Use this library to convert CSV, JSON, Excel or XML files to SQL databases within your python projects.

It’s finally here! One of our most-requested features has landed - a python client library so you can harness the power of SQLizer inside your python projects.

All plans come with an API key (even free plans) so there’s no reason not to dive in and experiment.

Find the SQLizer python package here, and the package source code over here.

Getting Started

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 your Account Page. Create a sqlizer.File object passing in the conversion parameters. Call convert(), then zdownload_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')

The library is available now, enjoy!

You might also be interested in our .net SDK for SQLizer if you’re more of a .NET person than a Python person. 🐍

🖤 The SQLizer Team

Psssst… Thanks for reading this blog post. If you have a >5000 row CSV file you need to convert, use code CONVERTME10 for 10% off your Pro Monthly plan for the first 12 months, or a one-off 10% discount on your Pro Annual plan.