Editing users in bulk in Users & Compliance (classic UI)
Overview
Section titled “Overview”Use a CSV file to change signature data for many users at once in Users & Compliance. To choose between this and the other ways to edit user data, see Choosing how to edit user data.
Editing users in bulk
Section titled “Editing users in bulk”-
Create a CSV file with
usernameand the field, or fields, you want to edit. The column headers should match the field names in your signature, and all field names must be lowercase.
-
In the Signatures menu, select Users & Compliance.
-
On the left of the page, select Sync Tools.
-
Under Bulk CSV Sync, select Choose File, and choose your file. Make sure that the spreadsheet is saved as a CSV file.
-
Select Sync CSV.
-
When the sync is finished, refresh the browser.
-
Check that the sync worked, by looking for your changes in Users & Compliance.
CSV commands for bulk changes
Section titled “CSV commands for bulk changes”A few CSV commands make bulk changes to a whole column. Add them after the field name in the column header, in the format field-command:
-locked- Locks all the field data in the column (for example,
title-locked). -unlocked- Unlocks all the field data in the column (for example,
name-unlocked). -nosync- Breaks the sync on all the field data in the column (for example,
phone-nosync).
