Mongo db : data uploaded using CSV has Null stored as String in Mongo document

Question

I tried uploading data into Mongodb using CSV from Mongodb Compass. In the CSV, some of the fields have Null values stored in them. But, after uploading those fields in Mongo, documents have "Null" stored as String. Is there a way to store Null fields from CSV with the type Null?

R2D2 · Accepted Answer · 2020-12-30 08:56:25Z

1

You can correct easily later:

db.contacts.update({a:"Null"}, {$set: {a: null}},{multi:true} )

or you can remove those fields from the document:

db.contacts.update({a:"Null"}, {$unset: {a:1}},{multi:true} )

answered Dec 30, 2020 at 8:56

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Avani Khabiya Over a year ago

I wanted a solution at the time of insertion itself. There are thousands of documents (which will grow later on), don't want to update using query. Though, if it's the only solution will proceed with this.

R2D2 Over a year ago

unfortunately mongoimport has no option yet to understand that "Null" string from csv need to be interpreted as null ...

Avani Khabiya · Accepted Answer · 2021-03-11 09:29:38Z

1

I couldn't find a solution to import the data with NULL values using CSV and have them stored with datatype NULL in Mongodb. Then I imported the same data using JSON and it worked!! Importing data using JSON makes it to interpret NULL as NULL datatype, not as string.

answered Mar 11, 2021 at 9:29

Avani Khabiya

1,3382 gold badges16 silver badges38 bronze badges

Collectives™ on Stack Overflow

Mongo db : data uploaded using CSV has Null stored as String in Mongo document

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related