Salesforce Docs Portal

How do I update fields with blank values?

To replace fields with null values, you must use Data Loader.

  1. To open Data Loader, choose Start | All Programs | Salesforce | Data Loader | Data Loader.
  2. Click Export and complete the wizard. When the operation finishes, click View Extraction.
  3. To open your data in Excel, click Open in external program. Blank out the fields you want to update.
  4. In Data Loader, choose Settings | Settings, and select Insert null values. To save your settings, click OK.
  5. To reimport your data, click Update and follow the instructions.