excel_importer

The Excel Importer allows importing structured Excel files into available content types.

• Structured: Each Sheet in the Excel file should have the same name as the Content Type into which its contents will be imported. Additionally, the columns names of the sheet should be identical to the machine names of the Content Type fields.
• Entity References: The name/title of Entity Reference fields (mostly Taxonomy Terms), should be used. This is actually the pain point that this module solves as compared to CSV Importer module.

Usage

1. Navigate Excel Import page, i.e. /excel-import
2. Read the introductory text there to make sure the structure of the document is what is expected.
3. Select your Excel file and upload it.
4. Click on Save button.

Administer Settings

1. Navigate Excel Importer Settings page, i.e. /admin/config/content/excel_importer
2. Add in the introductory text; this can include links to template files or documentation page.
3. Choose the Content Types that should be available for importing Excel Data into.
4. Remember, the template Excel file should have at least one of these content types as a sheet.
5. Click on Save Configuration button.

Dependencies

This module requires the phpoffice/phpspreadsheet library. This is handled as a composer dependency.

Observation

• there should be no column with the name "type"
• does not allow creation of taxonomy terms on the fly
• does not handle multi-value fields
• Google SpreadSheets and Numbers exported XLSX files have issues with empty rows

Resources

Here is a Sample Excel file for the base Article Content Type to get started with.