---
title: "Introduction"
manual: "Calien - XLS Exporter"
version: "5.1"
permalink: "https://docs.typo3.org/permalink/calien/xlsexport:introduction@5.1"
source: "Introduction/Index.rst"
rendered: "2026-11-19T10:49:27+00:00"
---

# Introduction {#introduction}

**Table of contents**

-   [What it does](https://docs.typo3.org/permalink/calien/xlsexport:what-it-does@5.1)
-   [Declarative exports](https://docs.typo3.org/permalink/calien/xlsexport:declarative-exports@5.1)
-   [Features](https://docs.typo3.org/permalink/calien/xlsexport:features@5.1)

## What it does {#what-it-does}

The XLS Exporter adds a backend module (**Web > XLS Exporter**) that offers editors one or
more preconfigured *exports* for the currently selected page. Each export runs a database query and
streams the result to the browser as a spreadsheet file. The editor picks a file name and one of the
supported formats — `xlsx`, `xls`, `ods` or `csv` — and downloads the file.

Exports are defined by integrators in page TSconfig. A single definition describes which table to
read, which columns to select, how to filter and join, and which column headers to write — see
[Configuration](https://docs.typo3.org/permalink/calien/xlsexport:configuration@5.1).

## Declarative exports {#introduction-declarative}

Version 5 introduces a declarative export format: a definition describes *what* to read — table,
columns, filters and joins — and the extension builds the query for it with the TYPO3
[QueryBuilder](https://docs.typo3.org/m/typo3/reference-coreapi/13.4/en-us/ApiOverview/Database/DoctrineDbal/QueryBuilder/Index.html#database-query-builder). Integrators no longer write SQL statements
by hand, which makes exports easier to read, maintain and extend. See [Migration from version 4](https://docs.typo3.org/permalink/calien/xlsexport:migration@5.1) for how to
convert an export from version 4.

## Features {#features}

-   Read any table, with `SELECT`, `WHERE`, `JOIN` / `LEFT JOIN` / `RIGHT JOIN` and a
    record count, all expressed as TSconfig.
-   Output as `xlsx`, `xls`, `ods` or `csv` via
    [PhpSpreadsheet](https://phpspreadsheet.readthedocs.io/).
-   Delivered as a site set, so integrators enable it per site.
-   Three PSR-14 events to shape the generated spreadsheet — see [Developer](https://docs.typo3.org/permalink/calien/xlsexport:developer@5.1).
