In any migration project, understanding the source is very important.

Understanding the source document and plugin configuration Also, some machine names had to be changed to avoid conflicts with other examples in the demo repository. Although possible, the example includes slight changes to demonstrate various plugin configuration options. This is a powerful feature of ETL frameworks like Drupal’s Migrate API. Note: You can literally swap migration sources without changing any other part of the migration. The major difference is that we are going to read from different sources. The end result will again be nodes containing an image and a paragraph with information about someone’s favorite book. The source will be changed in today’s example, as we use it to explain Microsoft Excel and LibreOffice Calc migrations. The destinations will be the same content type, paragraph type, and fields.

Refer to that article for details on the configuration. This migration will reuse the same configuration from the introduction to paragraph migrations example. If your Drupal site is not composer-based, you will not be able to use Migrate Spreadsheet, unless you go around a lot of hoops. If any required extension is missing the installation will fail. Check this page for a full list of dependencies. This module depends on the ` PHPOffice/PhpSpreadsheet` library and many PHP extensions including `ext-zip`. You can get the Migrate Google Sheets module using composer: `composer require ‘drupal/migrate_spreadsheet:^1.0’. To execute the last one you would need the Migrate Source CSV module. The CSV migration is a backup in case the Google Sheet is not available. The paragraph migration uses a LibreOffice Calc file as source. The image migration uses a Microsoft Excel file as source. It comes with four migrations: `udm_google_sheets_source_node.yml`, `udm_libreoffice_calc_source_paragraph.yml`, `udm_microsoft_excel_source_image.yml`, and `udm_backup_csv_source_node.yml`. You can get the full code example at The module to enable is `UD Google Sheets, Microsoft Excel, and LibreOffice Calc source migration` whose machine name is `ud_migrations_sheets_sources`. There are two example migrations: images and paragraphs.

Then, we will present how to configure the module for spreadsheets with or without a header row. We will give instructions on getting the module and its dependencies. Today we will learn how to migrate content from Microsoft Excel and LibreOffice Calc files into Drupal using the Migrate Spreadsheet module.

Libreoffice calc excel