Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-46365

New line in CSV external import in JIRA doesn't work

XMLWordPrintable

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      Summary

      The documentation for New line in CSV external import in JIRA doesn't work

      Steps to Reproduce

      1. Create and save a CSV file as per the documentation Importing Data From CSV 
        Summary, Description, Status
"Login fails", "This is on
a new line", Open
      1. Do a CSV import in JIRA using the External Import in JIRA

      Expected Results

      Issue created to have multiple line in it's Description field.

      Actual Results

      Imported issue is in one line rather than multiple lines.

      "Login fails", "This is ona new line", Open

      Workaround #1

      On the Map fields screen, map your incoming field to the appropriate Jira field, but do not tick the Map field value checkbox. Ticking this box takes you to a screen where your browser will strip out your extra formatting.

      Depending on the formatting of your data and the field it's importing into, you may also want to wrap your incoming comment in {noformat} tags.

      Workaround #2

      It is possible to create newlines by using:

      \\

      at the beginning of each line as per the example below:

      Summary,Type,Description,Status
"next csv new line test","Bug","Atlassian
\\ Testing Issue
\\ Acceptance Criteria
\\ - Line 1
\\ - Line 2
\\ - Line 3
\\ - Line 4",To Do

      However, this workaround creates another issue with the exported field as mentioned in this bug ticket: JRA-46364

        1. Workaround1.png
          Workaround1.png
          78 kB
        2. Problem1.png
          Problem1.png
          254 kB
        3. image-2025-04-24-15-59-24-074.png
          image-2025-04-24-15-59-24-074.png
          83 kB
        4. image-2025-04-24-15-59-35-788.png
          image-2025-04-24-15-59-35-788.png
          118 kB

            [JRASERVER-46365] New line in CSV external import in JIRA doesn't work

            SET Analytics Bot made changes -
            UIS Original: 25 New: 34
            Cecille Maquito made changes -
            Attachment New: image-2025-04-24-15-59-35-788.png [ 498858 ]
            Cecille Maquito made changes -
            Attachment New: image-2025-04-24-15-59-24-074.png [ 498857 ]
            SET Analytics Bot made changes -
            Support reference count Original: 50 New: 51
            SET Analytics Bot made changes -
            UIS Original: 26 New: 25
            SET Analytics Bot made changes -
            UIS Original: 17 New: 26
            SET Analytics Bot made changes -
            Support reference count Original: 49 New: 50
            SET Analytics Bot made changes -
            UIS Original: 9 New: 17
            SET Analytics Bot made changes -
            Support reference count Original: 48 New: 49
            SET Analytics Bot made changes -
            UIS Original: 8 New: 9

              Unassigned Unassigned
              nghanis Nithiyaa Ghanis (Inactive)
              Affected customers:
              88 This affects my team
              Watchers:
              79 Start watching this issue

                Created:
                Updated: