MongoDB Compass导入CSV时如何将Null值存储为Null类型而非字符串

I’ve run into this exact issue multiple times when importing CSVs into MongoDB via Compass—those string "Null" values can be frustrating, but there are a few straightforward ways to fix this:

Option 1: Preprocess Your CSV Before Import #

This is the simplest approach if you have access to a spreadsheet tool:

• Open your CSV in Excel, Google Sheets, or LibreOffice Calc
• Use the find-and-replace feature to locate all instances of the string "Null" and replace them with empty cells (just delete the content, don’t leave any spaces)
• Save the cleaned CSV file, then re-run the import in Compass. Empty CSV cells will automatically be mapped to MongoDB’s null type.

Option 2: Use Compass’s Import Wizard to Transform Values During Import #

If you don’t want to edit the CSV directly, Compass lets you add custom transformations during the import flow:

1. Start the import process in Compass by selecting your CSV file and confirming delimiter settings
2. When you reach the Schema step (where Compass shows the inferred field types), find each field that’s bringing in "Null" strings
3. Click the Type dropdown for that field and select Custom
4. In the transformation input box, paste this JavaScript expression:

   value === "Null" ? null : value
   

   This checks if the field value is the string "Null" and converts it to a proper null; all other values stay unchanged.
5. Repeat this for every affected field, then finish the import as normal.

Option 3: Batch Update Existing Documents (If You Already Imported the Data) #

If you already have the data in your collection with string "Null" values, you can fix them with a quick MongoDB shell command:

1. Open your collection in Compass, then launch the MongoSH shell from the top menu
2. Run this update command (replace yourCollection and yourField with your actual collection and field name—repeat for each field that needs fixing):

   db.yourCollection.updateMany(
     { yourField: "Null" },
     { $set: { yourField: null } }
   )
   

   This will find all documents where yourField equals the string "Null" and replace it with MongoDB’s native null type.

内容的提问来源于stack exchange，提问作者Avani Khabiya