MohammedZ666/node-excel-dumper

Node.js excel to mongodb dumper

Reads an excel file, creates json for each row and dumps all jsons to mongodb.

Create a .env file in the root directory and put

MONGO_URI="YOUR MONGODB DATABASE KEY URI WITHOUT THE SEMICOLONS"
COLL_NAME="YOUR MONGODB COLLECTION NAME WITHOUT THE SEMICOLONS"
FILENAME"YOUR FILENAME WITHOUT THE SEMICOLONS"

Put your excel file under the /data directory.

• npm install in terminal to install
• node index.js in terminal to run