I am submitting a request to modernise the Bulk User Import/Export functionality. Currently, the BulkImportTemplate and the User.csv export provide only a fraction of the data required for effective enterprise user management, leading to significant manual overhead for System Administrators.
1. The "BulkImportTemplate" Limitation
The current template is restricted to: First Name, Last Name, Email, Seat Type, Group Admin, Resource Viewer, and Sys Admin.
To manage an organisation at scale, we need this template to support additional fields. My recommendation is to update the template to include optional fields for:
- Department
- Job Title/Role
- Company
- Group Membership (e.g., adding users to existing Contact Groups during the import process)
Proposed Mandatory vs. Optional Standards:
- Always Mandatory: First Name, Last Name, Email.
- Optional but Supported: All other profile metadata and permission toggles.
2. The "User.csv" Reporting Gap
The corresponding reporting function is equally limited. The current User.csv output includes basic status and roles but excludes the very metadata we need for auditing and resource planning.
Current Fields: Name, Email, Status, Sys Admin, Group Admin, Licensed User, Resource Viewer, Sheets (Owned), Last Login, Time Added, Trial Status.
Requested Update:
The User.csv export should be updated to include Department, Title, and Group Affiliations. Without these, Admins are forced to manually click through individual user profiles to verify if users are correctly categorised or assigned to the right functional teams.
The Business Impact:
For any organisation with more than 100 users, "Bulk" management should mean more than just adding an email address. It should allow for the complete setup of a user’s professional profile. Enhancing these templates would turn a multi-hour manual audit into a 5-minute CSV task.
