I created a bookmarklet for this purpose. You can get it at the URL below. Just drag the link to your bookmarks bar and then click it. It will create a link above each table to allow you to download that table as a CSV. One caveat is that it won't work in IE as IE won't allow data uri's for anything other than images ... haven't tried it on Microsoft Edge yet.
http://iamdav.in/2014/10/24/bookmarklet-creating-csv-html-table/
Update
09/16/2016 - Works with IE 10+ now
I don't know of an easy way. There are two ways that do work though.
The first one saves a step, but it can be VERY tricky to select all the text in a Confluence table.
You should try both methods as the resulting text style is different.
Okay, now that's brilliantly easy!
Thank you Davin, this works great! I second Milo's comment! Brilliant!
Thank you Davin, nice and easy. Great work!
Thank you so very much! This works perfectly. You just saved me a lot of time for now and the future. You're great!
This is no longer working. I know it's an older thread but any chance of an update?
Which answer is no longer working for you?
i tried it again and now it's working. obviously user error. thanks for responding.
Great work on the bookmarklet; 1 quirk, whenever I download tables, it's not downloading them using the custom TableExport.csv, it downloads always using the same "download" filename.
EDIT: added target="_blank" and now it's downloading with the correct filename
Bookmarklet that Davin shared above is very nice. If you 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.
Alternative solution for those who use the Table Filter and Charts app: all bundled macros can export tables to CSV.
True, but only if the filter panel is made visible and the panel control buttons are made visible, whereas the commandlet is universal to all HTML tables.
The CSV export capability from the Stiltsoft macros does have some nice CSV formatting options though.
Comment for method #1 - it works better if you can edit the page.
When viewing the page, you cannot select the header line since all column headers are clickable links used to sort by that column.
If you edit the page, you can select all rows.
It looks like you're new here. Sign in or register to get started.
