This module converts your correctly formatted Excel spreadsheet to a specified table in specified database in MYSQL.
Excel Formats Supported
Supported Excel formats are XLS/XLSX
The Database must already be created in MYSQL. A non-existent table name should be provided.
Please have a look at the sample Excel sheets provided to have a clear view of the File. Microsoft Sample Sheet
npm install excel-to-mysql --save
git clonecd excel-to-mysql/
Navigate to the folder.
cd test/nano test.js
Now this file needs the MYSQL credentials. Provide those credentials in String format and save by pressing the following keys.
Get back and test the module.
cd ..npm test
Note: Please correctly format the excel sheet else this won't work.
var excelMysql = require;
This module needs 3 arguments. The first one is the object with your credentials.
var credentials =
The second one is an optional argument of options with default values as follows.
var options =
The third argument is the callback function which should be executed.
Want to use the GUI instead?
We have got you covered! Github Link.