ExcelToMySQL is a command-line tool that simplifies the process of converting data from Excel files (XLSX) into MySQL database tables. This tool is designed to streamline the migration of structured data from Excel spreadsheets into a MySQL database, making it easier for users to work with their data in a database environment.
Please ensure that your Excel data is saved in CSV format before using this tool for optimal compatibility.
- Convert Excel data into MySQL statments
- Automatically infer data types based on the content of Excel columns.
- Handle empty cells gracefully.
- Command-line interface.
npm run cli <csvFile>
Contributions are welcome! Feel free to open issues, submit pull requests, or suggest enhancements.