Skip to navigation
Data managementData LoaderData Loader essentials and setup

Nulling field values with in Data Loader

View as Markdown

The article instructs how to set field values to null by creating a job, selecting the update operation, and modifying a CSV template.

Nulling field values in Data Loader sets a field to blank or removes the existing value. You can null field values using the Update operation.

1

From the main menu, navigate to Administration > Data Loader.

2

Click + New and select Update.

3

Select the appropriate template and select Download CSV Template.

4

In the downloaded CSV file:

  • Enter True in the IsMarker column, if applicable for the object.
  • Enter a valid Record ID for each row. This is mandatory for updates.
  • Retain only the columns to update.
  • For the fields you want to null, enter Null in the corresponding cells.
  • Delete any unused columns from the template.
  • You can update field values and null other fields in the same job.
  • Ensure the field you are nulling is not required in the schema.
  • For custom fields, verify that the default value is blank. Otherwise, Data Loader resets the field to its default value instead of leaving it blank.
5

Upload the updated CSV file and run the job.

  • Sample File 1
  • Sample File 2