Export table in a confluence page to excel?

Christoph Richter May 26, 2014

Is it possible to export a table within a page to excel??

15 answers

1 accepted

34 votes
Answer accepted
Davin Studer
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 24, 2014

I have created a browser bookmarklet that will allow you to create CSV files from an HTML table. It should work on pretty much any web page ... including Confluence. All you have to do is drag the bookmarklet to your bookmarks toolbar in your browser and then on your Confluence page click the bookmarklet. It will then create a link right before each table on you page that says Export to CSV. If you click that link it will prompt you where to save the CSV file and then you can open it in Excel and do what you want with it.

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

Jean-Pierre Chiri November 16, 2015

This work like a charm :! Great code !

Like Jorge Martinez likes this
Davin Studer
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.
November 17, 2015

Glad it helped. :)

Daniel Roberts December 31, 2015

This is absolutely beautiful.

Claire Townend August 23, 2016

Very helpful, thanks!

Rachel Hyde January 24, 2017

This is great. Thank you for sharing it!

Raghu WR
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!
July 30, 2017

Brilliant,saved hours of manual work. Thanks so much.

boardtc
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 18, 2017

Superb

Kate Hanna October 14, 2017

That is fantastic. Thanks very much!

Ross Davis November 1, 2017

Well done! Exactly what we needed.

Andrew Barakat
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!
April 12, 2018

This is heroic.

Edgard Sulyma
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!
April 20, 2018

You sir, are a genius!

JackChivers
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!
October 28, 2018

Dude
I certainly owe you for saving me well over 30 minutes of data entry into excel.
You bloody legend.

Adrian Maftei
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!
November 14, 2018

 The link provided in the mentioned URL is broken.

RiFa January 7, 2019

The link is broken indeed :-(

Davin Studer
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.
January 7, 2019

My server went down again. It's back up. I've got a monitor on it now, so I should be alerted if it goes down again.  Grr!

Deleted user January 8, 2019

Another fan is born Davin, thanks for the magic bookmarklet!

Gezim Shehu [Communardo]
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 15, 2019

Wonderful :)

Pallvi Pathania
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!
February 4, 2019

This is brilliant! Thank you :)

Like Davin Studer likes this
Nancy Stronczek February 15, 2019

Thank you so much for this tool.  Someone in my organization thought it was wise to put together a Confluence table with 550 rows and 14 columns.  And I now have to add 2 more columns and update about 30 items.  Needless to say, Confluence is vomiting all over me.  This saved my day!

Davin Studer
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.
February 15, 2019

Lovely! Glad it helped!

Anand Verma
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!
May 20, 2019

Thanks very much for helping with this bookmarklet!!

One requirement that I have is to export the contents which has hyperlinks in it. Currently, the exported data doesn't retain any hyperlinks. Is there a way I can export the contents with hyperlinks?

WR,

Anand

Anand Verma
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!
May 20, 2019

I downloaded the latest version of Export to CSV and unfortunately its not working as expected.  

1. The exported CSV is somehow not exporting the first row's 5,6,7,8,9 and 10th Cells  from the Heading row. 

2. The last row had a Â  preceding every value in the last row. 

I will be extremely thankful to you if you could fix this and meanwhile share the link of the initial bookmarklet so that I can continue to do my work while you fix it :)

Many Thanks brother!

Anand

Tom Harris - Old Street
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, 2019

Thanks David! This is really useful :)

Davin Studer
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, 2019

@Tom Harris - Old Street You're welcome. Glad it is useful.

Chaitanya
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!
September 25, 2019

Hi Davin, this browser bookmarklet is brilliant however when we extract the HTML tables with the dates, it shows symbol   for all the fields that have dates upon exporting the table to csv file. So I am not sure if there is any work going on to take care of this issue. Please let me know but thank you for this awesome tool.

If it is blank, then it shows good but any date is shown as  

Robin Zhang
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!
January 14, 2020

it works when i  use chrome of currently version .thanks !

Artem Pozdnyakov
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!
April 23, 2020

Genius! Thanks a lot!

Agnieszka Kornas
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!
June 10, 2020

As perfect as CSV can be with polish letters and links to jira;) 
Awesome. Thx for sharing your work

P_D_ Foerster
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.
September 1, 2020

This is great, thank you! :)

Like Davin Studer likes this
Randal July 20, 2022

8 years strong! Thanks this helps a lot, no more fussing with merging, un merging copy pasting.

Thank you

Carla W_ March 3, 2023

Still works great 9 years later :D 

Thanks so much for this!

Like RL likes this
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

1 vote
Nar Kumar C_ - Narva Software
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 20, 2020

Bookmarklet that Davin shared is very nice. Alternatively, If you prefer easier to use interface and want to have table export feature available to all Confluence users, we have released a free add-on: Table Exporter for Confluence

