Hello, I found similar issues in what I was able to find, but that was not the answer.
I want to export my data from Jira to a CSV file.
When there is a quote in a field, it is converted incorrectly. The question is, is it a Jira problem, or Excel problem?
Open request '00xxxx test request' is used to investigate why this situation occurred.
Open request â€˜00xxxx test requestâ€™ is used to investigate why this situation occurred."
Can you try this
I know there is a issue open at atlassian about this trouble
Hope this helps
I've come across this thread since I had a similar character distortion problem when exporting my jira issues to Excel.
In addition to above comments, what worked for me was; I had to open the exported .csv file with notepad and then save it to csv again but only this time I changed the Encoding to "ANSI" while saving. Then opening the file with excel again I found out that the distortion was gone.
I've run into this problem with several other applications. In every case I could trace it back to copy/paste from a word or other document that had 'smart quotes' instead of the simply ASCII characters from the keyboard. The characters appear fine in the application, but in an exports csv file they end up like yours. By default MS Word has smart quotes enabled.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events