Intruduction
The Permission Spreadsheet module provides features to import/export user permissions via:
- Excel (*.xlsx, *.xls)
- OpenDocument Spreadsheet (*.ods)
- Comma separated values (*.csv)
- Tab separated values (*.tsv)
This module is useful on following cases:
- Site has many roles, so difficult to edit permissions on admin page.
- Copy permissions among the roles.
Requirements
2.1.0-
- PHP 8.0 or greater
- Drupal 10-11
- PhpSpreadsheet 2.2.0 or greater
2.0.0
- PHP 7.0 or greater
- Drupal 9-10
- PhpSpreadsheet 1.3.0 or greater
Installation
- Use composer: See Releases section
Configuration
Visit /admin/config/people/permission_spreadsheet.
(Administration > Configuration > People > Permission spreadsheet settings)
Supporting organizations:
Project information
- Project categories: Access control, Administration tools, Import and export
878 sites report using this module
- Created by hayashi on , updated
Stable releases for this project are covered by the security advisory policy.
Look for the shield icon below.

