Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,297,138
Community Members
 
Community Events
165
Community Groups

Character conversion errors when exporting to CSV

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.

becomes

Open request ‘00xxxx test request’ is used to investigate why this situation occurred."

3 answers

Thanks, the workaround to open in notepad and save again as csv. Then import in excel, that works.  It's an extra step but acceptable :-)

0 votes

Hello Bart,

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.

0 votes
Joe Pitt Community Leader Sep 10, 2018

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. 

Thanks, but in Excel 2016 I cannot find that option for smart quotes. The workaround suggested in the remarks of Mohamed does work, but it's an extra step. Open in notepad and save again as csv. Then import in excel and that works.

Joe Pitt Community Leader Sep 10, 2018

There is no option in Excel for smart quotes. It is in Word. The issue I found was people copy/pasting text with smart quotes into the application. When the export to csv was don't from the database there were the errors you saw. 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you