External Import to JIRA: How can I keep the format from an Excel file to the .CSV and then to a JIRA

[Steve Hooczko]

How can I keep the format from an Excel file to the .CSV and then to a JIRA. For instance, the Description field has bulleted items and blank lines, but when I convert it to a CSV and that CSV is imported into JIRA all the text flows together (i.e. loses the rich formatting).

[Steve Hooczko]

I figured it out. Checking the MAP FIELD box for all the fields I was importing caused the issue. I unchecked them and the fields imported in the same format as my Excel file.

[Zsanett Czinege]

This was really helpful, worked for me. Thank you!

[Pramodh M]

Hi @Steve Hooczko 

If you need to keep the formatting, you would need to export the data via API and store it 

Here's a guide

https://community.atlassian.com/t5/Jira-questions/Importing-issues-from-JIRA-to-Excel-using-API/qaq-p/1943319#M518597

Thanks

[Pramodh M]

@Steve Hooczko

Try with this add-in in excel and explore

https://community.atlassian.com/t5/Jira-articles/The-add-in-you-ve-been-waiting-for-Jira-Cloud-for-Excel/ba-p/1210420

[Nic Brough -Adaptavist-]

CSV and Excel files are different.  CSV has no support for formatting, it's plain data.   If you save a spreadsheet file as CSV, your spreadsheet can only save the data in a standard CSV shape, without formatting or cleverness.

TLDR: you can't do this, because CSV does not have formatting.

[Steve Hooczko]

I should at least be able to keep the blank lines / line breaks, shouldn't I?

[Nic Brough -Adaptavist-]

You'll need to encode them if you want to do that.   Spreadsheets don't encode when they export.

[Joe Pitt]

you can't. CSV files don't support the formatting.