You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
This question is a little old, but I found it when I needed the answer to the same question. One of my users needed a list of components in a project that had over 600, so copying, pasting and reformatting was going to be a time-consuming task. I went looking for another way, and what I found is actually relatively simple, but does require a few steps (and Excel).
These instructions for for Jira Cloud, but should work for on-prem as well, you will just need to modify the URL.
Hey Brandon! Thanks for taking the time to document these steps! This has helped one our teams to dump out a list of their 100+ components.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This answer was extremely helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This worked great Brandon, thank you! Do you know if there is a way to include the # of issues with that component? It's shown on the components page, but when I kept all columns when doing "To Table", it wasn't included.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Marco Buchmayer I don't think the count of issues is in the XML. If you are using the API, you can use /rest/api/3/component/{id}/relatedIssueCounts where {id} is the Component ID. Not a great solution if you aren't automating the process as you would have to do each component manually.
You could generate the data yourself if you export the issues and let excel count for you, but I imagine you likely have A LOT of issues if you were looking for this solution. You could also try the google sheets plugin to pull your issue data and then slice-n-dice it, but I'm not sure what the issue limit with that application.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This worked great, thank you so much. Even better, Excel Power Query Editor now supports JSON which is the return format from the API.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Better Excel Exporter for Jira comes with a dedicated Excel export template to export Jira Cloud (or Data Center/Server) projects to a spreadsheet including the Components.
This tutorial article details how you can generate a Jira Cloud project export.
The exported Excel spreadsheet contains details like:
(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I had the same need.
My quick and dirty method:
Good to go.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Quick&dirty, if you cut&paste the entire table from the browser to Excel, the result is pretty good...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Nancy,
Currently, it's not possible to export components to CSV. We have a feature request suggesting the implementation of this ability:
- https://jira.atlassian.com/browse/JRACLOUD-68842
Please, click on vote and watch in order to hear about updates on the development cycle.
Regards,
Angélica
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Atlassian Team,
This functionality would be great to have!
I vote we get this implemented ASAP. (Another suggestion from me is to allow public users to vote here, so i'm commenting to do so) How do you further "gather interest" in that workflow of the ticket above? Thanks and have a good one.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I agree and think this functionality will really help. I am working on a project where we are integrating Aha! and Jira. On Aha! side, I need to provide a list of components from my Project to the Aha! admin to complete the integration. I have no way to export and we have 100s of component in the Project. Any other ideas or workaround?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi! This is only for Cloud? I need to export the components in a project. I have Jira Core Server. Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Brandon Fish , thanks for this method to exptract a list of components. It worked so far.
Would there be a possibility to over write this information in the data base by a correted list since I would like to change all the names of the components? (I have > 200 components). We are in cloud version.
e.g.
old name: D02-40_400 text blabla bla
neu name: D02-40_400 (without the textpart)
Any idea if this is possible?
Thanks in advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Monika Griffin Directly from excel? No. Using your list, you could write some sort of script that loops through each component and updates the name with a new one. Relevant documentation here:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.