Issue
How to Export Work Notes and Additional Comments in an Incident via Export to Excel
Resolution
Export to Excel works in list view only and it exports only those columns which are added in the list view.
You can add Columns - 1. Work Notes 2. Additional Comments in the list view and export the list of incident to Excel.
Please note that - Since Additional Comments and Work Notes are diary fields, all the work notes are exported in single cell of the excel file. This also means that Excels imposed limit of number of characters in 1 cell will also apply on the export.
Related Links
In versions earlier to Istanbul Patch 1, Journal fields (Work notes and Additional Comments) couldn't be exported to reports (csv, excel, pdf). This issue was fixed in Istanbul Patch 1
https://support.servicenow.com/kb_view.do?sysparm_article=KB0598748
