Overview
The Advanced Table Viewer macro allows you to import, format, and display data from various data sources in a table format using predefined profiles.
...
Future releases will support additional data sources, such as JSON and Excel. (need inputs on what other data sources will be supported)
The macro will support more advanced options to interact with your data, such as text filtering, searching in the table, exporting, and more.
...
Select from the macro browser | Advanced Table Viewer   |
|---|---|
Markup shortcut (Old editor) | {Advanced Table Viewer}To be done |
Markup shortcut (New editor) | /Advanced Table Viewer   |
Configure the macro
Insert the macro and select the data connector. By default, CSV is selected.
...
The Select a Profile drop-down macro displays the list of profiles. Select the profile from which you want to import the data as a Confluence table.
...
The Select Columns drop-down displays the list of column names to output in the table.
...
You can select, remove, and arrange order the column names as needed. The selected order of the column names is displayed in the confluence table.
To clear all the selected column names, click Clear All (
)in the drop-down. 
To remove any specific column name from the list, next to the column name, click
.After clearing selections, to select the column names again, click the drop-down and select the column names again in the required order.
Click Insert to import the data. The table with the selected column names and values will appear on the Confluence page.
...
With these simple steps, your data is now ready for collaborative use and enhanced analysis directly within Confluence.
Formatting
...
options
The Advanced Table Viewer macro offers quick formatting options when viewing tables on the Confluence page. You can work with the data and create customizable views.
...
Sorting: Sort table data by clicking on column headers to switch between ascending and descending order. For more information, refer to Sorting with Advanced Table Viewer macro.
Sum-up row: Automatically calculate and display the total sum (SUM) or average (AVG) for columns containing only numeric data. For more information, refer to Summarize numeric column values with Advanced Table Viewer macro.