Excel Importer (SBB)

The Excel Importer extension addresses a specific use case not covered by the standard Excel import feature in Polarion. It allows updates to existing Work Items using a custom unique identifier from an Excel column, rather than relying on internal Polarion Work Item IDs. This enables reliable repeated imports and updates, even when Polarion IDs are unknown.

Key Features

• Custom Identifier-Based Updates: Update Work Items using a user-defined unique key from Excel.
• Repeatable Imports: Supports importing updated Excel files without needing internal IDs.

• Non-Intrusive Enhancement: Works as an additional capability, not a replacement for the default importer.
• Admin Panel Integration: Easily accessible in the Polarion Administration panel with a dedicated “About” page.
• REST API Support: Enables automation and integration with external tools or scripts.

Benefits

• Streamlines bulk updates when Work Item IDs are unknown or changeable.
• Supports Excel-based collaboration with external stakeholders (e.g., suppliers).
• Minimizes errors and manual effort by enabling automated synchronization.

Availability

Available via the Polarion Administration panel. Setup instructions and configuration guidance are available in the “About” section of the extension.