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
Hello Bernadette,
There are basically two options to export issues to CSV: Export Excel CSV (all fields) and Export Excel CSV (Current Fields):
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:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.