The Jira report data is all in just one column in Excel

Ana Luiza Chagas
Contributor
August 13, 2024

Hey Team,

My organization and I were experiencing issues exporting a filter from Jira to Excel. It happens that when we export to Excel, after dividing the text into columns to organize it, after a certain line the information from all the columns remains in just one column, disrupting the entire organization.

Has anyone seen something like this and knew how to solve it?
Thanks for the help!

colunas.PNG

2 answers

0 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 13, 2024

@Ana Luiza Chagas Isn't this possible that the line where the structure breaks contains a comma character or something in one of the field values or something else that will affect the "separation" of the values? You could try to find this and fix it in Jira by modifying the corresponding value.

Or, if you don't want to spend time with it, use the Better Excel Exporter app. It exports a true XLSX file, being a binary file format, which will not suffer from this type of problems.

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)

0 votes
Katrina Lieber August 13, 2024

Hi Ana,

The export to CSV or Excel CSV feature has always worked for me. You could try saving a copy of your filter and then exporting from that copy. In the meantime, here is a video that walks you through exporting to csv/excel.

 

Hope this helps!

Ana Luiza Chagas
Contributor
August 15, 2024

Hi @Katrina Lieber 

Thank you very much for the response to the video, it was super educational, I took the opportunity to follow your channel!
My problem unfortunately continues to occur, I've tried to organize it in other ways but the information in some lines is simply concentrated in just one column. This happens around item 420 and we have over 600 items in the report.
I don't know if it could be due to the amount of data in the report, but I followed the same steps as you, it works for other reports, but for this specific one I still get the error.
]

Thanks again for the response!

Like Katrina Lieber likes this
Katrina Lieber August 15, 2024

Hi @Ana Luiza Chagas ,

Thanks for following! So bummed this problem is still occurring for you. Have to tried looking closely at the custom fields in the 420th item you are trying to export? Perhaps there is an invalid/unsupported character in one of your custom fields, such as a comma or another character, that is causing this error. 

You could try exporting that 420th item alone and see if the same error occurs with just the one issue's data. This would help you narrow down if the problem is caused by some data in one of the fields for this particular issue.

Wishing you the best of luck!

Ana Luiza Chagas
Contributor
August 16, 2024

Hi @Katrina Lieber 

After some testing, I realized that this is due to the number of fields selected for export. After selecting a few fewer fields and exporting, the report works perfectly.
But I still hope to be able to export all the necessary data without all the data being in the same column. I checked and there are no characters different from the other columns that remain normal.

Thanks for the help!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events