Jira is not recognising my upload from CSV of multiple choice answer


Looked through the comments and don't know if this has been answered.

I'm creating a CSV template for some analysts, they would need to fill it and I then do a bulk upload to Jira.

I want to upload them as defects. The issue I'm facing is:

I have a label when filling out a defect and I want to select one of the options, so for example I have a label called 'Label A' and it has 3 options in a list.

In the excel file I put the top row as 'Label A' and under it for one of the entries I put the full name of one of the options on JIRA, for example 'Option A'. But I write this in the excel file as : Option A

But after uploading it does not recognise this and returns a validation error.

This is the same for a tick box label, for e.g. 'Label B'

I put the label heading in to excel and put the text of one of the label options in the excel file, but it still returns a validation error...?

However any text that I put up, (Something that requires free text and is not a multiple option) like for example 'Summary', I would put any random text e.g. 'abcd', and this will validate fine.

So my question is, what am I doing wrong with the way I'm formatting my CSV for when I upload answers to multiple choice parts of a defect....?

This is the defect on JIRA that I'm trying to upload for:

image2015-7-3 10:53:42.png

Scope Type for example is a multiple choice tickbox, this is what I have in the csv file that I upload:

image2015-7-3 10:55:3.png


However after uploading and mapping in JIRA it comes back with a validation error.




After uploading a csv file from notepad like this:

image2015-7-3 15:14:46.png

I still have this validation error.... sad :

image2015-7-3 15:14:27.png

2 answers

Can you provide screenshots for extra information and what not


I'm having difficulties in reproducing your problem. Here's what I am doing to import issues with Checkboxes filled in.

  1. I have added a Checkbox custom field (Some Type) to my project, it has two options "Option A" and "Option B" so my project creation screen looks like this:
  2. Then I've prepared a simple CSV file:

    Summary,Some Type
    Oranges,Option A
    Apples ,Option B
  3. Then I started a non-admin CSV Importer (Issues -> Import issues from CSV), I choose my field mapping as on the screen below:


  4. Then I run validation/import and everything seems to work flawlessly.

In your case please make sure that:

  • Your Custom Field "Scope Type" is a standard JIRA Custom Field (e.g: Checkboxes) if it comes from 3rd party plugin that is not maintained by Atlassian, than we cannot guarantee it correctness during import
  • If you are using excel, please remember to save file as CSV


Hi I have saved the file as CSV, and even though I do have an issue with the checkbox ( the one I state and the one I have provided screenshots) I think there is an issue on how I am formatting the CSV? I'm not to sure

Can you try first some small import with manually created CSV file (e.g: in notepad)? So we can rule out that the problem is in file format. Try for example file: Summary,Issue Type,Scope Type 30229, Defect, BTD Scope (just as on your screenshot)

Hey, I s please see.added some more screen shot

Make a second line out of the values, so the second line starts from 30229, just as in my comment above.

still issues *Sigh :( ........ I added a screenshot

Don't use spaces in the second line after commas

hi .. were you able to upload the csv after those changes? I'm finding similar issues and not able to upload the csv file :-(

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,145 views 4 9
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you