SQL-Powered Table Transformer

This plug-in turns your simple Confluence table into a database and even more. In my practice of a systems analyst, I often have to prepare a variety of documents focusing on different aspects of same information, such as high-level overviews, or detailed specifications for client and BE development teams, or external documentation providing details on what is exposed by the system for 3rd party applications. It usually requires displaying of same data on multiple Confluence pages in a slightly different forms for several teams and tasks, or to show just a subset of data. So, I used to copy and edit those data manually in all my documents. But fortunately, this plug-in solved my problem! With simple Confluence tables or CSV attachments as a data source, I have created multiple views for various purposes using basic SQL capabilities, such as filtering and joining. The plug-in allows you to re-use a single data source across multiple Confluence pages. Modifying data source automatically updates data on all derived pages, no more “copy-and-paste”. You can filter your data, select columns you only want on a certain page, or even use SQL aggregation, string, logical functions, and many others. I have not found any limitations of supported SQL syntax. In addition, the plug-in provides a number of features to improve visual presentation of the data. You can choose output format (table, csv, json, ...) or transpose your table. And my favorite is auto-merging of cells within rows or columns, which creates nice looking tables convenient for analysis. Merged cells in the data source are also supported and treated as they have the same value. Using this plug-in, I was able to organize automatically updated and synchronized documentation for several teams to save time that would be spent for manual updates and to reduce the risk of error.

• 

  George Ivanov

  Ksenia, thank you for the detailed feedback

I have tried this plugin on our corporate Confluence and have found that it solves the fundamental problem with exporting tables from Confluence to Calc or Excel using CSV. Also, this plugin gives a lot of new capabilities to create dashboards directly in the Confluence.