Any advice on copying tables from Jira into Excel in a manageable way?

Calvin

Hi all, we have a team that gets details from either service desk or internally in jira as a table in the description, an example could be:

Header 1	Header 2	Header 3
Name Value Number	Number	email Value
Name Value Number	Number	email Value

 

The problem is when copying this to Excel it sort of becomes:

Header 1	Header 2	Header 3
Name
		Email
Value	Number
		Value
Number
Name
		Email
Value	Name
		Value
Number	Value
	Number

 

I've tried exporting to word and copying that to Excel and no dice, and I've also tried copy and pasting to confluence (which looks okay) but then copying it from confluence to Excel again creates the above.

I've also tried copying it to notepad and then to excel, but it just takes it all as one big long text with nothing that cuts it inbetween to even import as like a csv or similar.

Would love to hear if others have ran into a similar issue.

KD - Ricksoft

Hey ya Calvin,

Noticed you were trying to achieve it via Confluence too. You can try our Excel-like Tables for Confluence plugin, there’s a “Convert Confluence Table to Excel-like Tables” option that lets you turn a an existing Confluence table into an editable spreadsheet on the page. 

I gave it a go with the table you posted, it worked, though I had to set the columns to wrap text to get it looking closer to what you wanted. We are also actively improving this feature, especially now that Atlassian has added more features to their native tables.

We also have a similar plugin for Jira (Excel-like Tables for Jira) that gives you the same embedded spreadsheet experience right inside an issue. The only catch is it doesn’t have the “convert table from description” feature. 

But give it a try and see if it can fit in to your workflow 

Kind regards
KD