# Feature OP-13291 - Show hierarchies in CSV & XLS-Export

Project: OpenProject
Status: new
URL: https://community.openproject.org/work_packages/OP-13291

## Planning

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Target versions | Wish List |
| Sprint |  |
| Backlog bucket |  |
| Votes | 2 |
| List |  |
| Roadmap |  |
| Relevance |  |

## OPEN POINTS / FEEDBACK

_No work packages_

## Features and Chunks

_No work packages_

## Bugs and other work packages

_No work packages_

## Technical Details

| Attribute | Value |
| --- | --- |
| Module | Modules and project features / Work packages, Modules and project features / Export / XLS Export, Modules and project features / Export / CSV Export |
| Feature Flag |  |
| Requires doc change | No |
| Enterprise plan |  |

## Details

| Attribute | Value |
| --- | --- |
| Pull preview |  |
| Mockups |  |
| Accessibility | No |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Feature Lead |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| PD (min) |  |
| PD (max) |  |
| Work |  |
| Labor costs |  |

## Description

OpenProject 13.0.0 introduced a PDF export that respects the hierarchy of the exported work packages (in most parts). The CSV and XLS exports however do not export them, even if the query being exported has hierarchy mode on.

This is very confusing to users.

Potentially linked to <mention class="mention" data-id="34971" data-type="work_package" data-text="#34971">\#34971</mention> .

### Screenshots and other files

One screenshot showing:

  - Top left the List of packages and their parents / childs
  - Bottom left: Export as "PDF Table" (correctly grouped)
  - Top Right: Export as Excel (opened in Mac numbers): Order of lines incorrect
  - Bottom right: Export as CSV (opened in Mac numbers): Order of lines incorrect

I do have confirmed, that the CSV has the lines in this order in raw data (opened in texteditor)

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/68852/content">
