Comma in a text field breaks CSV export

Atlassian Update – 28 August 2018 Hi everyone, I am going to resolve the current issue as Not a Bug. Our research on the subject of CSV export showed that current problem affects only certain configurations of Microsoft Excel. The investigation demonstrated that other spreadsheet management software is not affected by the reported problem at all. Root of the problem Depending on the country in which the Microsoft Excel is installed a certain region is assigned to it's configuration. The region would determine a decimal point separator - such as used in different currencies. For example you can see a comma and dot as decimal separator for representing different amounts: 123,45 vs 123.45. 28 August 2018 update More delimiters for CSV export were shipped with Jira Software Server 7.9. You can now choose one of the four delimiters when exporting your issues to CSV. These are  comma ,  semicolon ,  vertical bar , and  caret  (this one: ^). You can read about other capabilities we added in Jira Software 7.9 in the  release notes . Impact of CSV export feature on Jira users Jira 7.2.0 released featuring new CSV export, which deprecated previous Excel export. This had the following impact: CSV export has different format of the data export which creates frictions in using data just the same as it used to be with Excel export. certain Excel uniqueness with CSV handling delivers sub-optimal user experience for certain regions.   Acknowledgement After reading all your feedback around CSV export feature we realised the change introduced unnecessary friction for the simple use cases. On the other hand - supporting a native Jira to Excel would be a significant effort which would limit our ability to deliver on other improvements such as hi-impact bugfixes we deliver now, security bugfix and new features. With the feedback provided we could not leave the situation unattended. Which led us to the following solution..   Our solution We decided to re-enable the legacy export. This has been done in Jira 7.4.0. https://confluence.atlassian.com/jirasoftware/jira-software-7-4-x-release-notes-902079634.html We have changed the name of the export to 'HTML Export'. That is done as Jira has never supported a native export Excel export: even up until Jira 7.2 data had been always exporting data in the html format but was just changing an export file extension. The exported html data can be imported in Excel just as any .xls, .csv, .html file. If that creates too much friction - you can still make Jira export an '.xls' file. How to make Jira export .xls file instead of .html file Please edit file jira-config.properties and make sure the line for jira.export.excel.enabled exists and looks like: jira.export.excel.enabled= true After file is saved - restart Jira. Export to Excel button should appear in the Issue Navigator along with Export to HTML. This workaround works for Jira versions since 7.2.0 upwards (at the moment of writing up until 7.6.0).   Alternative solutions Plug-in  Better Excel Plugin  provides native Excel export via XLSX files.   Feedback Please don't hesitate to provide to provide additional feedback on the issues JRASERVER-62517 , JRASERVER-63857 . Please post your questions, clarifications, etc. Your feedback has helped to change the shape the feature in Jira 7.4.0 and we'll continue to listen to deliver the appropriate solution in the product. Thanks for the inputs! Cheers, Ignat Alexeyenko Jira Bugmaster