Opening CSV from excel data issue

Bernadette Gowanloch
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 16, 2019

When I open a CSV file downloaded from JIRA cloud using excel, additional rows of junk as well as empty rows get added to the report. 

 

Help please!

 

Thanks,

Bernadette

1 answer

0 votes
Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 19, 2019

Hello Bernadette,

There are basically two options to export issues to CSV: Export Excel CSV (all fields) and Export Excel CSV (Current Fields):

Screen Shot 2019-07-19 at 19.18.24.png

1 - Using the Export Excel CSV (all fields) option, it will export all the fields you have in your issue, including the hidden ones and the ones with no relevant values.

2 - Using the Export Excel CSV (Current Fields) option, it will export the fields that you defined as a column for your issue filter, by using the List view option as displayed in the screenshot below:

Screen Shot 2019-07-19 at 19.21.55.png

To avoid the download of irrelevant fields in your CSV, I recommend you to use the second option, defining only the fields you want as columns in your filter.

Let me know if you still have any questions.

Suggest an answer

Log in or Sign up to answer