Is it possible to add editable table from Excel to JIRA description?

[Paavo]

I have tables that I need to copy-paste to JIRA. Problem is that when I paste it to JIRA it will look different, it doesn't add the formatting. And if I try to add formatting it just gets more difficult to read. So I need to have one standard so that I can copy paste data instead of manually adding data to description. For example:

Age: 30 
Name: Peter Parker
Job: Photographer

Thank you for your help!

[Earl McCutcheon · Accepted solution]

Hello,

Depending on which version of Jira you are on enabling the the Rich Text editor (Visual Mode) will preserve the table structure formatting on a copy and paste from Excel to Jira, this is available on Jira 7.2 and later:

• https://confluence.atlassian.com/jiracoreserver/visual-editing-939937919.html

Alternatively, using Wiki Style Render without the visual editor enabled, Check out this Blog with the conversion process:

• https://www.atlassian.com/blog/jira-software/embed-excel-tables-jira-issues

And this previous community post on the topic that gives some workarounds:

• https://community.atlassian.com/t5/Jira-questions/Convert-a-spreadsheet-into-a-table/qaq-p/195785

Basically you will want to convert tab characters that Excel uses as the delimiter to a pipe character "|" for jira wiki style render to create the table, I also found an online tool that another user created that is built to execute this conversion:

• https://excel2jira.bluurgh.com/

Regards,
Earl

[Paavo]

Thanks! This was helpful :)

[Ihor Uksta]

Hello Paavo,

You can check my answer to a similar question:

https://community.atlassian.com/t5/Jira-questions/How-to-add-a-table-in-JIRA-Issue-description-part/qaq-p/358299#M239357

One thing that I did not mention there is that it's possible to import CSV and Excel files to your table, not copy/pasting but importing the entire file.

Try out those 2 plugins

https://marketplace.atlassian.com/search?query=table%20grid%20editor

[Paavo]

Thanks! This was helpful as well :)