(Sudhaus7) XLS Import

Extension key: xlsimport
Version: main
Language: en
Description: Importing Excel and other formats in TYPO3 database
Keywords: data, import, excel, csv
Copyright: 2020
Author: Sudhaus7, a B-Factor GmbH label
License: Open Content License available from www.opencontent.org/opl.shtml
Rendered: Sun, 31 Aug 2025 10:43:01 +0000

Table of Contents

Introduction

What does it do?

This extension allows the import of data to every database table inside TYPO3 defined in TCA configuration.

Screenshots

View with no page selected — The default view of the module.

Configuration

This section describes the configuration options for XLS importer.

Adding configuration needs a TCA defined table.

Extension Setup

Go to Install Tool > Settings > Extension Settings and add your tables as comma separated list.

Module Setup

Add the TypoScript setup as usual to your sitepackage extension configuration file mysitepackage/Configuration/TSConfig/PageTS/tx_xlsimport.tsconfig:

module.tx_xlsimport {
    settings {
        allowedTables := addToList(tt_address)
    }
}

Every TCA defined table could be used. Field names are taken by locallang files, so localization is done.

Definition of allowed tables can be done either way. Both lists will be merged afterwards.

Usage

Beginning from here you can select a page inside the pagetree you want to import your data to.

Select table and file view — The view for selecting table and file for importing data.

Inside this view you can select your table you want to import to. As actual supported files you can use all listed above file types.

The first checkbox allows you to select if the uploaded file is CP1252 encoded. This is especially useful if you encounter problems with empty fields after the import due to UTF-8 problems.

The second checkbox allows you to delete all records in the selected table on the selected page.

For getting data updated instead of added, you have to define a row with the uid of the corresponding TYPO3 record inside your Excel sheet. If you set one column to uid, the system tries to update the existing dataset.

Use the update feature carefully.

The PID insert can only used by TYPO3 Backend Administrators, as the import with pid will cause side effects.

View for the pre imported data — The view of the pre imported data with empty selects

You will get a preview of your data. Now you have to decide, to which column your data has to be written. With the checkbox in the front you can exclude data from getting imported, this is useful for header lines and empty lines to avoid problems with the TCA import.

View for imported data with opened select — An opened select for selecting the data column

Select for every column to which column inside the database this column has to be added. If you choose ignore, the column is ignored. Selecting uid will update the dataset with the uid inside this column instead of creating a new one. Updating a dataset won't take effect on the pid, the data is stored. If no uid is set, a new dataset is created at the current page. This allows to mix up updating records and creating new ones with only one import.

After a successful import you will get a success message and your data is imported.

Table view from tt_address with imported data — The data chosen above is imported to the current page