Jira Cloud Excel Export fails to distinguish between custom fields with duplicate names

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Unresolved
    • None
    • Component/s: Jira Cloud for Excel
    • None

      Issue Summary

      When opening a Jira Issue Filter (a list of Jira issues) in Microsoft Excel using the "Open in Microsoft Excel" feature, if there are multiple custom fields with the same name, only one field is exported. This can result in empty columns in the export, even though the fields contain values in Jira.

      Steps to Reproduce

      1. Create a custom field called "Excel Options" (Select List - Single Choice) and add one option.
      1. Create another custom field with the same name and add one option.
      1. Create a third custom field with the same name and add three options.
      1. Associate the third custom field with a project's screens and create issues using these options.
      1. In Work Item search for this project, add the custom field as a column.
      1. Notice that multiple rows appear for each work item.
      1. Use Apps > Open in Microsoft Excel and observe that the column for this custom field is empty.

      Expected Results

      Each custom field with the same name should be exported to a separate column, ensuring all values are included in the export.

      Actual Results

      Only one value is exported, and the column may appear empty even when data exists.

      Workaround

      Users can use the Export > Export Excel CSV option as an alternative.

            Assignee:
            mbamba
            Reporter:
            Ariel (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: