Trace View Export - Broken Formatting in Excel

Jonathan Rivera
Jonathan Rivera
  • Updated

Author: Jonathan Rivera

Date: February 14, 2024

Audience: Everyone

Environmental details: Self-hosted or Cloud

Summary: 

After exporting a report from Trace View, opening the CSV in Excel has broken formatting. This will likely show up as large gaps between rows with seemingly random words being cut off.

Solution:

  1. Check how many characters are in the cell that precedes the broken formatting.
  2. If it is at (or close to) 32,767 characters, that cell is too large for Excel to handle.
  3. Exclude columns from Trace View that are too large. (This will typically be large text fields, such as the Description field.)

Cause:

Excel's character limit for a single cell is 32,767 characters. The formatting in Excel will break right around where a large cell hits that limit. 

Prevention:

Do not include large fields in the Trace View columns when exporting.

Related Articles, Work orders, Zendesk tickets, Defects, etc. 

Additional Information/Metadata:

  • Report
  • Trace View

Feedback: Please leave feedback in the comments below.

 

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.