PHPackages calien/xlsexport - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [File & Storage](/categories/file-storage) 4. / 5. calien/xlsexport ActiveTypo3-cms-extension[File & Storage](/categories/file-storage) calien/xlsexport ================ Calien - XLS-Exporter 4.0.0(1mo ago)04.0k↓33.3%2[1 PRs](https://github.com/calien666/typo3-xlsexport/pulls)MITPHPPHP >=7.4 Since Jan 8Pushed 2mo ago2 watchersCompare [ Source](https://github.com/calien666/typo3-xlsexport)[ Packagist](https://packagist.org/packages/calien/xlsexport)[ RSS](/packages/calien-xlsexport/feed)WikiDiscussions main Synced 1mo ago READMEChangelog (10)Dependencies (24)Versions (27)Used By (0) XLS Exporter for TYPO3 ====================== [](#xls-exporter-for-typo3) Export complex data to Excel sheets ----------------------------------- [](#export-complex-data-to-excel-sheets) ### What does it do? [](#what-does-it-do) This extension helps to export complex data from TYPO3 into spreadsheets. ### How does it work? [](#how-does-it-work) This extension provides a new backend module for exporting complex data into spreadsheets. In the default setup the table tt\_address can be exported out of the box. ### Configuration [](#configuration) The module can be configured by TSconfig. The following snippet has to be added to your PageTS configuration. This is the Default Setting: ``` module.tx_xlsexport { settings { exports { # name in settings, could be everything tt_address { # label shown in bakcned module label = Addresses # counter for selected records to export. String with SQL query check = SELECT count(*) FROM tt_address where pid=%d and hidden=0 and deleted=0 # export query export ( select uid,first_name,middle_name,last_name,address,building,room,city,zip,region,country,phone,fax,email,www,title,company from tt_address where pid=%d and deleted=0 and hidden=0 ) # list query, currently unused list ( select uid,first_name,last_name from tt_address where pid=%d and deleted=0 and hidden=0 ) # SQL table name table = tt_address # field names from SQL query for export exportfields { 10 = uid 20 = first_name 30 = middle_name 40 = last_name 50 = address 60 = building 70 = room 80 = city 90 = zip 100 = region 110 = country 120 = phone 130 = fax 140 = email 150 = www 160 = title 170 = company } # labels for export field columns, numbers must match with fields in exportfields exportfieldnames { 10 = lfd. Nummer 20 = Vorname 30 = Mittelname 40 = Nachname 50 = Adresse 60 = Gebäude 70 = Raum 80 = Stadt 90 = PLZ 100 = Region 110 = Land 120 = Telefon 130 = Fax 140 = E-Mail 150 = Web 160 = Titel 170 = Firma } } } } } ``` which you can either override, or extend in this fashion: ``` module.tx_xlsexport { settings { export { myExport { # [...] } } } } ``` Relations can be done by joins inside the select statements TODO: - add Events/Signalslots for datamanipulation - add support for multiple sheets - documentation - localization FUTURE: (hit me up if you are willing to help funding) - support TCA for complex data structures - update backend module to fit TYPO3 styles ### Health Score 49 — FairBetter than 95% of packages Maintenance87 Actively maintained with recent releases Popularity22 Limited adoption so far Community11 Small or concentrated contributor base Maturity63 Established project with proven stability Bus Factor1 Top contributor holds 69.2% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~86 days Recently: every ~145 days Total 23 Last Release 49d ago Major Versions 1.0.3 → 3.0.02021-10-13 2.1.1 → 3.0.12021-10-13 2.1.2 → 3.1.02023-02-10 3.1.8 → 4.0.02026-03-24 PHP version history (2 changes)1.0.0PHP >=7.4 2.1.0PHP >=7.3 ### Community Maintainers ![](https://www.gravatar.com/avatar/1a1ddeb615ab1289506094f767ffacee7e1deaa6c914527b116cf88fcbe62e68?d=identicon)[calien666](/maintainers/calien666) --- Top Contributors [![calien666](https://avatars.githubusercontent.com/u/11405116?v=4)](https://github.com/calien666 "calien666 (18 commits)")[![torben-fr](https://avatars.githubusercontent.com/u/92865600?v=4)](https://github.com/torben-fr "torben-fr (8 commits)") ### Code Quality TestsPHPUnit Static AnalysisPHPStan Code StylePHP CS Fixer Type Coverage Yes ### Embed Badge ![Health badge](/badges/calien-xlsexport/health.svg) ``` [![Health](https://phpackages.com/badges/calien-xlsexport/health.svg)](https://phpackages.com/packages/calien-xlsexport) ``` ### Alternatives [causal/image_autoresize Simplify the way your editors may upload their images: no complex local procedure needed, let TYPO3 automatically resize down their huge images/pictures on-the-fly during upload (or using a command for batch processing) and according to your own business rules (directory/groups). This will highly reduce the footprint on your server and speed-up response time if lots of images are rendered (e.g., in a gallery). Features an EXIF/IPTC extractor to ensure metadata may be used by the FAL indexer even if not preserved upon resizing. 19455.6k](/packages/causal-image-autoresize)[hmmh/solr-file-indexer Solr file indexer for Typo3 13217.4k3](/packages/hmmh-solr-file-indexer)[andersundsehr/aus-driver-amazon-s3 Provides a FAL driver for the Amazon Web Service AWS S3. 22259.1k](/packages/andersundsehr-aus-driver-amazon-s3) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)