How to update user work details in bulk

Problem

How can you change your users work address in bulk?

Environment

  • Admin console 
  • User and Organizational Level Management

Solution

To edit work address in bulk:

  1. Open your Admin console.
  2. Go to Menu > Directory > Users.
  3. At the top of the page, click Bulk update users.
  4. Click Download User Info In CSV File to download a comma-separated values (.csv) file with all user accounts.

    Your Tasks list opens automatically and shows the progress of the download.

  5. Under Your Tasks, click Download CSV.
  6. Open the CSV file in a spreadsheet application, such as Google Sheets or Microsoft Excel.

    The file has columns for the attributes in each user's profile.

  7. Edit the information in the file.
  8. In the Work Address column make sure you don't put commans in between as it will create a new Address line if you include commas.
  9. After you've filled in the spreadsheet, save it as a CSV file.
  10. At the top of the Users page, click Bulk update users.
  11. Click Attach CSV file.
  12. Browse to the location on your computer and attach the CSV file.
  13. Click Upload.