nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Steve Hooczko_zrtbba

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).

Accepted answers

All comments

Joe Pitt

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

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.

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

Steve Hooczko_zrtbba

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.

Steve Hooczko_zrtbba

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud