exceltomongo

Save data from excel to mongo

Usage no npm install needed!

<script type="module">
  import exceltomongo from 'https://cdn.skypack.dev/exceltomongo';
</script>

Create collections with sheet name and insert records in the respective collection.

Set the options for the DB along with the name/location of the workbook to extract data from.

let e2m = require('exceltomongo');

options = { url: 'mongodb://localhost:27017', db: 'mydb', workbook: 'sample.xlsx'}

e2m(options, (err, result) => { if (err) throw err; console.log(result); });