Import OKRs

Import OKRs

This page is about OKR for Jira Cloud. Using Data Center? Click here.

The import option allows for the direct import of Objectives and Key Results from external sources into the OKR module, facilitating easier tracking and alignment.

Permissions

Only permitted users can import OKRs:

  • Jira Admin

  • In-module Admin

  • Users granted the Create new OKRs basic permission

  • Users in roles with the Create OKRs advanced permission.

Prepare the CSV file

You can import OKRs from a .csv file. Before importing your OKRs, ensure the data in the .csv file is properly structured.

Sample CSV file structure

The following table shows an example of the correct data structure used in the .csv file. The cells marked with an asterisk (*) indicate the required fields.

Order*

Type*

Summary*

Status*

Period*

Owner*

Weight

OKR type

Labels

Teams

Expected start date

Expected end date

Start value*

Current value*

Target value*

Description

1

Objective

Establish world-class…

On track

 

Agnette Smith

1

 

 

 

 

 

0

2

10

 

1.1

Objective

Increase ARR from…

not Started

Q3 Y2025

Agnette Smith

1

Company

 

Alpha, Beta

 

 

0

0

10

 

1.2

Objective

Optimize sales processes…

AT RISK

Q3 Y2025

agnette.smith@appfire.com

 

Team

 

Alpha

 

 

0

0

20

 

1.2.1

Key result

Increase sales from…

On track

Y2025

Andreas Coppola

1

Personal

 

 

01/01/2025

 

0

0

15

 

Required CSV fields

Ensure that none of the following headers and data under those headers are missing in your file:

  • Order—Each OKR is assigned a unique numeric identifier. Top-level objectives usually begin with whole numbers (e.g., 1, 2), while sub-objectives, Key results, and Jira work items use decimal numbers (e.g., 1.1, 1.2.2) to show their connection to the parent.

  • Type - Specify whether the row represents an Objective, a work item, or a Key result. This field is case-sensitive.

Order

Type

Description

Order

Type

Description

1

Objective

Top-level Objective

1.1

Objective

Sub-objective

1.2

Objective

Sub-objective

1.2.1

Key result

Sub-objective’s manual Key Result

1.2.2

Auto key result

Sub-objective’s automatic Key result

1.2.2.1

Issue

Jira work item linked to a Key result

  • Period - The timeframe for the OKR. It must match an existing period in the OKR module.

  • Owner - The OKR owner's username or email address. The username and email must match the Jira user added to the app.

  • Status - The current status of the OKR. The status must match the built-in statuses in the OKR module. This field is not case-sensitive.

  • Start value (Key Result) - The initial value of the Key Result.

  • Current value (Key Result) - The current value of the Key Result.

  • Target value (Key Result) - The target value of the Key Result.

The start/current/target values for the KRs are required since KRs are imported as manual KRs. By default, the Measure as unit for these values is Numeric. When the OKRs are imported, you can change the progress settings (values and units) for the imported KRs or convert them to auto-KRs.

Optional CSV fields

  • Expected Start/End Date - If the start and end dates of the OKR (format: DD/MM/YYYY) are missing, they will be set based on the period.

  • Description: A detailed explanation of the OKR.

  • OKR type: The type of OKR (e.g., Personal, Team, or Organizational).

  • Teams: A multi-value field to indicate which teams are involved with this OKR.

  • Labels: A multi-value field to assign labels to OKRs for easy categorization.

  • Weight: Represents the OKR’s significance.

Pre-existing data in the OKR module

You cannot import data that has no reflection in the OKR module. If your .csv file does not have the following columns:

  • Owners (users)

  • Teams

  • Labels

  • OKR types

  • Periods

In such a case, the import will fail.

  • Status - The status must match the built-in statuses in the OKR module.

CSV file weight and encoding

  • Ensure your .csv file is under 10 MB and saved in the .csv format.

  • UTF-8 encoding is supported, but avoid using UTF-8 with BOM (Byte Order Mark). This specific encoding can cause import errors.

Import OKRs from a CSV file

  1. On the OKR overview page, open the Overview settings.

  2. Select Import from the dropdown.

Overview settings menu.
  1. On the Import OKR file screen, click +Select file.

Import OKR file modal.
  1. Locate the .csv file on your hard drive.

  2. Click Confirm to finish the upload.

  3. Wait till your OKRs are added.

  4. Click Finish import. This will reset the screen to its initial state and let you to attach a new file.

When the import is complete, you will receive an email confirming that your OKRs were successfully imported. If the import fails, you will also be notified.

Failed to import OKRs (screen)

If there is at least one error, the import will fail, and no OKRs will be added to the module. You may see a screen similar to the one below:

OKR import error screen.
  • Duplicate order numbers - Each order number should appear only once.

  • Incorrect type - Ensure the type entries are either “Objective” or “Key result” (case-sensitive).

  • Period mismatch: Check if the "Period" in your .csv file matches an existing period in the OKR module.

  • Invalid owner: Use a valid Jira username or email address.

  • Symbols in summary: You may experience issues with UTF-8 encoding with BOM. While English text typically works fine, entering alphabetic symbols may cause failures.

  • Missing KR values: Key Results require start, current, and target values.

Correct your data and click the Finish import button before you upload your CSV file again.

Need support? Create a request with our support team.

Copyright © 2005 - 2026 Appfire | All rights reserved.