Issue with exporting to Excel

[SanjayDFT]

[Write your comment/feedback/issue here]
Hi Mr Rappen, hope you're well.
I have an issue with exporting my XML query. For one of my columns (description), contains newline (line break) characters. This result cause multiple rows to appear without any data except for that column. Here's my xml query:

<fetch>
  <entity name="incident">
    <attribute name="ceox_casetype" />
    <attribute name="ceox_datereceived" />
    <attribute name="dft_division" />
    <attribute name="dft_documentdraftlink" />
    <attribute name="dft_draftduebyslaoverdue" />
    <attribute name="dft_draftertracker" />
    <attribute name="statuscode" />
    <attribute name="ceox_casestub" />
    <attribute name="description" />
    <filter>
      <condition attribute="createdon" operator="on-or-after" value="2024-06-01 09:53:37" />
    </filter>
    <filter>
      <condition attribute="createdon" operator="on-or-before" value="2024-11-30 09:54:22" />
    </filter>
    <link-entity name="team" from="teamid" to="dft_division" link-type="inner" alias="Directorate">
      <attribute name="dft_directorate" />
    </link-entity>
    <link-entity name="ceox_approval" from="ceox_case" to="incidentid" link-type="inner" alias="approver">
      <attribute name="createdon" />
      <attribute name="ownerid" />
    </link-entity>
  </entity>
</fetch>

I tried to use the SQL 4 CDS which has more flexible and range in terms of queries but when I tried to execute, it closed the XRM toolbox itself without any thrown error. The execution query contain more code in terms of replacing the empty characters. Please provide your opinion and feedback on this.

---

• Deployment: Online
• DB Version: 9.2.24112.206
• Connection Controls Version: 1.2023.6.56
• XrmToolBox Version: 1.2023.12.68
• Tool Version: 1.2024.10.1