export the data from confluence page to Excel /csv format

chaithra August 26, 2018

export the data from confluence page to  Excel /csv format

3 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

2 votes
Answer accepted
Dave Bosman [Realdolmen]
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.
August 26, 2018

Hi,

 

Please tell us what you want to export, is it only a table? 

is it an export for a plugin? ... !

Give us some more context because this is not clear at all !!!

 

Regards

Dave

chaithra August 27, 2018

i want to export the data/contnet present in the confluence page to csv format.

we have tables in the confluence page.

Dave Bosman [Realdolmen]
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.
August 27, 2018

So, i did a small google search and already found 2 solutions

 

The first one is a good solution if it is only for you. 

First solution

I tested it and it works. 

 

The second is a good solution if you want to give the functionality to all your users. 

Second solution

I did not test this one.

 

Regards,

Dave

chaithra August 27, 2018

Hi Dave,

 

can you help me in performing the first solution.

 can you provide the steps

 

 

i tired this but dint not work :(

Dave Bosman [Realdolmen]
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.
August 27, 2018

In the page you can find following. 

2018-08-27 10_59_50-Bookmarklet for Creating a CSV From an HTML Table.png

 

  • Do as it says and drag it to your bookmarks toolbar.

 

  • Go to the page with the table and click the new bookmark that you created in the previous step. After you clicked the bookmark it will add "Export to CSV" above your table. 
  • Now click "Export to CSV". 

2018-08-27 11_02_12-table - dave - Confluence.png

 

All these steps where described on the page by the way. 

 

Regards

Dave

chaithra August 27, 2018

Hi,

 

Thank you so much ,

its nice and very useful.

Dave Bosman [Realdolmen]
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.
August 27, 2018

Hi @chaithra

If it solved your problem please select it as an answer so that people know this is solved and others know they can use this solution

chaithra August 27, 2018

Hi,

 

i need to send the confluence data as doc or the report format and then send the email ?

can youhelp me in this.

Dave Bosman [Realdolmen]
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.
August 27, 2018

Hi @chaithra

I am not sure what you mean with that? 

Can you please give an example? 

chaithra August 28, 2018

i need to send the confluence data as doc or the report format and then send the email ?

 

eg: we have stored some data or information in the confluence page , those data need to be sent to mail

Dave Bosman [Realdolmen]
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.
August 28, 2018

I'm still not 100 % sure about what you need but,

Do you need this file that you created to be sent automatically everytime? 

Then this is not possible for as far as i know without writing a custom plugin. 

RL October 11, 2022

@Dave Bosman [Realdolmen] your servlet helped !

 

Copy and pasting the table without the servlet was a pain what looked like a single cell in Confluence was multiple rows in excel. The servlet delivered a tidy table that was much easier to work with.

Thanks!

2 votes
Katerina Kovriga _Stiltsoft_
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.
October 2, 2020

You may try the the Table Filter and Charts for Confluence app: export the whole table or use the live filtration (set filters on the fly in the view page mode) and export the filtered result in CSV, PDF and Word.

Live filtration in the view mode:

Live 1.png

Filtering on the go:

Live 2.png

Exporting of the filtered table:

Live 3.png

0 votes
chaithra August 27, 2018

Thank you so much ,

its nice and very useful.

TAGS
AUG Leaders

Atlassian Community Events