When I am pulling a Backlog export for all columns, can I change the column order?

[sarah_a_weissman]

I want to pull a Backlog export for ALL columns, and I would like to change the order. This feature is available for a certain subset of the columns, but not all columns. 

[John Funk]

Hi Sarah - Welcome to the Atlassian Community!

You might try creating a filter such as Project = ABC and Status = Backlog

Then chose Export this filter to another format under the Download icon. 

Then select Export Excel CSV (all fields)

I hope that helps!

[sarah_a_weissman]

Thank you! We are already doing that, but are stuck on how to indicate the order of the columns in the exported file.

For example, we want Column A in the exported file to be "Description" and Column B to be "Status," which is not the order that is exported.

[John Funk]

Do you have them in that order in the filter?

[sarah_a_weissman]

I just used basic JQL with field names and the equal operator. Can you give me an example of how to change the order in the field?

[John Funk]

Sure - just create and run your JQL. Then make sure it is set to List view in the Change view menu:

Then simply click on the Column heading and drag it to the right or left to order it how you want. You should be good to go. 

The download will have the Issue Id and Parent Id column also in it (usually the second and third columns in Excel). I haven't figured out how to not download those because they are not in my filter. But I just do a quick delete on those two columns. 

[sarah_a_weissman]

That seems to work, however, I would like to export all the columns. I can only select a certain number of columns, then reorder them. When I select columns, the view only allows me to go to "E" (see picture below).

This would work if I were able to select all the columns.

To summarize, here is what I would like to do:

• Export ALL columns
• Reorder the columns
• Export as Excel/CSV
• Save the JQL Query/column order so it is reusable by me and others (to save time)

[John Funk]

Yeah, you have to start typing the name of the field and it will go to that field. Not sure why it works that way - a little frustrating. 

I would suggest adding all of the columns you want and then just do Current Columns. Otherwise you will get every custom field in your list and will have to delete out all of the irrelevant ones.