Import from Excel

This topic provides reference information that may be useful when importing Work Items defined in Microsoft Excel.

Supported Work Item fields

Columns and data in Excel can be mapped to the following Work Item fields during import to Polarion. Please see following notes on mapping multivalued data to multivalued fields.

  • Assignee *

  • Author

  • Categories *

  • Comments

  • Custom fields *

  • Description

  • Due Date

  • Hyperlinks *

  • Initial Estimate

  • Linked Work Items *

  • Priority

  • Remaining Estimate

  • Resolution

  • Resolved On

  • Severity

  • Status

  • Time Spent

  • Title

Note:

An asterisk * character in the above list means the field supports import of multivalued data. Note that import of multivalued custom fields is supported for enumeration types only, not for primitive types, which can still be imported as single values.

Multivalued data and fields

It is possible to define multivalued data in Excel so that it can be mapped to multivalued fields in Polarion Work Items, and multiple values written to such fields during import.

The following fields must be written in a special format using a specific pattern:

  • Linked Work Items: pattern: "[role:][project/]id". External linked items pattern is: "[role:]URL".

  • Hyperlinks: pattern: "[role:]URL"