How can I change field values to blank/null on import update?

When you run an Import Update, blank or null values in your upload file will be ignored. There may be times, however, where you may want to update a field value to be blank. To accomplish this, you must make a change in your Org Settings.

About this task

Note: This will change this setting for ALL imports, not just the current job, so you may not want to leave this setting on permanently.

Procedure

  1. Select Organization Settings.
  2. Expand General Settings.
  3. Click Edit.
  4. If checked, deselect the On import, do not overwrite existing field values with blank/null values option.
  5. Click Save.