Trucie (True Content Import)
This module allows you to import content into any entity type from spreadsheet or CSV files, offering built-in processing rules and a user-friendly interface for configuration. Once set up, users can easily import data by uploading a file.
Trucie module provides content import from the spreadsheet file.
Main features:
- Supported formats: xlsx, xls, ods, csv.
- Provides UI to configure the import (this can be exported to site config).
- Provides basic processing rules for fields from the source file.
- Supports ANY entity type including custom entities (not just nodes and taxonomy terms).
- Provides events (similar to hooks) to make it possible to write custom data processing.
There are number of modules available that provides content import from xlsx or csv, the main difference is that Trucie supports all entity types and not just the ones that comes from core (nodes, terms, etc). Additionally, it's possible to configure basic processing rules for fields (like floatval or preg_replace).
This module is inspired by Migrate API and Feeds module. But with Migrate API you have to manually upload the source file to some directory on the server in order to do the content import, while with Trucie you can just select the file on the form to upload it.
It requires basic understanding of how entities are structured, so it's recommended to have a tech-savvy guy to configure the imports. But once it's set up any one can do the import from file at any time.
Feel free to check module readme for examples and more details.