How to Export User List from Google Apps

Author Topic: How to Export User List from Google Apps  (Read 3399 times)

Offline nadir-diu

  • Moderator
  • Full Member
  • *****
  • Posts: 127
  • DIU is the best Cisco Networking Academy !!!!!
    • View Profile
How to Export User List from Google Apps
« on: July 10, 2012, 04:10:49 PM »
Dear all,
There may be a time when you need to export a list of Google Apps users to a .csv (comma separated value) file. Exporting a user list of your Google Apps accounts is helpful when you need to manipulate the data in some way. You can export the list and then import the data using Microsoft Excel or Google Spreadsheet. From there you can modify user's data including names and email addresses.

When you export a list of users in Google Apps the headers in the csv file include; EmailAddress, FirstName, LastName, LastLogin, FirstLogin and Quota. The Quota header is used to indicate the percentage of the mailbox's size is currently being used. Exporting the user list is convenient when you have to bulk change everyone's password for some reason. You can export the Google Apps user list then change the headers to; email address, first name, last name and then add password for the fourth column. Then add a password for your users. Perform a bulk upload of users and then set the password to change upon first login.

How To:
•   Log in to your Google Apps Domain as a user with Super Administrator privileges.
•   Click on Manage this Domain in the upper right of your Email screen.


•   Select the Organization & Users tab up top.



•   Click on More Actions and then select Download as CSV.
•   This will export your current list of users to a .csv file that you may now use to change, modify, add or remove Google Apps users. You can open this list in Microsoft Excel or Google Apps Spreadsheet. The image below shows what the list of users looks like when imported into Google Apps Spreadsheet.



With thanks,


Dr. Md. Nadir Bin Ali
LMC and Head of Cisco Networking Academy
Daffodil International University

Offline rumman

  • Hero Member
  • *****
  • Posts: 1020
  • DIU is the best
    • View Profile
Re: How to Export User List from Google Apps
« Reply #1 on: July 10, 2012, 04:42:19 PM »
Good post.
Md. Abdur Rumman Khan
Senior Assistant Registrar

Offline nadir-diu

  • Moderator
  • Full Member
  • *****
  • Posts: 127
  • DIU is the best Cisco Networking Academy !!!!!
    • View Profile
Re: How to Export User List from Google Apps
« Reply #2 on: July 10, 2012, 04:52:15 PM »
The Google apps user who have admin privilege only he/she can do it
With thanks,


Dr. Md. Nadir Bin Ali
LMC and Head of Cisco Networking Academy
Daffodil International University

Offline Noman_1450

  • Full Member
  • ***
  • Posts: 139
  • “Obey Allah and Allah will reward you.”
    • View Profile
Re: How to Export User List from Google Apps
« Reply #3 on: July 19, 2012, 10:26:43 AM »
Thanks. It's good post & information. It also helpful for ODESk.
Abdullah Al Noman
Id. 101-11-1450
25th batch, Department of BBA
Email: noman_1450@diu.edu.bd