How to convert Excel to SQL

Sometimes you want to take the contents of an Excel .xlsx or .xls file and store it in a relational database using SQL. You can do this easily using Easy Data Transform:

Excel to SQL

In the right pane add the SQL command in Substitution script, leaving gaps where the values from the columns in the CSV files will go. Then insert the column values into the text using the Insert variable drop-down list. Set New column name to ‘SQL’.

convert Excel to SQL

Click Evaluate when you are done. An ‘SQL’ column is added at the end of the table.

convert Excel file to SQL

Set the table to Show all rows, click on the ‘SQL’ column to select it and copy it to the clipboard using Ctrl+C (Windows)/Cmd+C (Mac).

convert xlsx to SQL

You can now paste the SQL where you need it.

If you have large number of files to convert you can do it using the batch processing feature.

Substitute is one of the 52 transforms in Easy Data Transform you can use to quickly and easily create a wide range of data transformations. See our quick start guide for more details.

CSV to HTML converter

Try it free now!

Windows Logo Windows Download

v1.18.0 for Windows 10 / 8 / 7 (36 MB)

Apple Logo Mac Download

v1.18.0 for Mac 11.x to 10.13 (36 MB)

Questions or problems?


Do you have a question?
We would love to help.

This pop-up will not be shown again