--- title: Updating Existing Records in Salesforce description: Understand how to update records present in your Salesforce org. --- [Skip to content](https://knowledge.xappex.com/updating-existing-records-in-salesforce#main-content) English Show submenu for translations ![Xappex-logo-with-name.png\]](https://knowledge.xappex.com/hs-fs/hubfs/Xappex-logo-with-name.png?height=40&name=Xappex-logo-with-name.png) - [Products](https://knowledge.xappex.com/updating-existing-records-in-salesforce#products) - [Blog](https://knowledge.xappex.com/updating-existing-records-in-salesforce#blog) - [About](https://knowledge.xappex.com/updating-existing-records-in-salesforce#about) Open main navigation Close main navigation - [Products](https://knowledge.xappex.com/updating-existing-records-in-salesforce#products) - [Blog](https://knowledge.xappex.com/updating-existing-records-in-salesforce#blog) - [About](https://knowledge.xappex.com/updating-existing-records-in-salesforce#about) - English Show submenu for translations - Go to xappex.com Go to xappex.com Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Xappex Knowledge Base](https://knowledge.xappex.com/?hsLang=en) 2. [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en) 3. [I use XL-Connector 365](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector-365) # Updating Existing Records in Salesforce ## Understand how to update records present in your Salesforce org. To update records in Salesforce in bulk, you will first need to pull them to your Excel spreadsheet. You can do it using either [SOQL](https://www.xappex.com/docs/enabler4excel/basic-features/importing-data-from-salesforce-com-using-soql/) or [Reports](https://www.xappex.com/docs/enabler4excel/basic-features/importing-data-from-salesforce-com-reports/). You can retrieve your data with any other tool or directly from Salesforce by exporting a report too. The main thing to remember is that you need to have record Ids in order to be able to update the records. In our example here we’ll use XL-Connector to update the stage of all opportunities under one specific account. We’ll use the following query to pull the data: *SELECT Name,Id, StageName FROM Opportunity WHERE Account.Name = ‘AVL GmbH’* Please note that we’re pulling record IDs. Even though a column of record IDs is required to be able to update records via Salesforce.com API, XL-Connector 365 has a built in feature to convert unique record names into Ids. Please see the following article on details about that: [Using Record Names Instead of Ids in ID and Lookup Fields](https://www.xappex.com/docs/enabler4excel365/using-record-names-instead-of-ids-in-id-and-lookup-fields-2/) We got the following results back from our sample database: ![](https://www.xappex.com/wp-content/uploads/2017/09/Opportunities.png) Now we want to change the stage of all four Opportunities to Closed Won. After the stage has been changed we’ll select the rows of data so that the selection spans across all the records that we want to update: ![](https://www.xappex.com/wp-content/uploads/2017/09/Opportunities_selected.png) Then click **Create/Modify -\> Update all/Update Selected** in the Home tab of the XL-Connector 365 main window: ![](https://www.xappex.com/wp-content/uploads/2022/03/Update_button.png) In the Update screen, select *Opportunity* as the object to work with and click on **Mappings manager**: ![](https://www.xappex.com/wp-content/uploads/2020/08/object_sel.png) In the Mappings dialog box, make sure you map your columns to the correct fields in Salesforce. The column with record Ids must be mapped to the Id field in order for the Update operation to work. Click on **Apply** when the mappings are done: ![](https://www.xappex.com/wp-content/uploads/2020/08/mappings-1.png) You can define [constant mappings](https://www.xappex.com/docs/enabler4excel365/mapping-fields-to-constant-values/) and [owner change settings](https://www.xappex.com/docs/enabler4excel365/owner-change-settings/) in the Mapping page of each flow step. Any manual push operation will be saved the mappings and other settings in a reusable “Flow Step” that can be later run separately or as a part of a larger Flow. The following setting determines the behavior of the flow step if the operation returns at least one error: ![](https://www.xappex.com/wp-content/uploads/2022/03/ask_user.png) ![](https://www.xappex.com/wp-content/uploads/2022/03/continue.png) ![](https://www.xappex.com/wp-content/uploads/2022/03/stop.png) There are also several options that you can adjust for each Upsert operation and the associated flow step: ![](https://www.xappex.com/wp-content/uploads/2022/03/options-2.png) Click on **Run and Save** to run the Update operation according to the provided settings and save all the settings as a reusable Flow Step. In this case you’ll be able to run the same Update operation again from the same area in your sheet with a single click on the *Run Flow* or *Run Flow Step* button. Click **Run** to only run the Update operation of the selected data and not save the mappings and other settings as a reusable Flow Step. Click **Save** to save all the provided settings as a reusable Flow Step. In this case you’ll be able to run the same Update operation again from the same area in your sheet with a single click on the *Run Flow* or *Run Flow Step* button. After the operation is completed, all operation results, along with the updated record Ids will be written on the right from your data, one column over: ![](https://www.xappex.com/wp-content/uploads/2020/08/results-1.png) - [I use Google Sheets](https://knowledge.xappex.com/i-use-google-sheets?hsLang=en) - [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#main-content) - [FAQs](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#faqs) - [I use XL-Connector](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector) - [I use XL-Connector 365](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector-365) - [I use Excel Merge package](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-excel-merge-package) - [I use Looker Studio](https://knowledge.xappex.com/i-use-looker-studio?hsLang=en) - [Products](https://knowledge.xappex.com/updating-existing-records-in-salesforce#products) - [Blog](https://knowledge.xappex.com/updating-existing-records-in-salesforce#blog) - [About](https://knowledge.xappex.com/updating-existing-records-in-salesforce#about) [![Chill listening crop-3](https://knowledge.xappex.com/hubfs/Xappex-Logo.svg "Chill listening crop-3")](https://www.xappex.com) xappex.com Help Center Copyright © 2026, Xappex LLC