Comments are replaced by hyphens

[hhasan]

Hi,

My Jira comments are being replaced by hyphens in Excel.

So if the comment was "I am looking into the issue" in Jira. It appears like this in Excel:

Hadeel Hasan   Date/time

----------------

[Aron Gombas _Midori_]

@hhasan What language or character set are you using? The symptom suggests that it may be a problem related to those...

You can use the Better Excel Exporter to export comments with your selected fields or all non-empty fields:

... to Excel:

It will export comments correctly, written in any language or character set.

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

[hhasan]

Hi Aron,

I am confused as to why I'd need to use the  Better Excel Exporter when comments used to be imported to Excel just fine. I will have to ask my manager if they are willing to use this tool. Thank you for your help.

[Aron Gombas _Midori_]

If you can fix the problem, keep your current tool and happy with it, then you do not need an additional app. I agree with that.

I thought if you needed a quick solution to your use case, then using an alternative app that "just works" is a viable option. (If it is a one-time export, you can install our app, export your comments, then uninstall the app.)

[hhasan]

Unfortunately, this is needed on a daily basis. Comments used to be displayed just fine in Excel then all of a sudden they are not. I do not know what happened/changed.

[Petru Simion _Simitech Ltd__]

Hi @hhasan , 

That usually happens when comments are exported through tools that don’t handle Jira’s rich-text / formatting properly, so Excel ends up showing placeholders (like hyphens) instead of the actual content.

If you’re using a third-party app or a custom export, the issue is almost always in how comments are parsed and written to CSV.

If your goal is to reliably extract Jira comments into Excel, especially when you need to:

• search for specific text inside comments

• limit results to specific issues or projects

• filter by author or date

• export the actual comment content cleanly to CSV

you might want to look at Advanced Comment Search for Jira. Our team built it specifically for searching and exporting comments, and the CSV export preserves the comment text so it opens correctly in Excel without being replaced by hyphens.

That said, if you share how you’re currently exporting (built-in Jira export vs. app vs️️ vs. API), it’ll be easier to pinpoint exactly where things are breaking.

Regards, 

Petru

[hhasan]

Thanks Petru. I will see the "Advanced Comment Search for Jira". The thing is this has started to happen recently. I don't know what changed. We run the Jira report, hit Export and open the downloaded file in Excel and that would be it. Comments would be there instead of showing only as "-------".

[John Funk]

Hi Hadeel,

How are you getting your comments from Jira to Excel? What are the exact steps? Are you using a third party app? 

[hhasan]

Hi John,

I select Reports and Timesheets, select the report, (it then automatically runs in the background), hit Export then open the downloaded file in Excel.

[John Funk]

Is that from a third party app? 

[hhasan]

These are steps are in Jira itself.