This App Converts your correctly formatted Excel Spreadsheet to a specified table/collection in specified Database in MYSQL/MongoDB.

1. Dump your excel/csv sheet into your preferred your DB.
2. Batch Files support
3. Do not want to dump the whole file? You can also try selecting a range of columns and rows.
4. Automaticaly add id as primary key (MySQL)
5. Scared of loosing your DB? Safe mode backs up the db before processing.
6. Dump the excel sheet into a .sql instead (MySQL)
7. History Maintainance.

Supported Excel formats are XLS/XLSX/CSV

Please have a look at the sample Excel sheets provided to have a clear view of the File. Microsoft Sample Sheet

sudo npm install -g electron
git clone https://github.com/ngudbhav/TriCo-electron-app.git
cd TriCo-electron-app
npm install
npm start

Electronjs

P.S. This app saves the previosuly entered information in the systems %APPDATA% directory so that the whole information is not typed again. NOTHING is collected by me. Also, this app establishes connection to the internet to check for the updates.