---
schema_version: "1"
id: 38181071ce9c8908a7750caa46df443ce0a9aa63b20b577203970e0065b3db02
title: How do I update fields with blank values?
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/faq_import_general_update_blank_fields.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.faq_import_general_update_blank_fields.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: fa56151877cf097cd09b7e44f22b0ef0f855c4427ede47ec49c7c0d566bab7a0
description: To replace fields with null values, you must use Data Loader.
products:
  - Salesforce Platform
  - Cross Cloud
release: "264"
---
# 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.