How to Export CSV Data from Jira and Import It into clariBI

Jira is the industry-standard tool for agile project management and issue tracking. You can export issue data as CSV files from any search or filter and import them into clariBI for AI-powered analysis of sprint performance, team velocity, and issue trends.

What You Can Export from Jira

• Issue records with summaries, descriptions, and statuses
• Issue types (Epic, Story, Task, Bug, Subtask)
• Assignee, reporter, and watcher information
• Priority levels and labels
• Sprint membership and story point estimates
• Custom field values
• Created, updated, resolved, and due dates
• Component and version assignments
• Comments and worklogs (limited in CSV)

Export CSV Data from Jira

Method 1: Export from Issue Search (Filters)

1. Log in to your Jira instance (Cloud or Server)
2. Click Filters in the top navigation and select Advanced issue search (or go to the search bar and click Search)
3. Build your search query using JQL (Jira Query Language) or the basic filter fields
4. Example JQL: `project = "MY-PROJECT" AND status changed during (startOfMonth(), now()) ORDER BY created DESC`
5. Once the search results display, click the Export button in the top right corner
6. Select Export CSV (all fields) to include every field, or Export CSV (current fields) to export only the columns visible in your current view
7. The CSV file will download with all matching issues

Method 2: Export from a Board

1. Open your Scrum or Kanban board in Jira
2. Boards do not have a direct CSV export option. To export issues from a board, click the board name or filter link at the top to navigate to the underlying filter in the issue navigator
3. Once in the issue navigator, click the Export button in the top right corner
4. Select Export CSV (all fields), Export CSV (current fields), or Export Excel CSV to download the data
5. The export will include all issues matching the board's filter

Method 3: Export from a Saved Filter

1. Go to Filters > View all filters or My filters
2. Open a saved filter that contains the issues you want to analyze
3. Click Export in the top right corner
4. Choose Export CSV (all fields) or Export CSV (current fields)
5. Download the CSV file

Method 4: Export Sprint or Version Data

1. Navigate to your Scrum board and go to Backlog
2. Locate the sprint you want to export
3. Click on the sprint name to filter for issues in that sprint
4. Use Method 1 to export the filtered results
5. For version-based exports, use JQL: `fixVersion = "1.0" ORDER BY priority DESC`
6. Export the results as CSV

Tips for Clean Exports

• Jira Cloud allows exporting up to 10,000 issues at a time (increased from 1,000 as of March 2025). If your filter returns more, narrow it using JQL filters and export in batches
• Use the "current fields" CSV export option to get a cleaner file with only the columns you need for analysis
• The Export Excel CSV option produces a file optimized for opening in Excel with proper encoding
• Include story points, sprint name, and resolution fields in your JQL export for sprint velocity analysis
• Export regularly at the end of each sprint to build historical data for velocity and burndown trend analysis in clariBI

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Jira - Sprint 12 Issues")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "What is the bug-to-feature ratio in the last 3 sprints?"
- "Show me the average story points completed per sprint over the last 6 months."
- "Which team members resolve the most issues and what are their average resolution times?"

clariBI's AI will automatically analyze your data and suggest relevant insights.