Skip to main content

Use to Update Data

Follow Along with Trail Together

Want to follow along with an instructor as you work through this step? Take a look at this video, part of the Trail Together series on Trailhead Live. 

(This clip starts at the 18:32 minute mark, in case you want to rewind and watch the beginning of the step again.)



This step requires some additional instructions for screen reader users. To access a detailed screen reader version of this step, click the link below:

Open Trailhead screen reader instructions.


You’ve already gotten the gassed up and ready to go. Time to take it for one more spin. In this step, use to update the records you exported in the previous step, filling in site information for the companies on the list to allow the sales team to identify them by their region.

Update Using

Start by clicking here to open the account-site file and save it to your Desktop. 

  1. Ensure the account-site file and the Account Exports file (from the previous step) are open.
  2. Copy and paste the contents of the Account Site column from the account-site file into the blank Site column in the Accounts Export file.
    Moving Site data from account-site spreadsheet to Account Exports spreadsheet
  3. Save the Accounts Export.csv file in CSV format with a different name.

Windows users:

  • With the Accounts Export.csv file open, click File and Save As.
  • Keep the file type CSV (Comma delimited) (*.csv).
    Note: If you are using an international computer the CSV file generated on Excel will most likely not be delimited with commas. You can check if your CSV file delimiter is a comma by opening it with the Notepad app (or equivalent) on your computer. Additionally, the file can also be saved as txt tab-delimited.
  • Change the filename to Updated Account Site Import.
  • Click Save and save the file to your desktop. If needed, click Yes from the pop-up window.
  • Close both files.

Mac users:

  • Ensure that you are in the window with the Accounts Export file, click File > Export To > CSV…
  • Click Next…
  • Save As: Updated Account Site Import.
  • Where: Desktop
  • Click Export.
  • Close Numbers.
  • Close the file.

Google Sheets users:

  • With the Accounts Export.csv file open, click File > Rename.
  • Change the title to Updated Account Site Import.
  • Click File > Download.
  • Select Comma Separated Value (.csv) and ensure this file is on your desktop for easy access.

Now your Updated Account Site Import file is ready to be updated using

  1. With open, click NEW TASK and select IMPORT.
  2. Select Update.
  3. From the Object list, select Account.
  4. Click Next.
  5. Click Upload CSV.
  6. Choose the Updated Account Site Import file from your desktop, and click Open.
  7. Ensure the data is mapping correctly to the existing data.
    CSV mapped to current data

Note: If there are errors, they will be prominently denoted.

  1. Click Next.
  2. Click Save & Run.
  3. Click Run.
  4. The data has been successfully updated when 11 successes, 0 errors is displayed. The window can now be closed.

View the Results

Finally, create a list view to check the import.

  1. Click the App Launcher App Launcher Icon and select Sales.
  2. Click the Accounts tab.
  3. Click the List View Controls icon List View Controls Icon and select New from the dropdown.
  4. Enter Accounts Modified Today as the List Name.
  5. Select Only I can see this list view.
  6. Click Save.
  7. Under Filters on the right, click Add Filter and fill in the criteria:




Last Modified Date


  1. Click Done.
  2. Click Add Filter again and fill in the criteria:

Field = Account Site

Operator = not equal to

Value = (leave this value blank)

Note: The filter value is left blank on purpose. This will filter out any Accounts that do not have Account Sites listed.

Account Site field filter

  1. Click Done.
  2. Click Save.
  3. Note that the 11 accounts you updated today are listed and all now have Account Sites listed.

Turn off your engines, admins—the ride is over. And you’re a great driver! You used the Data Import Wizard and the to import, export, and update records (even doing some mapping along the way). And you’ve added a few new (and speedy) maneuvers to your fleet of awesome admin skills. Motor on!

Keep learning for
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities