Convert Google Sheet/Excel to SQL

Have a lot of data you want to populate into a SQL database? Most likely you have that data in a spreadsheet or can easily put it in one. In this case use the following script I wrote to convert your Spreadsheet data to SQL statements and then import them to your SQL database of choice. All that is required is putting your data in the spreadsheet with headers, exporting to TSV and then updating the script for file names and running it.

Here is the code. Enjoy!

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.