PHPackages sudhaus7/xlsimport - 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. sudhaus7/xlsimport ActiveTypo3-cms-extension[File & Storage](/categories/file-storage) sudhaus7/xlsimport ================== (Sudhaus7) XLS Importer 6.0.0(1y ago)531.5k↓43.8%15[10 issues](https://github.com/sudhaus7/typo3-xlsimport/issues)[1 PRs](https://github.com/sudhaus7/typo3-xlsimport/pulls)MITPHPPHP ^8.2 || ^8.3 || ^8.4CI passing Since Mar 24Pushed 8mo ago4 watchersCompare [ Source](https://github.com/sudhaus7/typo3-xlsimport)[ Packagist](https://packagist.org/packages/sudhaus7/xlsimport)[ RSS](/packages/sudhaus7-xlsimport/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (10)Dependencies (21)Versions (39)Used By (0) XLS Importer ============ [](#xls-importer) [![Latest Stable Version](https://camo.githubusercontent.com/dfb51fc177263dc498b7728ca8f5f6e0d2960863b2e6d86ccccfdb56a76be017/68747470733a2f2f706f7365722e707567782e6f72672f73756468617573372f786c73696d706f72742f762f737461626c652e737667)](https://extensions.typo3.org/extension/xlsimport/)[![TYPO3 13](https://camo.githubusercontent.com/149184b6e5176a0c630a43a287c9e6bf1378e1613e96e567c2dcc13b5636205a/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5459504f332d31332d677265656e2e737667)](https://get.typo3.org/version/13)[![Total Downloads](https://camo.githubusercontent.com/eaeaa977369920bc2c46e0ae630ac53d40f139827e469e2bd0de1108480ea4a4/68747470733a2f2f706f7365722e707567782e6f72672f73756468617573372f6c6f67666f726d61747465722f642f746f74616c2e737667)](https://packagist.org/packages/sudhaus7/xlsimport)[![Monthly Downloads](https://camo.githubusercontent.com/f20a86854e08431e2219221ee82371fb48aa0582984716cbb96c8fc3889cbdf2/68747470733a2f2f706f7365722e707567782e6f72672f73756468617573372f786c73696d706f72742f642f6d6f6e74686c79)](https://packagist.org/packages/sudhaus7/logformatter) TCA driven import Extension for Spreadsheets -------------------------------------------- [](#tca-driven-import-extension-for-spreadsheets) ### What does it do? [](#what-does-it-do) This extension helps to import data from Spreadsheets into TYPO3. ### How does it work? [](#how-does-it-work) This extension provides a new backend module in which you can use every TCA configured table for importing data from Excel. When uploading the spreadsheet, you can select the table you want to import data to. After the upload, you will get a table with the data of the first worksheet. In the header, you can select your field to import to, so you don't have to respect a specific order of columns in your spreadsheet. Every line can be removed, so you import only the data you want to. ### Configuration [](#configuration) The module can be configured by TSconfig. The following snippet has to be added to your Page TS Configuration. This is the Default Setting: ``` module.tx_xlsimport { settings { allowedTables = tt_address } } ``` which you can either override, or extend in this fashion: ``` module.tx_xlsimport { settings { allowedTables := addItems(my_table_configured_in_TCA) } } ``` *Important*: you have to specify the TABLENAME of an extension you want to import to, not the extension name. So for example, if you want to import data for the news extension (tx\_news) you have to add the tablename `tx_news_domain_model_news`. Respectfully, if you want to import tx\_news's Tags, you have to add the tablename `tx_news_domain_model_tag` to the list. The extension in itself does not maintain relations out of the box. ### Limitations [](#limitations) When a non-admin user is using the tool, the folder the import is made to has to either be inside a site-setup with defined languages OR the sys\_language\_id (0,1,2,3) has to be part of the imported data. If these requisits are not met, the tool will report a successful import, while no data has been imported. We hope to address this in a future update. ### TODO: [](#todo) - add more Events/Signalslots for datamanipulation - add support for multiple sheets ### FUTURE: (hit me up if you are willing to help funding) [](#future-hit-me-up-if-you-are-willing-to-help-funding) - support for related data as far as it is modelled in the TCA - support for import-presets or templates for recurring import tasks ### Local development [](#local-development) #### Local development environment with `ddev` [](#local-development-environment-with-ddev) This extension repository includes a `ddev` instance configuration matching the development requirements and is setup to provide and easy and simple development experience for people, which wants to contribute or play around. That means, thatn on a simple `ddev start` the environment is checked and the TYPO3 instance configured (setup) against ddev with a generic admin user along with creating pages tree for the backend using `typo3/cms-styleguide` and the included generator. **Start** ``` ddev start ``` **Full reset (destroy)** ``` ddev stop -ROU \ && git clean -xdf -e '.idea' ``` **Recreate instance** ``` ddev stop -ROU \ && git clean -xdf -e '.idea' \ && ddev start ``` To simplify the setup, a generic admin user is created: typeusernamepasswordemailBEjohn-doeJohn-Doe-1701D.with following urls: urlcommanddescriptionddev launch /typo3/Open the TYPO3 backendddev launch /styleguide-demo-1/Open the styleguide frontend### Changes in v5.0 [](#changes-in-v50) - removed TypoScript support, as TypoScript is frontend related - use Page TSconfig instead - Configuration is the same as in TypoScript - Or configure via Extension Configuration - Rework for removing Extbase dependencies in Controller - No changes needed ### Health Score 48 — FairBetter than 95% of packages Maintenance33 Infrequent updates — may be unmaintained Popularity36 Limited adoption so far Community21 Small or concentrated contributor base Maturity86 Battle-tested with a long release history Bus Factor2 2 contributors hold 50%+ of commits 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 ~65 days Recently: every ~101 days Total 29 Last Release 424d ago Major Versions 1.1.0 → 2.0.02021-04-08 1.0.7 → 3.0.02022-05-06 3.0.0 → 4.0.02023-02-11 4.0.3 → v5.0.02024-02-08 v5.0.5 → 6.0.02025-03-20 PHP version history (7 changes)1.1.0PHP >=7.0 2.0.0PHP >=7.4 2.0.5PHP >=7.3 4.0.0PHP ^7.4 || ^8.0 4.0.2PHP ^7.4 || ^8.0 || ^8.1 v5.0.0PHP ^7.4 || ^8.0 || ^8.1 || ^8.2 6.0.0PHP ^8.2 || ^8.3 || ^8.4 ### Community Maintainers ![](https://www.gravatar.com/avatar/c9f3b5a9949724de5da93fcf1ea189dd31131a25502fb8555eb7cff3fab5cfad?d=identicon)[sudhaus7](/maintainers/sudhaus7) --- Top Contributors [![foppelfb](https://avatars.githubusercontent.com/u/7147768?v=4)](https://github.com/foppelfb "foppelfb (40 commits)")[![calien666](https://avatars.githubusercontent.com/u/11405116?v=4)](https://github.com/calien666 "calien666 (39 commits)")[![sbuerk](https://avatars.githubusercontent.com/u/1453466?v=4)](https://github.com/sbuerk "sbuerk (31 commits)")[![peterkraume](https://avatars.githubusercontent.com/u/4234704?v=4)](https://github.com/peterkraume "peterkraume (11 commits)")[![TokeHerkild](https://avatars.githubusercontent.com/u/20276854?v=4)](https://github.com/TokeHerkild "TokeHerkild (1 commits)")[![BastianBalthasarBux](https://avatars.githubusercontent.com/u/8894578?v=4)](https://github.com/BastianBalthasarBux "BastianBalthasarBux (1 commits)")[![Weissheiten](https://avatars.githubusercontent.com/u/8425188?v=4)](https://github.com/Weissheiten "Weissheiten (1 commits)")[![ErHaWeb](https://avatars.githubusercontent.com/u/5416710?v=4)](https://github.com/ErHaWeb "ErHaWeb (1 commits)")[![metapublic-gbr](https://avatars.githubusercontent.com/u/31284546?v=4)](https://github.com/metapublic-gbr "metapublic-gbr (1 commits)")[![Patta](https://avatars.githubusercontent.com/u/2151127?v=4)](https://github.com/Patta "Patta (1 commits)") ### Code Quality TestsPHPUnit Static AnalysisPHPStan Code StylePHP CS Fixer Type Coverage Yes ### Embed Badge ![Health badge](/badges/sudhaus7-xlsimport/health.svg) ``` [![Health](https://phpackages.com/badges/sudhaus7-xlsimport/health.svg)](https://phpackages.com/packages/sudhaus7-xlsimport) ``` ### 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)