Search
Clear search
Close search
Google apps
Main menu

Download a list of users

You can download a list of all users in your domain, or create a list filtered by user type (such as active, invited, or suspended users) or by organization. You can download the user list as a comma-separated value (CSV) file, or you can create the user list in a Google spreadsheet.

To create a filtered user list, your domain must have fewer than 10,000 users.

  1. Sign in to your Google Admin console.

    Sign in using your administrator account (does not end in @gmail.com).

  2. From the Admin console dashboard, go to Users.
  3. (Optional) If you need to filter the user list by type or organization, follow these steps:

    Tip: If your organizational units aren't visible, click Filter Filter to see them.

    1. Select a type from the User Type drop-down menu.
    2. Select an organizational unit.
  4. At the top of the Users page, click More More and choose Download users.
    1. Select Download the filtered list of users to filter by user type or by organization.
    2. Select Download all users to include all users, including suspended users.
  5. Download the list.
    1. Check the Google spreadsheet box to download the list as a Google spreadsheet.
    2. Leave the box unchecked to download the list as a CSV file.
  6. Click Ok.

    If you selected Download the filtered list of users, the results show each user's email address, first name, last name, last login, first login, status, email usage, drive usage, total storage, organization name, 2-Step Verification enrollment, and 2-Step Verification enforcement.

    If you selected Download all users, the results show each user's email address, first name, last name, last login, first login, 2-Step Verification enrollment, and 2-Step Verification enforcement.

Was this article helpful?
How can we improve it?
Sign in to your account

Get account-specific help by signing in with your G Suite account email address, or learn how to get started with G Suite.