You can export fields from JQL search to excel, xml or Confluence.
The field may have different display formats in the interface and when exporting.
The Custom Field displays the Time spent in In Progress Status in JQL field.
But upon exporting as CSV , it shows an error (JSON format).
For fix: Please set the format you need in the export section in the field settings. It is located at the bottom of the page.
What you are seeing is the field value as it really is - a computed object whose duration lives in the
time property, in seconds. If you are exporting for a BI tool rather than for a human, keep the seconds instead of formatting them: see Field value format and export for BI.








