Convert TSV to Insert SQL
EN | JA
This is a tool to convert TSV text to Insert SQL.
It is useful when registering data created in Google Spreadsheets or Excel in a DB.
Select and copy the data created in Google Spreadsheets or Excel, and paste it into the text area at the bottom. When you press the Convert to Insert SQL button, an SQL statement is generated.
The processing is done in the browser, so the data is not sent.
The author is not responsible for any damage caused by using this tool. Please use it only if you agree.
TSV
Please copy and paste the contents created in Excel or Google Sheets.
Enter the column names in the first row.
When you copy and paste table data from Excel or Google Sheets, the delimiter will be a tab character, so you can paste it in TSV format.
Enter the column names in the first row.
When you copy and paste table data from Excel or Google Sheets, the delimiter will be a tab character, so you can paste it in TSV format.
Numbers and these words will not be single-quoted:
NULL, TRUE, FALSE, NOW()
Table name