Export table in a confluence page to excel?

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

12 answers

13 votes
Davin Studer Community Champion Oct 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

This work like a charm :! Great code !

Davin Studer Community Champion Nov 17, 2015

Glad it helped. :)

This is absolutely beautiful.

Very helpful, thanks!

This is great. Thank you for sharing it!

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

That is fantastic. Thanks very much!

Well done! Exactly what we needed.

This is heroic.

You sir, are a genius!

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

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

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 :-(

@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

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

exactly the link is not working.

@David Stunder

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

 

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.

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

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 Community Champion Jun 06, 2017

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

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

Judy

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

Got it...thanks very much!

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

 

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

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

 

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

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

Judy

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 Community Champion Jul 17, 2018

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

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Oct 09, 2018 in Confluence

Introducing Praecipio Consulting, an Atlassian Solution Partner

Hey there Community!  My name is Vannya Vallejo, the Channel Communication Specialist at Atlassian and I want to help Atlassian users like you learn about our Solution Partners and how they c...

373 views 0 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you