It can export Confluence tables to two formats:

- CSV

- Microsoft Excel (xlsx)

Please give it a try https://marketplace.atlassian.com/apps/1222158 and let us know if you face any issue.

1 vote
Peter Van de Voorde
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 26, 2014

Hi Christoph,

This isn't possible, but you could do the opposite : attach and excell file to the page and use the Microsoft Excel macro to embed it. It will also provide you with a link to edit the embedded document in Excel.

More information can be found here :

https://confluence.atlassian.com/display/DOC/Working+with+the+Office+Connector

Best regards,

Peter

0 votes
AnukrityJain
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!
May 7, 2019

Hi, 

Thanks! This works well.

One issue I am facing is it gets the entire data from a cell without any formatting. If the text in a cell in a multi line text, it removes all the line breaks

 

Is it possible to retain the format of the data?

Davin Studer
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.
May 8, 2019

I just made an update to the bookmarklet that attempts to keep the formatting as best it can.

0 votes
Judy Katz June 7, 2017

Is the site still down? Can't access it this evening, either to get Davin's bookmarklet...

Judy

Matthew Day July 12, 2018

2018 Jul 09 - This was working for me through April and May, but it isn't working now and hasn't been for a few weeks. Was the only thing that seemed to work easily. 
Seriously Atlassian, this inability to export to CSV is egregious. 

Davin Studer
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.
July 17, 2018

Unfortunately, my blog died and I had to rebuild it from backup. It is back up again.

Matthew Day July 18, 2018

Don't know how you do it, but it's simply fantastic! Thanks!!

Samriddhi Pendhari January 4, 2019

Hey,

Not able to access the page for the utility, is it still valid?

Thanks

len sheppard October 1, 2020

Thanks - this worked awesomely a few weeks ago!  I just tried it again and got a 502 Bad Gateway error.  Can you confirm the page is up?

 

Thanks!

Davin Studer
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

The site is back up.

0 votes
Andrey Khaneev _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.
June 6, 2017

If you have Table Filter and Charts add-on, then you can export tables to CSV with Table Filter macro.

Judy Katz June 7, 2017

I understand that you need Admin rights to install add-ons, right? I do not and don"t know who does...

 

Andrey Khaneev _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.
June 7, 2017

Yes, you need admin rights to install add-ons. So you have to find that person in order to install add-ons.

0 votes
Judy Katz June 6, 2017

Thank YOU! Glad to hear it is a temporary situation...

 

0 votes
Judy Katz June 6, 2017

Davin's link appears to be broken; I get 502 Bad Gateway regardless of browser. Is there any place else it can be downloaded? I used it before and really liked it...

Davin Studer
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.
June 6, 2017

Hmm. My site is down. I'll have it back up shortly. Thanks.

Judy Katz June 7, 2017

Is your site still down? Can't access it this evening, either...

Judy

Davin Studer
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.
June 9, 2017

It's back now. Sorry it took me so long. Had to rebuild it from backup.

Judy Katz June 9, 2017

Got it...thanks very much!

0 votes
Sokratis Metallidis
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!
December 5, 2014

I actually solved my problem by using custom jquery code... im just selecting the table that is available to the dom and exporting it! used this for it https://github.com/kayalshri/tableExport.jquery.plugin smile

0 votes
Adrien Ragot 2
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.
December 5, 2014

I knew customers who had to synchronize data between Confluence and Excel, and the answer is: Don't.

I've built the add-on Play SQL Spreadsheets for Confluence for that purpose. You can filter, edit, link data in Confluence and make reporting across several pages. I've marketed it as enterprise spreadsheets for Confluence. Hope it helps someone.

0 votes
Sokratis Metallidis
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!
November 25, 2014

@David Stunder

Booklet is cool but it exports the hole table and not the search output of a table.

 

0 votes
william mat
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!
August 29, 2014

@Christoph richter

I am using confluence table export plugin to export data to excel spreadsheets and it works fine. I think this plugin will solve your problem.

https://marketplace.atlassian.com/plugins/com.northern.lights.table.export.table-export

Arutkavi Gunasekaran July 6, 2017

Hi @William,

The link provide by you is not opening. Can you update it to me. I have facing this issue. So it will better ig you add it here. Thanks

Sandeep Anand October 24, 2017

exactly the link is not working.

0 votes
Christoph Richter June 1, 2014

I generade some tables with data from databases using the Bob Swift Software - SQL Plugin. Now some users need to download this data within an excel file. So I am afraid Conflunece is not the right tool for our business :-(

0 votes
Fringe Technology May 26, 2014

I usually just export to Word, then in word, do selct tabel/copy table, then go paste the table into a blank excel file.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events