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.
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!
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?
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!
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 :
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 :-(
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.
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
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.
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?
I attended Atlassian Summit 2019 and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...
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