Where to find the button to extract all issues into Excel?

[Estelle Adam]

Hello, 

I understood that it is possible to extract all US into Excel by simply clicking on a button but I can not located the button. Could you please help? 

Below is my screen : 

[DPKJ · Accepted solution]

To export the issues to a CSV, you can perform the steps below:

- Click to search for issues > View all issues

- Type in the filter what issues you would like to return and, using the detail view, select the columns (fields) you would like to return in the export

- Click on the download icon > Export Excel CSV

[DPKJ]

I am adding screenshots for better understanding, this is deep.

Step 1, Click Search Button, a slider from left will open

Step 2, Click Advance Search for issues button, in slider and search screen will appear.

Step 3, Search for issue based on project or any other criteria, and click on export icon (up-arrow in square brackets)

If column you are looking for is not exported, select configure from more options (on right side of issue details) and add that column to view for export.

[DPKJ]

Based on your screen,

@Estelle Adam  Please reply in this tread only, it will easier for someone looking for same solution to understand.

[Estelle Adam]

I clicked where you mention. 

See the picture below but I don't see 'Configure': 

[DPKJ]

I think this is permission issue. I am site-admin on my account.

I suggest you use all field export if this is available on your screen.

This will solve your problem.

[Estelle Adam]

When I extract all fields, I cannot exploit the Excel file. 

Here is an extract of issue I can read on the excel file. SO I will ask the admin to extract the file for me.  

[DPKJ]

It looks like there is some issue with MS Excel interpretation of CSV file.

Exported CSV file has comma (,) as column separator and carriage-return (\n, enter) as row separator. Please have look if excel is interpreting it correctly.

[Estelle Adam]

I opened the csv file by specifying that coma should be the separator. 

I will check the interpretation. Anyway I will ask the admin to manage the extraction to get only the fields I need. 

Thank you very much for your help DPK J

[DPKJ]

Happy to help!!!

[Estelle Adam]

With the screens it is easier to undertstand. Thank you for adding them. 

I just would like to extract the reference (id #) of all issues and their titles. 

I don't see Configure on my screen. 

[Estelle Adam]

Thank you. Can you please explain what you mean by detail view? Is it the screen where I can view the whole info about a specific US? If so, I don't see the columns you are mentioning. 

My aim is to extract all US I created (about 200). 

[DPKJ]

@Estelle AdamI have added screenshots for help above.