TriCo

TriCo

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

TriCo-electron-app

Release Dependencies Downloads Last-Release Platforms

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

Do checkout the upcoming features in CHANGELOG.md

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

Installing The App

Setup.exe => Full Windows install
Portable.exe => Unzip and run the exe.
Setup.deb => Installable on Debian distributions (Ubuntu, Kali, etc.)
Setup.rpm => Installable on Red Hat distributions (Fedora, etc.) 

Software Featured on Softpedia and Electronjs

Softpedia Link Electronjs Link

Do rate and give Feedback!

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.

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