Excel → SQL INSERT Generator

Drop your Excel or CSV table; copy the ready-made CREATE TABLE and INSERT INTO statements.

Runs 100% in your browser — your file is never uploaded to a server.
Drop your file here or click to choose
Supported formats: .xlsx, .xls, .csv — the first row is treated as column names

        


      

    


    
Try This Next
Finished here? These might be your next step.
Excel → JSONConvert .xlsx, .xls and .csv files to JSON.CSV ↔ ExcelCSV ↔ Excel conversion without character or delimiter problems.JSON → ExcelConvert your JSON data into an .xlsx or CSV file.

      
Frequently Asked Questions

      
All values in each column are examined: if they're all integers, INT is chosen; if they're numeric, DECIMAL(18,4); if any text exceeds 255 characters, TEXT; otherwise VARCHAR(255). You can adjust these after generation to fit your needs.
Single quotes in text are written as '', and in the MySQL dialect backslashes are also escaped. Empty cells become NULL. Even so, we recommend reviewing the generated SQL before running it.
Last updated: