Nulling Fields Using Data Loader
Nulling a field means setting its value to blank or removing the existing value. With Data Loader, you can null field using the Update action. Follow these steps to null field values:
- Click + New to create a new job dropdown.
- Select the Update operation.
- Choose the appropriate template for the object you want to update.
- Click Download CSV Template.
- In the downloaded CSV file:
- Enter True in the IsMarker column (if applicable for the object).
- Provide a valid Record ID for each row — this is mandatory for updates.
- Select and retain only the columns you want to update.
- For the fields you want to null, type the word Null in the corresponding cells.
You can delete unused columns from the template to simplify the file.
- You can combine field updates and nulling in a single job — Data Loader supports updating and nulling different fields in the same record.
- Make sure the field you are nulling is not a required field in the schema.
- If you are nulling a custom field, make sure its default value is blank. Else, Data Loader will reset the field to its default value instead of keeping it blank.
Sample Files: