Share this page

# Export data

You can export data from grid views to an Excel or CSV file. You can also export dashboards to HTML.

In this topic:

## Export data to Excel

Use the export to Excel option when you need to export multiple items in a single export operation.

When exporting backlog items, tests, or test suites to an Excel file, you can export items for the purpose of re-importing the file after you add or make changes to the items.

To export data to Excel:

1. Open the grid whose data you want to export.
2. (Optional) Set up a filter for the entities in the grid to show the items you want to export. For details, see Filters.
3. (Optional) Group the grid's entities. The exported report reflects these groupings. For details, see Group items.
4. Select the grid items that you want to export. To export the entire grid, make no selection, and all items will be exported.
5. In the toolbar, click the Export to Excel button .

6. For backlog items, tests, and test suites, select the export purpose.

   Export purpose | Details
   --- | ---
   Reporting | The resulting Excel sheet closely resembles the grid: All the grid columns are exported to Excel in the same order as in the grid. If the exported grid is grouped or sorted, the group-by or sort-by field is placed in the first column in the sheet. The fields of related items are included in the export file, if the fields were added to the grid. Reference fields, such as linked defects or related requirements, are displayed in "ID - Name" format. The Last runs field is represented in the export file by four number columns: Planned, Passed, Failed, Requires Attention. When exporting tests with their steps, each test and its steps are exported to a test's own sheet. Note: By default, you can export up to 255 tests with their steps. To increase the limit, use the EXPORT_TEST_STEPS_TO_EXCEL_MAX_ENTITIES parameter. See Configuration parameters.
   Import | When exporting for the purpose of import, the export file contains changes that make it compatible for import. These include the following: Items of each type are listed in separate sheets. The sheets are labeled accordingly. Example: When exporting the backlog grid for import, defects are listed in the defects sheet, user stories in the user stories sheet. The column headings use the fields logical names, not the user-facing labels. Example: The heading of the ID column is unique_id. An extra `type` column is added, representing the item's type (such as story, defect).

7. If you selected Import as the purpose of exporting, select your intention for importing.

   Import purpose | Details
   --- | ---
   Update existing | Your purpose for exporting is to re-import the same items with modifications. The IDs in the resulting file are preceded by @. When re-importing, it indicates that the existing item with the matching ID should be updated.
   Create new | Your purpose for exporting is to import the items to another workspace. You can also use this option to create a template file that you can re-import with new items.

Note:

- Admins can control the ability to export to Excel using the Generate Excel Report permission. For details, see Permission categories and types.

- By default, in fields that support multiple values, the values are separated with a comma. Admins can change the value delimiter by modifying the EXPORT_IMPORT_MULTIVALUE_DELIMITER parameter. Changing the delimiter affects all files that are imported or exported for re-import.

- When exporting test suites or tests with call steps for re-import, the tests or called tests may already exist in the target workspace. Set the following parameters accordingly: EXPORT_FOR_IMPORT_TEST_SUITE_TESTS, EXPORT_FOR_IMPORT_CALLED_TESTS

  For details, see Configuration parameters.

## Export data to CSV

Export to CSV lets you export up to 60,000 items in a single export operation.

To export data to CSV:

1. Prerequisite:

   Export to CSV requires the Generate CSV Report general system permission. For details, see Permission categories and types.

2. Select items that you want to export from a grid view, and click the Export to CSV button .

## Export dashboards to HTML

You can export a dashboard snapshot as an independent .html file. This can help you get a static version of the dashboard, and use it as a baseline or for audit purposes. For details, see Export an HTML dashboard snapshot.

## Notes and limitations

Data export has the following limitations:

- You cannot export to .CSV for the purpose of re-importing the file after you add or make changes to items.
- Export to Excel lets you export up to 2,000 items in each export operation. If you select more than 2,000 grid items, the Export to Excel button is unavailable.
- Export to CSV lets you export up to 60,000 items in each export operation. If you select more than 60,000 grid items, the Export to CSV button is unavailable.
- If you export entities with an identical custom field type (for example `String`) and identical field name, this field name is used in the column header, rather than the entity's unique field label.

## See also

- Document reports
- Import from Excel

https://admhelp.microfocus.com Software Delivery Management 8942
Tips to improve your search results... OpenText™ Software Delivery Management Help Center OpenText™ Software Delivery Management Help 26.3 All View Local Help Center View Online Help Center Version: