# Update members

Edit one member's profile, change a category for several members at once, or update your whole member list with an exported file.

import { Steps } from '@prosefly/astro-components';
import Callout from '@components/Callout.astro';
import MemberProfile from '@components/app-screens/screens/MemberProfile.astro';
import MembersActions from '@components/app-screens/screens/MembersActions.astro';
import GroupedModification from '@components/app-screens/screens/GroupedModification.astro';

You can update your members' details in three ways:

- [one member](#update-one-member), from their profile page;
- [a few members at once](#update-several-members-at-once), with the "Grouped modification" action;
- [your whole list](#update-your-whole-list-with-a-file), by exporting it, editing the file and uploading it again.

To change a member's status, see [Active and inactive members](/admin/members/active-and-inactive-members/). To give or remove admin rights, see [Administrators and members](/admin/administrators/administrators-and-members/).

## Update one member

<Steps>

1. **Open the member's profile.**

   In "People" > "All members", click the member's name.

2. **Click "Edit".**

   A panel opens with the member's details.

3. **Change the values you want, then click "Save".**

   <MemberProfile variant="edit" alt="A member's profile page with the Edit panel open, showing the First Name, Last Name and Email fields and the member's categories" />

</Steps>

<Callout type="note">
  You cannot change a member's email address from this panel: the field is greyed out. For members provisioned with [SCIM](/admin/members/provision-with-scim/), the first and last names are greyed out too.

  Categories managed by an integration, such as your [HRIS](/admin/members/sync-from-hris/) or Slack, do not appear in this panel: they are updated by the integration.
</Callout>

## Update several members at once

<Steps>

1. **Select the members.**

   In "People" > "All members", tick the box next to each member to update.

2. **Open the "Actions" menu and click "Grouped modification".**

   <MembersActions highlight="edit" alt="The All members list with four members selected and the Actions menu open on Grouped modification" />

3. **Choose the fields to update.**

   In "Search for additional fields you want to edit", keep only the categories you want to change.

4. **Enter or select the new value of each field.**

   <GroupedModification alt="The Grouped modification window, with the Department, Years of experience and City fields" />

5. **Click "Save".**

   The change applies to all the selected members. You are taken to "People" > "History", where you can follow it.

</Steps>

"Grouped modification" changes [categories](/admin/categories-and-audiences/categories/) only, except the categories managed by an integration. It is available once your workspace has at least one category. It does not change your own profile: to update your details, open your profile in "People" > "All members" and click "Edit".

## Update your whole list with a file

When you upload a CSV file of members, RandomCoffee **adds or updates the members in the file**. It does not replace your list: the members who are not in the file stay in your workspace, unchanged. No data is lost.

### Export your member list

<Steps>

1. **Select all your members.**

   In "People" > "All members", tick the box at the top of the list, next to "Name", then click "Select all members".

   By default, the list only shows active members. To export inactive members too, change the "Status" filter first (see [Check a member's status](/admin/members/active-and-inactive-members/#check-a-members-status)).

2. **Open the "Actions" menu and click "Export in .xls".**

   Your member list is sent to you by email.

</Steps>

### Edit the file

Open the file and make the changes you want.

**Update values for existing members** by changing them in the file. In the example below, the changed values are highlighted.

![An exported member list where some city and department values were changed](../../../../../assets/articles/update-members/file-update-values.jpg)

**Add new members** by adding new rows.

![The same file with two new rows at the bottom](../../../../../assets/articles/update-members/file-add-members.jpg)

**Add new categories** by adding new columns. If you do not know a value for every member, leave the cell empty: it shows as `N/A` in your member list.

![The same file with a new Hobby column](../../../../../assets/articles/update-members/file-add-category.jpg)

### Upload the updated file

<Steps>

1. **Save your file in CSV format.**

2. **Upload it.**

   In "People" > "All members", click "Add new members", then follow the steps of the "Upload a member list" tab, as described in [Add members with a CSV file](/admin/members/add-members-manually-or-by-csv/#add-members-with-a-csv-file).

</Steps>

Once the file is processed, your member list shows your changes.

<Callout type="note">
  If you turn on "Send a welcome email (optional)", only the **new** members of your file receive it.
</Callout>

### Deactivate or reactivate members with a file

To deactivate (or reactivate) many members at once:

<Steps>

1. **Export your member list**, as described above.

2. **Add a column** called "To deactivate" (or "To reactivate").

3. **Write "YES"** in this column for each member to deactivate (or reactivate).

4. **Upload the file**, and create a new category for this column when you map the columns.

5. **Filter your member list** on this category: in the filters at the top of "People" > "All members", click "Add filter", choose your new category and the value "YES", then click "Search".

6. **Select all the members shown**, then use the "Deactivate members" (or "Activate members") action, as described in [Active and inactive members](/admin/members/active-and-inactive-members/).

</Steps>

<Callout type="tip">
  If you use the [Slack or Microsoft Teams integration](/admin/members/sync-from-slack-or-teams/), your members are synchronized automatically (first name, last name, email). You can still edit their other fields, or upload a CSV file, to enrich your list with new categories for example.
</Callout>
