Exporting objects provides you a way to feed your data in any other system and do subsequent data analysis. You can also take occasional backups using this feature.
- Click on in the left sidebar of your Jira cloud instance. If you have the alternate navigation in use, you will see this option on the horizontal menu.
- Under Insight, click Object Schemas and select the object schema whose objects you want to export.
- Click on your preferred Object type.
- On the far right, click on the icon and select the option of Export objects as shown below.
- A pop up will be displayed informing you about the objects being exported. It will also ask you to configure few settings for the export to get completed as shown below. The options are described below.
- After you configure all options, click on the Export button. The objects will now be exported to a file in CSV format and will be downloaded on your instance.
The CSV file will contain the header record which is a comma separated (default separator is comma) string of all the names of the attributes for your exported object type. The subsequent rows are the data records for each of those attributes.
Configurable options for export
The table below describes the options that you can set for your export.
This specifies the separator for the values in the header and data records. You can stick to the default comma (,) or choose among:
This denotes the encoding format that will be used for the data records in your CSV file. You can choose one of the following:
This indicates whether the data stored in the CSV file should be Data consistent (unprocessed) or User friendly.
In case you import the data to Insight for data migration or recovery purposes, then Data consistent option will help you to preserve the references and date formats appropriately.
Alternatively, if you use the CSV file with your reporting tool like Power BI or open it in Microsoft Excel/Google Sheets then User friendly option will display the data in a meaningful manner.
Following is a quick reference of what is stored in the CSV file for certain object types in both formats: