It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Export table in a confluence page to excel?

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

13 answers

21 votes
Davin Studer Community Leader 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 Leader 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!

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

 The link provided in the mentioned URL is broken.

The link is broken indeed :-(

Davin Studer Community Leader Jan 07, 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!

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

This is brilliant! Thank you :)

Like Davin Studer likes this

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 Community Leader Feb 15, 2019

Lovely! Glad it helped!

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

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

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 Leader 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 Leader 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!!

Hey,

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

Thanks

0 votes

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 Community Leader May 08, 2019

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

Introducing Confluence Cloud and Jira Software Cloud Premium

Wherever you are in your team’s journey , our goal is to support your big ambitions. We’re a cloud-first company with the mission of unleashing the potential of every team, and to address the range ...

590 views 4 17
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you