Excel Importer
244 sites
No security coverage
This module allows you to import structured data from Excel files directly into your Drupal content types. It maps Excel sheets and column headers to content types and their field machine names, simplifying mass content creation.
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
- Navigate Excel Import page, i.e.
/excel-import - Read the introductory text there to make sure the structure of the document is what is expected.
- Select your Excel file and upload it.
- Click on Save button.
Administer Settings
- Navigate Excel Importer Settings page, i.e.
/admin/config/content/excel_importer - Add in the introductory text; this can include links to template files or documentation page.
- Choose the Content Types that should be available for importing Excel Data into.
- Remember, the template Excel file should have at least one of these content types as a sheet.
- 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.