MS Excel does not properly render when exporting Asset Object Type attributes of type "TextArea"
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
CSV Export in the "user-friendly" format of a TextArea attribute has an unnecessary line break, causing the CSV to render the data incorrectly in MS Excel.
Environment
JSM DC / Asset DC
Diagnosis
Opening the CSV file in another CSV viewer or text editor, you will see the content but with line breakers.
Cause
The Issue of the field text getting misplaced is not caused by the actual CSV export generated by Asset but, instead, is caused by a limitation with Microsoft Excel.
https://superuser.com/questions/926786/removing-line-breaks-from-csv-for-proper-excel-import
Solution
After Opening the file in MS Excel, Click the Select All button
Double-click the in-between Row 1 and 2 when the cursor changes, which should authorize all the fields to match the data.
Was this helpful?