Overview
With Excel-like Tables for Jira, you can map any cell in a table with the effortlessly sync Jira field , vice versa.
Read mapping: Copy the value of the Jira field into a specific cell.
Write mapping: Copy the value of a specific cell into the Jira field. For example, set the calculated results on the table to the Jira field.
Map from Jira view issue screen
Click the right button on a specific cell and select values with table cells, both ways. This transforms the way you manage data, automating updates, minimizing manual input, and keeping your issues always up to date
...
Mapping Jira Fields
1. Map from Jira View Issue Screen
...
Right-click on a specific cell in the table.
Select "Jira Field Mapping"
...
from the context menu.
...
Choose a mapping direction and a target Jira field in the
...
dialog box.
...
The field with Jira mapping is colored with a light blue color to distinguish it from the normal comment, which is colored light yellow.
...
2. Map from the Full-
...
Featured Editor
Select
...
In the shown dialog, select a target Jira field.
...
When is the data reflected in the mapped cell/filed?
...
Read:
Jira field → Cell
...
Write:
Cell → Jira field
...
Timing that read/write executed
...
Table loaded
Comment changed
...
Table saved
...
Notes
...
When you modify Jira fields, it needs reloading a page to reflect the changes to a table.
...
After write action, the table panel will be reloaded.
Supported fields
Fields with numbers, such as a Number custom field.
Fields with a string as a value, such as Summary, Description, and Text custom fields.
Map with the comment (alternative way)
You can map between a field and a cell by writing directives in a cell comment.
Step 1: Add a comment by selecting Insert Comment from the context menu
...
Step 2: Write a read/write directive on the comment
...
...
Read:
Jira field → Cell
...
Write:
Cell → Jira field
...
Notation on a comment
...
read-field <field name>
...
write-field <field name>
Notes:
...
The first directive in a comment is used in the case there are multiple directives
...
the Cell to Map
Click on the specific cell within your spreadsheet that you want to map.
Ribbon Menu Option:
...
Go to the Jira Operations tab in the ribbon menu.
Select Mapping Direction:
Field to Cell (Read from Jira).
Cell to Field (Write to Jira).
Right-Click Option:
Right-click on the cell and select "Jira Field Mapping" from the context menu.
Configure the Mapping
...
In the Jira Field Mapping Dialog, select a target Jira field.
Define whether you want the field to read from Jira (Field to Cell) or write to Jira (Cell to Field).
...
Additional Help & Related Pages
Field to Cell Mapping (Read)
Learn how to pull Jira field values into your table automatically.Cell to Field Mapping (Write)
Understand how to update Jira fields from table values, with and without formulas.