It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Import Work Log items (Planned/Estimate/ToDo) via CSV


I want to import the work log items corresponding to Estimated effort/Time Spent(Logged)/Remaining Time into JIRA via CSV file. I could not find any field name applicable for the CSV for these fields (except Time Spent).  After import, I would like to see these 3 fields populating against the fields as displayed in the below image.

The JIRA documentation only says this (only one field - Worklog/Logged) -

Importing worklog entries

Your CSV file can contain worklog entries. For example:


Only time spent (one hour),3600
With a date and an author,2012-02-10 12:30:10;wseliga;120
With an additional comment,Testing took me 3 days;2012-02-10 12:30:10;wseliga;259200


To track time spent, you need to use seconds.

Please help.  



2 answers

1 accepted

1 vote
Answer accepted


please mind that JIRA has two CSV Importers:

  • non-admin CSV Importer available under Issues top menu
  • admin CSV Importer available under External System Import in System settings

The second is available for administrators only and by default can import to any JIRA field. The first one is meant for non-administrator users and can only import to fields that are present on Create Issue Screen (a way of bulk-create issues).

All fields that you are looking for should be available under the second importer.


I am trying to update an existing issue with 'Total Effort Estimate' value through External System Import. Please note that there is no values set for Original Estimate or Remaining Estimate for this particular artifact. My csv looks like the following:

Issue key, Summary,Issue Type,Total Effort Estimate

1, "hello world", Bug, 3600

After the import, I do not see any updates in the work log section (no work log section at all actually !).  

Can we add a total effort estimate to any artifact if there is no original/remaining estimate set ?

Please help.



Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you