Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

How to copy table from Confluence to Excel

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:

TitleDescriptionCriteria
Title Name

Line 1

Line 2

  • Bullet 1
  • Bullet 2
  • Bullet 3

 

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

 

TitleDescriptionCriteria
Title NameLine 1Bullet 1
 Bullet 2
Line 2Bullet 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!

3 answers

1 accepted

1 vote
Answer accepted
vikram
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jan 14, 2023

@Uma Krishnamurthy 

We can install chrome extension Table Capture and you can export

Vikram P

James Taylor
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!
Nov 02, 2023

Thank you!!! This worked perfectly! Shocking, that Atlassian don't have an export option though!

0 votes
vikram
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jan 14, 2023

@Uma Krishnamurthy 

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

Vikram P

0 votes
vikram
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jan 09, 2023

@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

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.

Like Lloyd Bullard likes this

replying here as I have the same issue. did you figure out a way of doing this? 

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jun 21, 2023

We do have the "Export to CSV" feature included in our macros (Table Filter, Pivot Table, Table Transformer and Table Spreadsheet) - I'm talking about the Table Filter and Charts for Confluence app that we develop.

Maybe there were our answers across the Community because, as for now, there is no native export to CSV in Confluence.

@Lloyd Bullard - I use Table Capture to export it to Google Sheets as that is the only possible option in the free version. It is a bit of a work after we export to Google Sheets but still saves time compared to doing it manually.

@Stiltsoft support - I am not able to try your application as we use SSO and it does not accept the email address I input. Moreover, we are not on Cloud and that could also be why I am not able to use your app.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events