Loading

How to Insert or Clear Null Field Values Using Salesforce Data Import Wizard

Udgivelsesdato: Jun 29, 2026
Beskrivelse

The Salesforce Data Import Wizard ignores empty cells in a CSV file during import operations. Instead of clearing (nulling) the value of a field, the wizard treats empty cells as 'no change' instructions. This is important to understand when you intend to remove or blank out existing field values during a data update.

Løsning

Important: Always back up your data before performing any data import operation. Use the Export Backup Data from Salesforce feature or the Data Export option in Setup. It is recommended to run a test import with a small subset of records first to verify results.

To set a field value to null or erase the current value, fill out the column corresponding to the record and field to be updated with #N/A. The exceptions are a checkbox where you have to use 0 for unchecked values and lookup fields as the Import Wizard cannot null a lookup (must use an API tool like the Data Loader).

For example, your CSV file may look like:
 

ContactIDDoNotCallTitle
005xxxxxxxxx0Ta0#N/A
005xxxxxxxxx1ZT1Salesforce Administrator




Yderligere ressourcer

You may refer to the Bulk API Developer Guide - Valid CSV Record Rows document for more details.

For inserting/updating field with null values using Data Loader, refer to Change record values to blank or null with Data Loader.
 

Vidensartikelnummer

000382170

 
Indlæser
Salesforce Help | Article