Skip to content
English
  • There are no suggestions because the search field is empty.

Import ticket data via CSV (Create / Update / Delete)

This section explains the procedure for importing ticket categories (Tasks, Issues, Bugs, Stories, etc.) via CSV.

 Only users with an Innovator or Leader license can import ticket data via CSV. 

  1. In the side menu, click [Tickets] > [List].
  2. Click the […] (three-dot) icon next to [Add New] in the upper-right corner of the screen, then select [CSV Import].
  3. In the [CSV Import] dialog that appears, click [Download Sample] to download the CSV template.
  4. Edit the CSV file according to the input rules, then drag and drop it into the [Drag and drop a file here]* area.
  5. Once the CSV file has been validated, click [Run Import].
  6. In the [Start Import] dialog that appears, click [Yes].
  7. When the import process is complete, you will receive a notification via the bell icon in the header.

 

 Input Rules 

 

Agile ticket CSV file must contain the following information:

  • ID: Enter an existing ID when updating or deleting a ticket.
  • Temporary ID: Used as a temporary ID when creating new tickets. It can also be used for parent-child and related ticket references.
  • Delete: To delete a ticket, enter the delete value corresponding to the current display language. ID is required for delete rows.
  • ID and Temporary ID: They cannot be entered in the same row. Enter only one of them.
  • Required fields: Enter Title, Classification, and Status.
  • Classification: Enter one of "Story", "Task", "Issue", or "Bug". (Epic, Release, and Iteration cannot be created here.)
  • Subtask: Enter "Task" as the ticket classification.
  • Status: Enter a status corresponding to the ticket classification.
  • Priority: Enter one of "Urgent", "High", "Medium", or "Low".
  • Dates: Enter in YYYY/MM/DD or YYYY-MM-DD format.
  • Epic / Iteration / Release: Enter the name of an existing Epic / Iteration / Release (not the ID). If the name does not exist in the project, the row is skipped as an error.
  • Story Point: Enter an integer.
  • Assignee / Watcher: Enter an email address.
  • Related Item: Enter an ID or Temporary ID.
  • Details: Use "
    " if you want to insert a line break.
  • Multiple values: In the Watcher and Related Item columns, separate values with "|".
  • Sample file: Available from "Download a Sample".

 

記入例

Field Example Notes
ID 1 Used to identify the ticket to be updated or deleted. Leave this field blank when creating a new ticket.
Delete Delete A row will be deleted if “削除,” “Delete,” or “delete” is entered.
Temporary ID 2
A temporary ID used to create relationships within the CSV file. Enter an integer that does not duplicate an existing ID.
Parent Ticket ID 1
To create a parent-child relationship between tickets, enter the ID or Temporary ID of the ticket you want to set as the parent.
Classification Issue
Enter one of the following: Phase, Deliverable, Task, Issue, or Milestone.
Title Create design document  
Status Not Started
Enter a status configured for the selected classification.
Story Point 2
Enter an integer.
Epic My Page Redesign
Enter the name of an existing Epic.
Iteration Create Wireframes Enter the name of an existing Iteration.
Release v2.4.0: Add Payment Methods Enter the name of an existing Release.
Assignee Email Address yamada_taro@mail.com
Enter an email address.
Assigned Team Operations Team Enter the name of an existing team.
Planned Hours 4.15 Enter a number greater than or equal to 0, with up to two decimal places.
Actual Hours 5 Enter a number greater than or equal to 0, with up to two decimal places.
Priority High Enter one of the following: Urgent, High, Medium, or Low.
Start Date 2026/03/09 Enter the date in YYYY/MM/DD format.
Due Date 2026/03/14 Enter the date in YYYY/MM/DD format.
Actual Start Date 2026/03/09 Enter the date in YYYY/MM/DD format.
Actual End Date 2026/03/14 Enter the date in YYYY/MM/DD format.
Watcher sato_ichiro@mail.com
Enter an email address.
Created By

-

You may leave this field blank. The system sets it automatically, so any value entered will not be applied.
Created Date - You may leave this field blank. The system sets it automatically, so any value entered will not be applied.
Updated Date - You may leave this field blank. The system sets it automatically, so any value entered will not be applied.
Details Sample text HTML is supported.
Related Item 2
Enter the ID of the ticket you want to specify.

 

A maximum of 5,000 records can be imported at one time.

⚠️ If the import fails

If an error occurs during the import, see "Troubleshooting CSV Import Errors".