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!
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!
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 Â
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:
Filtering on the go:
Exporting of the filtered table:
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 :
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:
- Microsoft Excel (xlsx)
Please give it a try https://marketplace.atlassian.com/apps/1222158 and let us know if you face any issue.
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 :smile:
- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...
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