how to import excel file (XLSX) to mongoDB

mongodb import import-from-excel
SUNDARRAJAN K picture SUNDARRAJAN K · Aug 11, 2014 · Viewed 66.9k times · Source

I have a set of data as input to be given to MongoDB in XLSX format. How am I supposed to import the Excel file as input to MongoDB?

Is there any plugin available to import xlsx files as input to MongoDB?

Answer

Juan Carlos Farah picture Juan Carlos Farah · Aug 11, 2014

You cannot import an XLSX file into MongoDB directly. However, what you can do with an Excel spreadsheet is save it as a CSV file, then use mongoimport to import it into MongoDB. You can find the documentation for mongoimport here, but in any case, the command you need to run should look something like the following:

mongoimport --db myDb --collection myCollection --type csv --headerline --file /path/to/myfile.csv

In the command above, the --headerline flag indicates that the first line in your file contains the name of the fields. There are many other options you can use depending on your needs. These are highlighted in the documentation.

Related questions

Mongoimport of json file

I have a json file consisting of about 2000 records. Each record which will correspond to a document in the mongo database is formatted as follows: {jobID:"2597401", account:"XXXXX", user:"YYYYY", pkgT:{"pgi/7.2-5":{libA:["libpgc.so"],flavor:["default"]}}, startEpoch:"1338497979", runTime:"1022", …

Read More
How to use mongoimport to import csv

Trying to import a CSV with contact information: Name,Address,City,State,ZIP Jane Doe,123 Main St,Whereverville,CA,90210 John Doe,555 Broadway Ave,New York,NY,10010 Running this doesn't seem to add any documents to the database: $ mongoimport -d mydb …

Read More
how do i import data into mongodb from sql server?

how do i import data into mongodb from sql server? i have these tables in sql database with following columns States, Cities, CityAreas States Id Name Cities Id Name StatesId CitiArea Id Name CityId and I want data in mongoDb …

Read More