permission_spreadsheet

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)