Convert TSV to SQL
Form for TSV converting to SQL
This form allows you convert TSV to SQL queries, paste or upload your TSV file below:
Result of TSV conversion to SQL
About TSV conversion to SQL
About TSV data conversion to SQL queries
The TSV to SQL Converter was created for online transform TSV(Tab Separated Values) data into SQL(Structured Query Language) queries to insert in the database. This awesome tool supports custom table name and several MySQL commands to insert.
As a result, you will receive several queries:
- SQL query to create a table. 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.
- Insert or Replace queries.
How it Works?
Just select the options you need and paste your TSV data to the textarea above and click to the button "Convert" and you will instantly get SQL queries.
Example of TSV conversion to SQLBefore:
Name Email Phone Number Address Bob Smith [email protected] 123-456-7890 123 Fake Street Mike Jones [email protected] 098-765-4321 321 Fake AvenueAfter:
/* CREATE TABLE */ CREATE TABLE table_name( `Name` VARCHAR(100), `Email` VARCHAR(100), `Phone_Number` VARCHAR(100), `Address` VARCHAR(100) ); /* INSERT QUERY NO: 1 */ INSERT INTO table_name(`Name`, `Email`, `Phone_Number`, `Address`) VALUES ('Bob Smith', '[email protected]', '123-456-7890', '123 Fake Street'); /* INSERT QUERY NO: 2 */ INSERT INTO table_name(`Name`, `Email`, `Phone_Number`, `Address`) VALUES ('Mike Jones', '[email protected]', '098-765-4321', '321 Fake Avenue');After conversion, you can execute these commands in your SQL server and add all data to your database.