TriCo

TriCo

This app converts an excel spreadsheet (xls/xlsx) to a table/collection in mysql/mongodb.

TriCo-electron-app

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

mysql.png

mongo.png

Excel Formats Supported

Supported Excel formats are XLS/XLSX

Usage

The Database must already be there. A table name should be provided.

Spreadsheet Format

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

Starting The App

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

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. This app doesn't even establish connection to the internet. A fully standalone app.

not_used
Screenshot 1 Screenshot 1
Screenshot 2 Screenshot 2

Something missing? Edit this app.

Keyboard Shortcuts

Key Action
/ Focus the search bar
Esc Focus the search bar and cleans it
Select the next search result
Select the previous search result
Enter Open the selected search result
cmdEnter Ctrl+Enter Open the selected search result in a new tab