How to copy table from Confluence to Excel

[Uma Krishnamurthy]

When I copy a table from Confluence to Excel, the rows get split in the excel document if I have bulleted lines or if I have separate lines (one line, enter, another line). As a result, I have to manually copy and paste the information from other cells/rows to contain it in one row manually.

For Ex:

Confluence Table:

Title	Description	Criteria
Title Name	Line 1 Line 2	Bullet 1 Bullet 2 Bullet 3

When Copying this Confluence Table to Excel, this is how it looks 

Title	Description	Criteria
Title Name	Line 1	Bullet 1
		Bullet 2
	Line 2	Bullet 3

This becomes a hassle when multiple columns are involved leading to a lot of formatting requirements when I have to present data in excel.

Vice versa works like a charm, data from excel gets copied perfectly to Confluence. The other way is causing trouble.

Please advice. Thanks!

[vikram]

@Uma Krishnamurthy 

We can install chrome extension Table Capture and you can export

Vikram P

[vikram]

@Uma Krishnamurthy 

Please try installing chrome extension Table Capture then you can export to csv.

Vikram P

[vikram]

@Uma Krishnamurthy Welcome to Atlassian Communuity, 

We can edit the confluence page, copy and paste to excel

or

We can export to CSV format,

or

You can try Bookmarklet from below URL 

https://iamdav.in/2014/10/24/bookmarklet-creating-csv-html-table/

Vikram P

[Uma Krishnamurthy]

Thanks Vikram. Option 1 produces the same undesirable result.

How do I export to CSV?

I tried using the Bookmarklet and it does not export to csv when I click on it from the Confluence page.