Export Table within Jira description

oliver_trebbe
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 3, 2022

Hello community,

we have following goal:

a table within a jira ticket should be exported using a filter and the export details.

Any ideas / solutions / best practices?

 

Regards

 

Oliver

3 answers

0 votes
Jaga November 13, 2024

If you need later to convert Jira table to Markdown (md) table, there are two options what to do with Jira data (which can be taken using the way Sachin provided in the comment above).

1. Try to use online tool such as tableconvert.com. It doesn't have input option for Jira, only output (unfortunately), but still can accept simple tables using, for example, CSV input. It actually has plenty of output table formats.

2. I came up with jira2markdown. Since I worked with huge multiline table, I created a new multiline variable in Python console.

  • >>> multiline_variable = '''\
    ... line1
    ... line2
    ... line3
    ... '''
  • >>> convert(p)
  • remove \n in the output by any technique, this online tool worked for me since I didn't have convenient terminal

 

0 votes
John Ryan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 13, 2024

You can also copy-and-paste the table from the jira ticket into Word, and then copy-and-paste the table from Word into Excel. That preserves columns and rows.

0 votes
Sachin Dhamale
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 7, 2022

@oliver_trebbe 

Welcome to the Atlassian Community

In Jira you can export the issues with description field which has the table but it export the table in the wiki format. see the bellow

 

||Heading 1||Heading 2||
 
|Col A1|Col A2|
 
|Col A1|Col A2|
You have to select the filter in the issue navigator page and export it as Excel CSV.
Accept the answer if it helps
Thanks,
Sachin

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events