SQLizer Logo

Easily convert files into SQL databases

Converting Excel Spreadsheets Using SQLizer

SQLizer can convert both .XLSX and .XLS spreadsheets into SQL scripts. This page describes some of the options available when converting.

Data Selection

When you upload a spreadsheet file to SQLizer, default behavior will be to load all the data it can find on the 'Active' worksheet. In other words, the worksheet that was open when the file was last saved. If you want SQLizer to load some other data (or you just want to be specific about which worksheet to load), you can specify a Worksheet name by unticking the 'Use the active worksheet' checkbox and typing a worksheet name:

SQLizer can also be told to load data from a specific cell range in the spreadsheets by unticking the 'Convert the whole worksheet' checkbox and entering a cell range:

When using the SQLizer API, the 'SheetName' and 'CellRange' properties can be used to achieve the same effect.