How to populate newly added custom fields in JIRA tickets from a CSV file?

[Abhishek Singh_PgM_]

My team is currently using a JIRA project to manage requests that we receive from various teams in the organization. We are then transporting this information for every ticket to a google spreadsheet and adding more information in the spreadsheet for every ticket. We realized that all of this information can be easily captured in the JIRA ticket itself. So we added additional fields to the JIRA project so all our existing tickets have these newly added fields but there is no information in these tickets against these new fields because this information exists in a google spreadsheet. Is there a way to bulk upload this information to the existing tickets in JIRA?

Just to explain it further,

I have a JIRA ticket, # XYZ1 that has 6 fields when the ticket was created. I added 10 new fields to the project XYZ so ticket #XYZ1 now has 16 fields. But the data for these newly added fields exist in a google spreadsheet that has 16 columns, 6 from the original ticket and 10 manually added columns. The names of 10 additional fields are the same as the 10 column headers in the google spreadsheet. Can I get the values of these newly added fields migrated to ticket #XYZ1 from the google spreadsheet without having to manually updated the ticket?

[Alan Stephenson · Accepted solution]

If you created the additional fields in your JIRA instance and they are part of the XYZ project (i.e you have them defined on a screen, the context of the fields are either Global or defined to the XYZ project) you can upload the data with no issues. 

If they are text fields you should be good. If they are drop down, single select field I would recommend to populate the field first before you do the import.

[Florian PEREZ · Accepted solution]

Hello,

Using csv import you can add the ID of the issue and jira will consolidate missing data. You'll need to give all the old datas of the issue (so jira doesnt empty the field)

Hope this help

[Joe Pitt · Accepted solution]

You can import from a spreadsheet (csv). You need to have the issue number as part of the row you're importing and only the new information is needed 

[Abhishek Singh_PgM_]

Thanks Joe

I tried but not getting the option to map to exact issue key. Just for an example my issue key is PM-32 and I have this as a row in my csv file but while performing the upload operation I can't map to the same issue key of JIRA project.