Is it possible to export a table within a page to excel??
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
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
@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
This work like a charm :! Great code !
Glad it helped.
This is absolutely beautiful.
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...
Hmm. My site is down. I'll have it back up shortly. Thanks.
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 your site still down? Can't access it this evening, either...
Judy
Is the site still down? Can't access it this evening, either to get Davin's bookmarklet...
It's back now. Sorry it took me so long. Had to rebuild it from backup.
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.
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.
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!!
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?
I just made an update to the bookmarklet that attempts to keep the formatting as best it can.
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:
- CSV
- Microsoft Excel (xlsx)
Please give it a try https://marketplace.atlassian.com/apps/1222158 and let us know if you face any issue.
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:
And you may also use the Table Spreadsheet macro and work with all the Excel-like features right in Confluence.
The result table can be then imported in .csv and .xlsx formats if required.
It looks like you're new here. Sign in or register to get started.
