Hello everyone,
I am uploading an excel file in Jira and want one field from the excel to appear as check boxes in the description of the ticket. Is it possible?
Thank you
Eric
Hello @Eric Pujo , @Gor Greyan has it right, and it is worth spelling out exactly why, because the boundary here is precise.
Why the import cannot create checkboxes in the description: the interactive checkboxes you see in Jira descriptions are the native action items feature, created in the editor by typing [] followed by your text. Action items have no wiki markup or markdown token at all, which has been confirmed repeatedly by the community and Atlassian's own text formatting notation, there is simply no code that means "checkbox". The CSV importer writes text and markup into Description, so with no markup token to write, no import (and no automation rule) can produce them today.
What the import CAN do to the description: wiki markup in your Description column survives the import, so you can turn your Excel column into a formatted list. Build the Description cell in Excel by joining the values with a line break and a leading asterisk (* item one, * item two), and during import leave "Map field value" unchecked for the Description field, otherwise the importer strips the formatting. Official reference: https://support.atlassian.com/jira/kb/during-csv-import-the-formatting-of-description-field-contents-gets-removed/. You get a clean bulleted checklist to read, just not clickable.
Your three real options, by how much you need the tick behaviour:
For most cases like yours, option 1 for readability plus option 2 for the data is the combination that works, and both happen in one import.
Hi @Eric Pujo
Welcome to the Atlassian Community
If you want the Excel column to become an actual Jira Checkbox custom field, Jira Cloud's CSV importer supports mapping CSV data to an existing Checkbox field.
https://support.atlassian.com/jira-software-cloud/docs/mapping-csv-data-to-jira-fields
If you mean interactive action-item checkboxes inside the Description, the CSV importer does not provide a direct Excel-column action-item conversion. Mapping a column to Description imports its content as text/rich-text content; it doesn't automatically transform each value into Jira action items.
So if the requirement is simply selectable options, I would recommend creating a Checkbox custom field and mapping the Excel/CSV column to it during import.
Regards,
Gor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Based on my experiences, this dead-simple flow could work:
I used Rovo to make these kind of "codified mass updates" with great success.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.