Export table in a confluence page to excel?

[Christoph Richter]

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

[Davin Studer · Accepted solution]

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

[Jean-Pierre Chiri]

This work like a charm :! Great code !

[Davin Studer]

Glad it helped. :)

[Daniel Roberts]

This is absolutely beautiful.

[Claire Townend]

Very helpful, thanks!

[Rachel Hyde]

This is great. Thank you for sharing it!

[Raghu WR]

Brilliant,saved hours of manual work. Thanks so much.

[boardtc]

Superb

[Kate Hanna]

That is fantastic. Thanks very much!

[Ross Davis]

Well done! Exactly what we needed.

[Andrew Barakat]

This is heroic.

[Edgard Sulyma]

You sir, are a genius!

[JackChivers]

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

[Adrian Maftei]

 The link provided in the mentioned URL is broken.

[RiFa]

The link is broken indeed :-(

[Davin Studer]

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!

[Deleted user]

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

[Gezim Shehu [Communardo]]

Wonderful :)

[Pallvi Pathania]

This is brilliant! Thank you :)

[Nancy Stronczek]

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]

Lovely! Glad it helped!

[Anand Verma]

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

[Anand Verma]

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

[Tom Harris - Old Street]

Thanks David! This is really useful :)

[Davin Studer]

@Tom Harris - Old Street You're welcome. Glad it is useful.

[Chaitanya]

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  

[Robin Zhang]

it works when i  use chrome of currently version .thanks !

[Artem Pozdnyakov]

Genius! Thanks a lot!

[Agnieszka Kornas]

As perfect as CSV can be with polish letters and links to jira;) 
Awesome. Thx for sharing your work

[P_D_ Foerster]

This is great, thank you! :)

[Randal]

8 years strong! Thanks this helps a lot, no more fussing with merging, un merging copy pasting.

Thank you

[Carla W_]

Still works great 9 years later :D 

Thanks so much for this!

[Katerina Kovriga _Stiltsoft_]

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:

[Nar Kumar C_ - Narva Apps]

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.

[Peter Van de Voorde]

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

[Anukrity Jain]

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]

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

[Judy Katz]

Is the site still down? Can't access it this evening, either to get Davin's bookmarklet...

Judy

[Matthew Day]

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]

Unfortunately, my blog died and I had to rebuild it from backup. It is back up again.

[Matthew Day]

Don't know how you do it, but it's simply fantastic! Thanks!!

[Samriddhi Pendhari]

Hey,

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

Thanks

[len sheppard]

Thanks - this worked awesomely a few weeks ago!  I just tried it again and got a 502 Bad Gateway error.  Can you confirm the page is up?

Thanks!

[Davin Studer]

The site is back up.

[Andrey Khaneev _StiltSoft_]

If you have Table Filter and Charts add-on, then you can export tables to CSV with Table Filter macro.

[Judy Katz]

I understand that you need Admin rights to install add-ons, right? I do not and don"t know who does...

[Andrey Khaneev _StiltSoft_]

Yes, you need admin rights to install add-ons. So you have to find that person in order to install add-ons.

[Judy Katz]

Thank YOU! Glad to hear it is a temporary situation...

[Judy Katz]

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]

Hmm. My site is down. I'll have it back up shortly. Thanks.

[Judy Katz]

Is your site still down? Can't access it this evening, either...

Judy

[Davin Studer]

It's back now. Sorry it took me so long. Had to rebuild it from backup.

[Judy Katz]

Got it...thanks very much!

[Sokratis Metallidis]

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 

[Adrien Ragot 2]

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.

[Sokratis Metallidis]

@David Stunder

Booklet is cool but it exports the hole table and not the search output of a table.

 

[william mat]

@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

[Arutkavi Gunasekaran]

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

[Sandeep Anand]

exactly the link is not working.

[Christoph Richter]

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 :-(

[Fringe Technology]

I usually just export to Word, then in word, do selct tabel/copy table, then go paste the table into a blank excel file.