Overview

This page demonstrates how to use the Table Plus macro, which is part of the Advanced Tables for Confluence app, to provide view users an option to downloading or exporting download or export (as an attachment) a CSV representation of the table view. By specifying the Allow download and export parameter on the macro, users are given 2 two icons (Image Added) that can be clicked to download or export the current table view to a CSV file. Download places the file on the user local system and export creates an attachment. 

...

...

Though, a comma (,) is used as a delimiter for the table contents by default, you can specify a different character in Export file delimiter. Enter any single character to act as a delimiter in the text box. For this example, let's use the default delimiter to download the current table view.

Macro browser input

Select this macro

Parameters/values

...

Column settings > Formatting > Column type (1

2

3)

...

S

E

I

...

Column settings > Numbering & Totaling > Insert auto number column

...

On

...

Column settings > Numbering & Totaling > Auto total numeric columns

...

On

...

Column settings > Sorting > Automatically sort in descending order

...

On

...

Column settings > Sorting > Automatically sort by this column

...

3

Screenshot

Image RemovedImage Removed

...

Define these parameters/values

Parameters set in the macro editor

Image Added

Image Added

Wiki markup input (Old editor)

{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 file

The attachment  exported attachment, Product Revenue.csv exported above, can  can be imported back to a Confluence page using the CSV Table Macro(Comma Separated Values) macro. This could be used for showing snapshots of tables that have been archived for a historical view. The following is like CSV Table macro with the exported CSV file is added to a CSV (Comma Separated Values) macro as an attachment on this page:

As

...

text

"","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"

...

As-is

...

With a few parameters to make it look more like the original

The following parameters were used in the CSV Table macro shown above(Comma Separated Values) macro:

Select this macro

Define these parameters/values

...

Product

I

S

E

CSV Table settings > Data settings > Output format	wiki
Row settings > Header & footer rows > Number of header rows	1
CSV Table settings > Data format > Augments to data row values	, , !%3%!
CSV Table settings > Data format > Augments to footing row values	, , Total
CSV Table settings > Data source > Method of locating JSON data (Attachment) > Attachment	Location of CSV data	^Product Revenue.csv
Column settings > Formatting > Column type (1 2 3 4)	types	I,S,E,C

Other examples

Visit our full list of product examples for additional inspiration!