---
title: "Editing users in bulk in Users & Compliance (classic UI)"
slug: "bulk-edits-in-users-compliance"
description: "Classic UI: change many users' signature data at once with a CSV file in Users & Compliance, and lock, unlock, or break the sync on whole columns."
updated: 2024-01-14T01:08:40.000Z
canonical: "https://help.opensense.com/docs/bulk-edits-in-users-compliance"
---

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

# Editing users in bulk in Users & Compliance (classic UI)

:::note[Classic UI]
This article covers the classic Opensense UI. In the New UI, user profiles are under **Manage** > **Users**.
:::

## 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](https://help.opensense.com/docs/editing-user-data-guide).


## Editing users in bulk

1. Create a CSV file with `username` and 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**.

   <img src="https://help.opensense.com/media/bulkedits1-702772dc9191.png" alt="A spreadsheet with the columns username and phone, and four users' new phone numbers" width="476" height="234" loading="lazy" decoding="async">

2. In the **Signatures** menu, select **Users & Compliance**.
3. On the left of the page, select **Sync Tools**.

   <img src="https://help.opensense.com/media/bulkedits2-6d310043a03f.png" alt="The Users and Compliance search panel, with Advanced Options, Filter by CSV, and Sync Tools below it" width="337" height="523" loading="lazy" decoding="async">

4. Under **Bulk CSV Sync**, select **Choose File**, and choose your file. Make sure that the spreadsheet is saved as a CSV file.

   ![A Save As dialog with Save as type set to CSV (Comma delimited)](https://help.opensense.com/media/bulkedits3-fdcf7a3adc20.png)

5. Select **Sync CSV**.

   <img src="https://help.opensense.com/media/bulkedits4-7d389a70eab1.png" alt="The message CSV looks OK, above the Sync CSV button" width="294" height="134" loading="lazy" decoding="async">

6. When the sync is finished, refresh the browser.
7. Check that the sync worked, by looking for your changes in **Users & Compliance**.

:::tip[Less is more]
Only upload the usernames and the data that you want changed.
:::

## 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**:

<dl class="kb-insights-summary">
  <div><dt><code>-locked</code></dt><dd>Locks all the field data in the column (for example, <code>title-locked</code>).</dd></div>
  <div><dt><code>-unlocked</code></dt><dd>Unlocks all the field data in the column (for example, <code>name-unlocked</code>).</dd></div>
  <div><dt><code>-nosync</code></dt><dd>Breaks the sync on all the field data in the column (for example, <code>phone-nosync</code>).</dd></div>
</dl>

![A spreadsheet with the column headers username, name-locked, title-unlocked, and phone-nosync, and one row of data for jane.doe](https://help.opensense.com/media/bulkedits5-608072675287.png)

## What's next

- [Editing one user in Users & Compliance (classic UI)](https://help.opensense.com/docs/individual-edits-in-users-compliance)
- [Locking and unlocking Compliance fields (classic UI)](https://help.opensense.com/docs/locking-unlocking-compliance-fields)