---
title: Using Jira data in Excel and CSV
description: Start taking the most out of your Jira data outside Jira. The use cases are endless, whatever might be your case, start exporting information now.
image: https://blog.deiser.com/hubfs/EN/Blog/Post/Using%20Jira%20data%20in%20Excel%20and%20CSV/Using%20Jira%20data%20in%20Excel%20and%20CSV%20copia.jpg
---

[![Deiser Blog](https://blog.deiser.com/hubfs/ES/Devoteam/DeiserBlog_Devoteam_logo_negativo.svg "Deiser Blog")](https://blog.deiser.com/en)

[![BACK TO DEISER.COM](https://hubspot-no-cache-eu1-prod.s3.amazonaws.com/cta/default/3363011/36806d56-f0e8-4a64-8033-651e285ac074.png)](https://hubspot-cta-redirect-eu1-prod.s3.amazonaws.com/cta/redirect/3363011/36806d56-f0e8-4a64-8033-651e285ac074)

[EN](https://blog.deiser.com/en) | [ES](https://blog.deiser.com/es)

**

**

[![Deiser Blog](https://blog.deiser.com/hubfs/ES/Devoteam/DeiserBlog_Devoteam_logo_positivo.svg "Deiser Blog")](https://blog.deiser.com/en)

[![BACK TO DEISER.COM](https://hubspot-no-cache-eu1-prod.s3.amazonaws.com/cta/default/3363011/36806d56-f0e8-4a64-8033-651e285ac074.png)](https://hubspot-cta-redirect-eu1-prod.s3.amazonaws.com/cta/redirect/3363011/36806d56-f0e8-4a64-8033-651e285ac074)

[EN](https://blog.deiser.com/en) | [ES](https://blog.deiser.com/es)

**

[![Deiser Blog](https://blog.deiser.com/hubfs/ES/Devoteam/DeiserBlog_Devoteam_logo_negativo.svg "Deiser Blog")](https://blog.deiser.com)

** **

[EN](https://blog.deiser.com/en) | [ES](https://blog.deiser.com/es)

**

**Menu**

[EN](https://blog.deiser.com/en) | [ES](https://blog.deiser.com/es)

** **

[![Free Pack](https://hubspot-no-cache-eu1-prod.s3.amazonaws.com/cta/default/3363011/b010f050-3ec2-4ec3-a9c6-53c6e31a13eb.png)](https://hubspot-cta-redirect-eu1-prod.s3.amazonaws.com/cta/redirect/3363011/b010f050-3ec2-4ec3-a9c6-53c6e31a13eb)

[![Buy Now](https://hubspot-no-cache-eu1-prod.s3.amazonaws.com/cta/default/3363011/45939789-0a7b-42d2-9620-c7619e153fa6.png)](https://hubspot-cta-redirect-eu1-prod.s3.amazonaws.com/cta/redirect/3363011/45939789-0a7b-42d2-9620-c7619e153fa6)

Search

![](https://blog.deiser.com/hubfs/EN/Blog/Post/Using%20Jira%20data%20in%20Excel%20and%20CSV/Using%20Jira%20data%20in%20Excel%20and%20CSV%20copia.jpg)

[Jira Software](https://blog.deiser.com/en/tag/jira-software) | [Atlassian platform (cloud)](https://blog.deiser.com/en/tag/atlassian-platform-cloud) | [Atlassian Marketplace](https://blog.deiser.com/en/tag/atlassian-marketplace) |

 3 min read

# Using Jira data in Excel and CSV

[![Federico Baronti](https://blog.deiser.com/hubfs/Miscel%C3%A1neos/Imagenes-autores-blog/fede-baronti-partner-manager-Deiser.png)](https://blog.deiser.com/en/author/federico-baronti)

 Written by [Federico Baronti](https://blog.deiser.com/en/author/federico-baronti)

 Oct 18, 2023 5:09:48 PM

- [Tweet](https://twitter.com/share)

There are multiple methods to export data from Jira to be processed in Excel. By going through this blog post, you'll learn how to generate advanced reports without the need to leave Jira behind and, at the same time, explore various ways to leverage Jira data in Excel.l.

The most used software tool by managers is Microsoft Excel, and the second most used would probably be Jira. So, Why not consider using them together? This article will look at ways to exploit Jira data in Excel.

### Why Excel remains the preferred tool for managers?

In today's world, with a wide range of technological tools at our disposal, managers' continued use of Excel may seem surprising. However, Excel has maintained relevance in the business world and remains one of the managers' preferred tools for decision-making and data analysis. Next, we will explore the reasons behind this preference and why Excel remains a staple in the business leader's toolkit.

-    **Ease of use:** Explanation of the intuitive interface and low barrier to entry.
-    **Versatility:** Details on the multiple applications of Excel, from budgeting to project tracking.
-    **Data analysis tool:** How Excel makes data and statistical analysis easy.
-    **Customization:** The ability to create formulas and macros to customize spreadsheets.
-    **Compatibility:** The importance of Excel's compatibility with other applications.
-    **Presentation tool:** How Excel is used to create reports and presentations.
-    **History and familiarity:** The role of Excel's history in its continued preference.
-    **Security and control:** The importance of data security in Excel.
-    **Cost-effective:** Comparison of Excel to more expensive tools.

### Now, Why is Jira the first choice of managers?

Jira is one of the most popular project management tools among managers. This popularity is due to many factors, including its ease of use, versatility, and powerful collaboration capabilities.

Then, there are reasons why Jira is the preferred tool of managers and helps improve the productivity and efficiency of work teams.

-    Ease of use: Jira has an intuitive interface that is easy to learn. This makes it an accessible tool for managers with varying levels of experience.
-    Versatility: Jira can manage a wide range of projects, from small internal projects to large complex projects.
-    Powerful collaboration capabilities: Jira allows teams to work together efficiently and effectively. This helps to avoid errors and delays.

In this context, let's go through the best way to extract Jira data in Excel or CSV.

### Extracting information from Jira

[In this article](https://blog.deiser.com/en/seven-ways-to-export-jira-issues), we explain different ways to export issues from Jira. This time, we will check what information you can extract from Jira:

### Using Exporter to export issues to Excel, CSV, and PDF

Extract comments: Exports comments quickly but not only their content. It also extracts the date and author of the comment, as well as the security level of the comment:

![extract-comments-from-jira-using-exporter-deiser-atlassian-marketplace](https://blog.deiser.com/hs-fs/hubfs/EN/Blog/Post/Using%20Jira%20data%20in%20Excel%20and%20CSV/extract-comments-from-jira-using-exporter-deiser-atlassian-marketplace.png?width=700&height=483&name=extract-comments-from-jira-using-exporter-deiser-atlassian-marketplace.png)

Extract transition history: View the entire history of the transitions executed in your issues. With this, you will be able to generate advanced reports, as you will be able to obtain the transition, its date and author, and the time spent in the original state.

![extracting-transition-history-Deiser-ecporter-atlassian](https://blog.deiser.com/hs-fs/hubfs/EN/Blog/Post/Using%20Jira%20data%20in%20Excel%20and%20CSV/extracting-transition-history-Deiser-ecporter-atlassian.png?width=700&height=120&name=extracting-transition-history-Deiser-ecporter-atlassian.png)

Export the approval history: Extracts all information concerning approvals, their final status, date, who has approved, and who has declined.  
![exporting-approval-history-deiser-atlassian](https://blog.deiser.com/hs-fs/hubfs/EN/Blog/Post/Using%20Jira%20data%20in%20Excel%20and%20CSV/exporting-approval-history-deiser-atlassian.png?width=700&height=205&name=exporting-approval-history-deiser-atlassian.png)

### Using Projectrak to export project data

Export all project data to CSV: Export to CSV all the information about your projects, their status, leader, priority, involvement, and more!

![exporting-csv-project-data-deiser-atlassian](https://blog.deiser.com/hs-fs/hubfs/EN/Blog/Post/Using%20Jira%20data%20in%20Excel%20and%20CSV/exporting-csv-project-data-deiser-atlassian.png?width=1920&height=1238&name=exporting-csv-project-data-deiser-atlassian.png)

Export to project change history to CSV: For audits or to review your project history information, easily export your entire change history.  
![export-project-change-history-deiser-projectrak](https://blog.deiser.com/hs-fs/hubfs/EN/Blog/Post/Using%20Jira%20data%20in%20Excel%20and%20CSV/export-project-change-history-deiser-projectrak.png?width=2654&height=1700&name=export-project-change-history-deiser-projectrak.png)

As you can see, not only are there different ways to export from Jira, but there is also a lot of information you can extract from Jira to process in an Excel file and generate advanced reports without leaving your computer.

- [Tweet](https://twitter.com/share)

![Try Exporter for Jira now](https://blog.deiser.com/hs-fs/hubfs/EN/Blog/Post/Using%20Jira%20data%20in%20Excel%20and%20CSV/CTA_Using%20Jira%20data%20in%20Excel%20and%20CSV%20copia.jpg?width=600&name=CTA_Using%20Jira%20data%20in%20Excel%20and%20CSV%20copia.jpg "Try Exporter for Jira now")

## Start exporting your data out of Jira

Sometimes, using your information outside Jira is necessary, which doesn't mean you don't need to stop using the tool. It might be helpful for Jira instances migrations, reports, audits, etc. There are multiple use cases when exporting issues is necessary for the system and the business.

Check the capabilities Exporter for Jira offers to start taking the most out of your data.

[![TRY EXPORTER NOW ](https://hubspot-no-cache-eu1-prod.s3.amazonaws.com/cta/default/3363011/f2e0a7ef-cab4-4610-98e6-cb80268f694c.png)](https://hubspot-cta-redirect-eu1-prod.s3.amazonaws.com/cta/redirect/3363011/f2e0a7ef-cab4-4610-98e6-cb80268f694c)

Previous Story

[← Benefits of choosing Jira Cloud: Important features and apps](https://blog.deiser.com/en/benefits-choosing-jira-cloud-features-apps)

[** ](https://blog.deiser.com/en)

Next Story

[Using Jira for project management →](https://blog.deiser.com/en/using-jira-for-project-management)

## You May Also Like

These Stories on Jira Software

[![](https://blog.deiser.com/hubfs/EN/Blog/Post/Add%20a%20holistic%20project%20management%20operating%20layer%20in%20Jira/Advantages-of-using-the-PMO-Collection-for-Jira-blogpots-cover-Deiser.jpg) ](https://blog.deiser.com/en/holistic-project-management-operating-layer-in-jira)

[Jira Software](https://blog.deiser.com/en/tag/jira-software)

### [Add a holistic project management operating layer in Jira](https://blog.deiser.com/en/holistic-project-management-operating-layer-in-jira)

 Feb 12, 2026 4:37:00 PM |

 6 min read

[![](https://blog.deiser.com/hubfs/EN/Blog/Post/Introducing%20the%20PMO%20Collection%20for%20Jira-%20Centralizing%20project%20data/introducing-the-pmo-collection-for-jira-sentralizing-project-data.jpg) ](https://blog.deiser.com/en/introducing-the-pmo-collection-for-jira-centralizing-project-data)

[Jira Software](https://blog.deiser.com/en/tag/jira-software)

### [Introducing the PMO Collection for Jira: Centralizing project data](https://blog.deiser.com/en/introducing-the-pmo-collection-for-jira-centralizing-project-data)

 Nov 20, 2025 4:37:00 PM |

 6 min read

[![](https://blog.deiser.com/hubfs/EN/Blog/Post/The%20next%20step%20for%20the%20PMO-%20Advanced%20project%20portfolio%20management%20in%20Jira/Ways-to-upgrade-your-project-portfolio-management-for-real-PMO-visibility-blogpost-cover.jpg) ](https://blog.deiser.com/en/pmo-advanced-project-portfolio-management-jira)

[Jira Software](https://blog.deiser.com/en/tag/jira-software)

### [What's next for the PMO? Advanced project portfolio management in Jira](https://blog.deiser.com/en/pmo-advanced-project-portfolio-management-jira)

 Nov 13, 2025 4:53:00 PM |

 7 min read

## No Comments Yet

Let us know what you think

### Subscribe by Email

[![Deiser | Your partner in digital transformation](https://blog.deiser.com/hubfs/ES/Devoteam/Deiser_Part_of_Devoteam_RGB_Full_logo_white-1.svg "Deiser | Your partner in digital transformation")](https://www.deiser.com/)

Your partner in digital transformation

[Let's connect](https://www.deiser.com/contact-us?hsCtaTracking=ed3a14c0-ca98-4ee5-84d6-0c0cc1835409%7C48f243f7-1160-4d08-8b45-5152265f37da)

Calle Pedro Muñoz Seca 2, 6ª Planta.  
28001 - Madrid | SPAIN   
[+34 912 824 700](tel:+34%20912824700)   
[info@deiser.com](mailto:info@deiser.com)

<https://www.youtube.com/user/DEISERCHANNEL/videos><https://www.facebook.com/156907871048762><https://www.instagram.com/deiserteam><https://www.linkedin.com/company/398203><https://twitter.com/deiser>

[Cookies policy](https://www.deiser.com/cookies-policy?hsLang=en) | [Privacy policy](https://www.deiser.com/privacy-policy?hsLang=en) | [Legal statement](https://www.deiser.com/legal-statement) | [Information security](https://www.deiser.com/information-security) | [Sitemap](https://www.deiser.com/sitemap)

![](https://px.ads.linkedin.com/collect/?pid=2244641&fmt=gif) ![](https://px.ads.linkedin.com/collect/?pid=6684234&fmt=gif) ![](https://px.ads.linkedin.com/collect/?pid=2244641&fmt=gif)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Federico Baronti",
    "url" : "https://blog.deiser.com/en/author/federico-baronti"
  },
  "dateModified" : "2023-10-18T15:29:08.670Z",
  "datePublished" : "2023-10-18T15:09:48.000Z",
  "headline" : "Using Jira data in Excel and CSV",
  "image" : [ "https://blog.deiser.com/hubfs/EN/Blog/Post/Using%20Jira%20data%20in%20Excel%20and%20CSV/Using%20Jira%20data%20in%20Excel%20and%20CSV%20copia.jpg" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.deiser.com/en/using-jira-data-in-excel-and-csv",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.deiser.com/hubfs/ES/Devoteam/Deiser_Part_of_Devoteam_RGB_Full_logo_colour-1.svg"
    },
    "name" : "Deiser"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "Organization",
  "description" : "Deiser Part of Devoteam helps you transform digitally, optimizing processes and team collaboration with tailored Atlassian solutions and ongoing support.",
  "logo" : "https://www.deiser.com/hubfs/deiser-logo.png",
  "name" : "Deiser",
  "sameAs" : [ "https://www.linkedin.com/company/deiser", "https://twitter.com/deiser" ],
  "url" : "https://www.deiser.com"
}
```