A simple yet powerful Drupal 9/10 spreadsheets module for small and enterprise level projects. The module provides an intuitive way for importing, exporting and mapping fields between Drupal and Spreadsheet (xlsx, xls, csv, slk) files.
This module is a great solution for those who would like to maintain their content in spreadsheets with the ability to display it in Drupal (Entity types and fields should be pre-created). One of the example would be pricing plans for Insurance Companies with complex list of providers, plans and their zip codes. You could also use this module as a content migration tool (one-time migration) and other use cases.
With a user-friendly interface, it is easy to map fields between Drupal and Spreadsheets.
Import and Export
IMPORTANT: Each import overrides previously imported content (deletes all of the entities and imports content). Spreadsheet is meant to be the main source of content for the specified entities. Manually updating imported entities (nodes) will remain intact only if you export the spreadsheet before running another import.
Password Protected Export
Since not all Sheets readers support password protection in files, exported Spreadsheet files are ZIP files with password protection. A password prompt will appear in most archiver apps.
Plugin system ⚙️
The module provides the ability to extend its class by implementing custom plugins types for cell data (Data transformer), data source, data export, remote (destination) and content type (data). Some examples: Boolean (true/false,1/0) to boolean. Comma separated lists to checkboxes/radios. URLs to File and/or Media entities.
Automated imports (cron)
The module allows importing CSV from specified path or remote URL on a specific frequency. Data purge and import will happen in background using Drupal's queue API.
Experimental: Spreadsheets (XLSX) module comes with Spreadsheets (Google Drive/Sheets) that provides a way for importing and exporting files from Google Sheets into Google Drive.
Why Go Premium?
By purchasing a premium module, you can save money and weeks of development time. Rather than starting from scratch, you can customize a module that already fits most of your requirements. You also get much better support.
If you have any module related questions, suggestions or would like to schedule a demo please let me know.