> ## Documentation Index
> Fetch the complete documentation index at: https://docs.unifygtm.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bulk update records

> Use Salesforce reports to quickly update many records in Salesforce.

## Explanation

If you need to update many records in Salesforce, you can use Salesforce reports to simplify the process. A common use case is updating the value of a field across all records created by a Play. However, these steps are generally applicable to any set of Salesforce records.

## Steps

### Export the records

1. Navigate to the **Reports** page.

<Tip>
  In the top-right corner of the screen, if you click the menu icon and search for “reports”, you should see a link to get there.

  <Frame>
    <img src="https://mintcdn.com/unify-19/hCdysogYM6qFbUs-/images/export-the-records-step-1.png?fit=max&auto=format&n=hCdysogYM6qFbUs-&q=85&s=afef402ff19f40bf04f6837b7df2c779" alt="export-the-records-step-1" width="668" height="482" data-path="images/export-the-records-step-1.png" />
  </Frame>
</Tip>

2. In the top-right corner of the screen, select **New Report**
3. Choose a report type based on which type of records you need to update, and then click **Start Report** on the right

<Frame>
  <img src="https://mintcdn.com/unify-19/Y_pp7r30tEdafKDG/images/export-the-records-step-3.png?fit=max&auto=format&n=Y_pp7r30tEdafKDG&q=85&s=9f9db7eec6f1d5845e8b2efecd7484a2" alt="export-the-records-step-3" width="2622" height="1258" data-path="images/export-the-records-step-3.png" />
</Frame>

4. Be sure to add the `Id` column to your report in the sidebar, which is typically named after the record type you are selecting (e.g., `Account ID`, `Contact ID`, etc.)

<Frame>
  <img src="https://mintcdn.com/unify-19/Y_pp7r30tEdafKDG/images/export-the-records-step-4.png?fit=max&auto=format&n=Y_pp7r30tEdafKDG&q=85&s=707665a70b65177b856771e1e5a9ebdd" alt="export-the-records-step-4" width="594" height="716" data-path="images/export-the-records-step-4.png" />
</Frame>

5. Also add any additional columns that you wish to edit on the records
6. Add any filters or sorting options needed to narrow down the records you want to update

<Frame>
  <img src="https://mintcdn.com/unify-19/Y_pp7r30tEdafKDG/images/export-the-records-step-6.png?fit=max&auto=format&n=Y_pp7r30tEdafKDG&q=85&s=b47175c0f6adf7f944d2063838e820fa" alt="export-the-records-step-6" width="2964" height="1394" data-path="images/export-the-records-step-6.png" />
</Frame>

7. When ready, click **Save** in the top-right corner, enter a name, and then click **Save** again

<Frame>
  <img src="https://mintcdn.com/unify-19/Y_pp7r30tEdafKDG/images/export-the-records-step-7.png?fit=max&auto=format&n=Y_pp7r30tEdafKDG&q=85&s=4a2b828199bff9fad92ab18436226f98" alt="export-the-records-step-7" width="2108" height="1086" data-path="images/export-the-records-step-7.png" />
</Frame>

8. Click **Run** in the top-right corner and verify these are the records you want to update
9. Click the dropdown arrow next to **Edit** in the top-right corner and select **Export**
10. Choose **Details Only** and **Comma Delimited .csv** as the format and then click **Export**

<Frame>
  <img src="https://mintcdn.com/unify-19/Y_pp7r30tEdafKDG/images/export-the-records-step-10.png?fit=max&auto=format&n=Y_pp7r30tEdafKDG&q=85&s=18860ea151699b3c55d3a024596d9222" alt="export-the-records-step-10" width="1322" height="1010" data-path="images/export-the-records-step-10.png" />
</Frame>

### Make changes

1. Open the downloaded file and make any desired updates to the values
2. Save the changes as a new file so that the original is available as a backup

### Upload the changed records

1. Navigate to the **Setup** page in Salesforce

2. In the sidebar on the left, search for "data import wizard" and select the **Data Import Wizard** integration

3. Follow the on-screen instructions to update existing records and be sure to choose the option to match records by `Salesforce.com ID`

<Frame>
  <img src="https://mintcdn.com/unify-19/QTxNj2fcd-br9FnE/images/upload-the-changed-records-step-3.png?fit=max&auto=format&n=QTxNj2fcd-br9FnE&q=85&s=748aa079e1209ae40917e693b3ac6fd0" alt="upload-the-changed-records-step-3" width="2960" height="1464" data-path="images/upload-the-changed-records-step-3.png" />
</Frame>

4. Ensure the mapping looks correct and that the ID column is mapped to `Salesforce.com ID`

<Frame>
  <img src="https://mintcdn.com/unify-19/QTxNj2fcd-br9FnE/images/upload-the-changed-records-step-4.png?fit=max&auto=format&n=QTxNj2fcd-br9FnE&q=85&s=804c196b99314f990ca59dc55c3093e9" alt="upload-the-changed-records-step-4" width="2962" height="1468" data-path="images/upload-the-changed-records-step-4.png" />
</Frame>

5. Verify the details on the last page and then click **Start Import**

<Frame>
  <img src="https://mintcdn.com/unify-19/QTxNj2fcd-br9FnE/images/upload-the-changed-records-step-5.png?fit=max&auto=format&n=QTxNj2fcd-br9FnE&q=85&s=664b6da549b8ca2996c3e210cff98d10" alt="upload-the-changed-records-step-5" width="2960" height="1460" data-path="images/upload-the-changed-records-step-5.png" />
</Frame>

6. Once this bulk import is complete you’re all finished!
