Excel Serialization
13,103 sites
Security covered
Drupal 9–11
This module allows Drupal to export data in Excel (.xls) format using the core Serialization API. This enables integration with other Drupal features like REST exports and Views to output data that can be easily opened and manipulated in spreadsheet software.
This module provides an Excel encoder for the Drupal 8 Serialization API. This
enables the XLS format to be used for data output (and potentially input,
eventually). For example:
- Drupal 8's REST module can return data in XLS format.
- Views can output XLS data via a 'REST Export' view, or a
Data Export view. - Module developers can leverage XLS as a format when using the Serialization
API.
Installation
- Download and install PHPOffice/PhpSpreadsheet. The suggested installation method is to use Composer.
- Enable the
xls_serializationmodule.
Creating an XLS view
- Create a new view
- Add a Data Export display (this assumes the use of the Views Data Export) module. Otherwise add a REST Export view.
- Check only 'xls' for the accepted request formats under
Format > Data export > Settings. - Add desired fields to the view.
- Add a path, and optionally, a filename pattern.
Related modules
- The Views Data Export Excel module extends the DataExport Views style and display classes from the Views Data Export module using the serializer provided by this module.
Depends on
Dependencies of the latest stable release
- rest Drupal core
- serialization Drupal core
Required by
3 tracked projects depend on this one
- XLS Views Data Export 648 sites
- Views Data Export Excel 156 sites
- Excel Serialization Extras 33 sites
Activity
Release Timeline
Releases
| Version | Type | Core | Notes | Release date | |
|---|---|---|---|---|---|
| 2.2.0-beta1 | Pre-release | 9–11 | Aug 14, 2026 | ||
| 2.1.2 | Stable | 9–11 | Aug 14, 2026 | ||
| 2.x-dev | Dev | 9–11 | Aug 14, 2026 | ||
| 2.1.1 | Stable | 9–11 | Jun 24, 2026 | ||
| 2.0.4 | Stable | 9–11 | Jan 6, 2026 | ||
| 2.1.0 | Stable | 9–11 | Jan 6, 2026 | ||
| 2.1.0-rc2 | Pre-release | 9–11 | Dec 9, 2025 | ||
| 2.1.0-rc1 | Pre-release | 9–11 | Nov 4, 2025 | ||
| 2.1.0-beta1 | Pre-release | 9–11 | Oct 7, 2025 | ||
| 2.1.0-alpha2 | Pre-release | 9–11 | Aug 5, 2025 | ||
| 2.1.0-alpha1 | Pre-release | 9–11 | Aug 5, 2025 | ||
| 8.x-1.9 | Stable | 9–11 | Jan 26, 2025 | ||
| 2.0.3 | Stable | 9–11 | Jan 26, 2025 | ||
| 2.1.x-dev | Dev | 9–11 | Jan 12, 2025 | ||
| 8.x-1.8 | Stable | 9–11 | Jan 12, 2025 | ||
| 2.0.2 | Stable | 9–11 | Jan 12, 2025 | ||
| 8.x-1.7 | Stable | 9–11 | Jan 8, 2025 | ||
| 2.0.1 | Stable | 9–11 | Jan 8, 2025 | ||
| 2.0.0 | Stable | 9–11 | Nov 14, 2024 | ||
| 2.0.x-dev | Dev | 9–11 | Nov 14, 2024 | ||
| 8.x-1.6 | Stable | 9–11 | Nov 14, 2024 | ||
| 8.x-1.5 | Stable | 9–10 | Oct 23, 2024 |