The entire code is as follows: import sqlite3Ĭonnection = nnect('/path/to/database.sql')Ĭolnames = for desc in scription] Therefore a colnames parameter is created to allow just the column name to be added to the output as a column header in the CSV file. It is based on Till Hoffman’s code with modifications to extract column names.Ĭolumn names are encoded in the scription parameter, but this actually contains a list of tuples, of which column_name is the first. There are quite a few Python scripts available that will convert a SQL database file into a CSV, but I have found the below code to be quite good. VALUES ('Mike Jones', ' ', '09', '321 Fake Avenue', 45) Īfter conversion, you can execute these commands in your SQL server and add all data to your database.Nifty Python code that converts a SQL database file into a CSV file and includes column headers. INSERT INTO table_name(`Name`, `Email`, `Phone_Number`, `Address`, `Age`) Example of CSV conversion to SQLīefore: Name,Email,Phone Number,Address,Ageīob Smith, ,12,123 Fake Street,21 Just select the options you need and paste your CSV data to the textarea above and click to the button ' Convert' and you will instantly get SQL queries. But this is just an example of 'create table' in fact, it is not recommended to execute this query, because it does not contain indexes, keys, valid types, etc.

This awesome tool supports custom CSV column delimiters, custom table name and several MySQL commands to insert.Īs a result, you will receive several queries:

The CSV to SQL Converter was created for online transform CSV(Comma Separated Values) data into SQL(Structured Query Language) queries to insert in the database.

Convert sql to csv