---
title: "Export issues with PCF fields"
canonical: "https://support.appfire.com/space/PSJ/1589020882/Export%20issues%20with%20PCF%20fields"
format: markdown
---
To select an export format option for your custom field, open the *General *tab of the custom field configuration page and scroll down to the *Export* section.

![configure-export-format.png](media://6ba858ad-ba08-494b-b48f-56f7cb153aeb)

> ℹ️ The Label and Value formats correspond to the KPOption SIL structure properties [here](https://appfire.atlassian.net/wiki/spaces/PSJ/pages/1589019574/SIL+Data+Source#KPOption-Structure).

Consider your intended use case when selecting the format to ensure you have the necessary data in the most useful format. The examples in the table below use PCF - Single Custom Field with Issue Picker.

| **Option** | **Description ** | **Example** |
| --- | --- | --- |
| Historical | This is the original app format that includes both the label and its corresponding value.<br>- Format: Label [Value] | `TES-20 [10019]`, where TES-20 is the label of the issue, and 10019 is the ID of the issue in the Jira database. |
| JSON | Exports the full data structure, including all field metadata and values.<br>- Format: Complete data structure in JSON | > 📝 Depending on how you view the CSV file, you might see the JSON with escaped quotes.<br>- Clean JSON: `{"label":"TES-20","value":"10019"}`
- Escaped JSON: `"{""label"":""TES-20"",""value"":""10019""}"` |
| Labels | Exports only the display labels without their associated values.<br>- Format: Field labels only | `TES-20` |
| Values | Exports only the internal values without their display labels.<br>- Field values only | `10019` |

> ✅ - Choose the **Historical** format if you're unsure which format to use, as it provides the most complete human-readable information.
> ✅ - Use the **JSON** format for system integrations or when you need to preserve the complete data structure. For example, when importing issues with Power custom fields in another Jira instance.
> ✅ - Select the **Labels** format for user-facing reports or documentation.
> ✅ - Use the **Values** format for data analysis or system matching purposes.


---

## Export issues with PCF fields

You can export Power custom fields in any of the following formats available in Jira:

- CSV (All fields) and CSV (Current fields)
- Excel CSV (All fields) and Excel CSV (Current fields)
- HTML (All fields) and HTML (Current fields)

The *All fields* option exports every field available in your Jira issues, including custom fields, while the *Current fields* option only exports the fields currently visible in your issue filter results view.

Each Power custom field is exported according to the format selected in the configuration.

> ℹ️ For additional information about exporting issues in Jira, see the Atlassian documentation.

---

## Export format for PCF - Interval custom fields

When a Power Custom Field of type Interval is exported to CSV, the value is represented in seconds based on Jira's 8-hour working day standard. For example, while displayed as "1w 2d 3h" in Jira, this interval converts to 212400 seconds in exports. Here’s how the value is calculated:

- 1 week (5 working days) = 144000 seconds
- 1 day (8 hours) = 28800 seconds
- 1 hour = 3600 seconds

The result for the field value "1w 2d 3h" exports as 212400 seconds (144000 + 57600 + 10800).