How to bulk update the Resolved date field using CSV import

Summary

This guide helps to bulk update the Resolved date on work items via CSV import

Prerequisites

Before beginning the import process, ensure your CSV file is properly structured:

• Resolved Date Format: Format your date column precisely as yyyy-MM-dd h:mm a (e.g., 2026-05-26 7:15 PM).

• Resolution Column: Include a "Resolution" column with an appropriate value (e.g., Done, Fixed, Resolved). Jira requires a resolution status to successfully set a resolution date.

Solution

Use the following steps to import your CSV file and update the work items:

Step 1: Navigate to External System Import

1. Log in to Jira with administrative permissions.

2. Click on the Settings (gear icon) in the top-right corner.

3. Select System from the dropdown menu.

4. In the left-hand navigation pane, find the Import and Export section and click External System Import.

Step 2: Upload and Configure the CSV File

1. Click on Switch to old experience > CSV

2. Choose your prepared CSV file

3. Expand the Advanced settings on the configuration screen.

4. Locate the Date format setting and ensure it is explicitly set to:

   yyyy-MM-dd h:mm a

Step 3: Map the Fields

1. Proceed to the mapping screen.

2. Map your CSV file's Resolved column to the Jira target field Date resolved.

3. Map your CSV file's Resolution column to the Jira target field Resolution.

4. Map any other mandatory fields required for identification (such as Issue Key or Issue ID to ensure the correct items are updated).

5. Click Next and run the import tool.