On this page
Overview
This page demonstrates how to use the Table Plus macro, which is part of the Advanced Tables for Confluence add-on, to provide view users an option to downloading or exporting (as an attachment) a CSV representation of the table view. By specifying the Allow export parameter on the macro, users will be given 2 icons that can be clicked to download or export the current table view to a CSV file. Download will place the file on the user local system. Export will create an attachment.
Available with version 7.2.0 on Server only
See Release notes 7.2.
Screenshot
Message
Macro Browser Input
Select this Macro
Macro Name | Table Plus |
Macro Syntax | {table-plus} |
Define these Parameters/Values
Allow export | selected |
Table id | Product Revenue |
Auto number on each row | selected |
Auto total row | selected |
Sort descending | selected |
Auto sort column | 3 |
Column types | S,E,I |
Screenshot
Wiki Markup Input
{table-plus:allowExport=true|id=Product Revenue|autoNumber=true|autoTotal=true|sortDescending=true|sortColumn=3|columnTypes=S,E,FF"$0,0"}
|| Product || On Plan || Revenue ||
| A | (/) | 325100 |
| D | (/) | 315850 |
| C | (x) | 250420 |
| B | (/) | 98650 |
| E | (x) | 79010 |
{table-plus}Exported CSV
The attachment Product Revenue.csv exported above, can be imported back to a Confluence page using the CSV Macro. This could be used for showing snapshots of tables that have been archived for a historical view. The following is like CSV macros with the attachment on this page.
As Text
Product Revenue.csv
"","Product","On Plan","Revenue"
"1","A","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/check.png","$325,100"
"2","D","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/check.png","$315,850"
"3","C","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/error.png","$250,420"
"4","B","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/check.png","$98,650"
"5","E","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/error.png","$79,010"
"","","","$1,069,030"
With CSV Macro As Is
With CSV Macro With A Few Parameters To Make It Look More Like the Original
The following parameters were used in the CSV macro shown above:
Select this Macro
Macro Name | CSV |
Macro Syntax | {csv} |
Define these Parameters/Values
Output format | wiki |
|---|---|
Footing rows | 1 |
Augments to data row values | , , !%3%! |
Augments to footing row values | , , Total |
Location of data | ^Product Revenue.csv |
Column types | I,S,E,C |
Other Examples
Visit our full list of product examples for additional inspiration!