CSV To SQL Converter
Separator
Input
Output
Instruction
This converter converts .csv files with “,” or “;” -separator to a part of SQL query next format:
(column1, column2, ..., columnk) VALUES (value1, value2, ..., valuek), (value1, value2, ..., valuek), (value1, value2, ..., valuek), ...So input data should have next format:
column1,column2,...,columnk value1,value2,...,valuek value1,value2,...,valuek value1,value2,...,valuek ...or:
column1;column2;...;columnk value1;value2;...;valuek value1;value2;...;valuek value1;value2;...;valuek ...The main advantage of this script is that it gives you ready sql query part to load it to db. It is simple:
"INSERT INTO table" + csv_to_sql(input, separator)Also this script can convert values, which are contains “,”.
To add this feature to your project simply copy csv_to_sql function from JS block.
Convert your CSV data to SQL format easily and quickly with our online csv to sql converter tool.