Welcome to Zuora Product Documentation

Explore our rich library of product information

Nulling field values with in Data Loader

The article instructs on how to set field values to null using Data Loader by following a series of steps, including creating a job, selecting the update operation, and modifying a CSV template.

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:

  1. Click + New to create a new job drop-down.
  2. Select the Update operation.
  3. Choose the appropriate template for the object you want to update.
  4. Click Download CSV Template .
  5. 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:

Sample File 1

Sample File 2