Excel Multi-Choice and Multi-Value Import
Importing Multi-Value Choice Fields or other Multi-Value Fields from Excel or Word Tables
Before importing a custom choice field to enable multiple values to appear in the created work items, the related choice field must be configured:
1. Go to the Tracker Configuration.
2. Open the Edit window of the related custom field.
3. Select the multiple checkbox in the Datasource section.
4. Click OK to save the modification.
After completing the steps, a work item can be imported from Excel. This field should get two values, for example A and B.
Import Multi-Values using a Multi-Row Data
 |
Download the multiValue-multiRow.xlsx example document.
|
To import data, add the values of the multi-value field in new rows following each other in the template. Leave the other columns of the new rows empty
These rows are automatically merged, and the multi-field gets the values A and B.
The result of this import:
Importing Multi-Values from Single Cell using Conversions
| | Download the multiValue-split.xlsx example document. |
Multiple values split by commas can also be imported from single cells.
1. Click the Configure Advanced conversions link to reveal conversions.
2. Select Splitter from the dropdown list for the Multi field conversion.
3. For the Split by field, select A separator line from the dropdown list.
4. Add a comma , as delimiter in the Separator field.
5. Complete the import.
This conversion splits the A,B into value A and value B.
Configuring How Export Works with Multi-Values
By setting the "exportMultiValuesToMultiRows" value to "true" multi-values can be exported into multiple rows. For more information, see Configuring Excel Export Default Settings.