Excel Import Template Settings
Excel Import Template Settings
Enumeration Formats
You can choose how dropdown values appear in Excel templates:
- Labels (user-friendly names)
- XBRL IDs (technical identifiers)
- Truncated IDs (short codes)
How Enumerations Work
Each value has:
- A label (e.g. "SWEDEN")
- An XBRL ID (e.g. "eba_GA:SE")
DPM Authority always exports XBRL IDs.
Flexible Import
When importing, you can use:
- Labels
- Full XBRL IDs
- Short IDs (e.g. "SE")
This allows compatibility with existing source data.
Template Behaviour
Excel templates use one format for dropdown validation.
You can modify templates if needed, but this may affect validation behaviour.
Sheet Configuration
The system reads a configuration string from the Excel file (default: cell A1).
If using custom templates, you can change this location.