How to import an excel file in to a MySQL database

by

There’s a simple online tool that can do this called sqlizer.io.

Screenshot from sqlizer.com

You upload an XLSX file to it, enter a sheet name and cell range, and it will generate a CREATE TABLE statement and a bunch of INSERT statements to import all your data into a MySQL database.

(Disclaimer: I help run SQLizer)

More Related Contents:

  1. How to reduce the size of google spreadsheet using SQL?
  2. Exporting results of a Mysql query to excel?
  3. How can VBA connect to MySQL database in Excel?
  4. How to save MySQL query output to excel or .txt file? [duplicate]
  5. MySQL export into outfile : CSV escaping chars
  6. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  7. Why does MYSQL higher LIMIT offset slow the query down?
  8. How to split the name string in mysql?
  9. Normalization in MYSQL
  10. Is there a REAL performance difference between INT and VARCHAR primary keys?
  11. How to recover MySQL database from .myd, .myi, .frm files
  12. How do I do a fuzzy match of company names in MYSQL with PHP for auto-complete?
  13. how to compute similarity between two strings in MYSQL
  14. Timestamp with a millisecond precision: How to save them in MySQL
  15. Cast int to varchar
  16. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  17. Import SQL file into mysql
  18. MySQL SELECT last few days?
  19. “where 1=1” statement [duplicate]
  20. How do you debug MySQL stored procedures?
  21. MySQL Calculate Percentage
  22. ld: library not found for -lzstd while bundle install for mysql2 gem Ruby on macOS Big Sur 11.4 Apple M1
  23. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  24. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  25. Postgres LEFT JOIN with WHERE condition
  26. MySQL – Using COUNT(*) in the WHERE clause
  27. MySql Query Replace NULL with Empty String in Select
  28. How to handle a query with special characters / (forward slash) and \ (backslash)
  29. Does MySQL support historical date (like 1200)?
  30. mySQL query to search all tables within a database for a string?

Leave a Comment