Overview
The Advanced Table Viewer BETA macro enables you to import, format, and display data from various data sources in a table format using predefined profiles.
Beta release notice: The Advanced Table Viewer BETA macro is currently in its beta version.
While we strive to deliver a seamless experience, some features are subject to change, and minor issues can arise. We encourage you to explore the macro and share your feedback to help us improve the final release. Thank you for your support and understanding!
What’s in the beta release?
The macro currently supports importing data only from the CSV data connector.
We have included a simplified version of the two formatting features, Sorting and Sum-up.
Beta limitations:
The Sum-up option in beta provides only sum and average calculation and is applicable only for columns with numeric data.
Pre-requisite: Profiles and configuration
✅ The Advanced Table Viewer macro imports data from data sources using profiles. It currently supports the CSV data connector.
✅ Make sure you have access to the required profiles, or contact your Administrator to define them. To configure profiles, refer to Configuration-Cloud.
Macro basic use
Insert the macro
You can add the macro to a Confluence page using one of the following methods:
Select from the macro browser | Advanced Table Viewer  |
|---|---|
Macro shortcut (New editor) | /Advanced Table Viewer  |
Configure the macro
Insert the macro and select the data connector. By default, CSV is selected.
To learn more about the Advanced Table Viewer macro, click Help.
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 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, click the drop-down and select the column names again in the required order.
Click Save 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.
When you save the macro on a Confluence page without configuration, it displays a welcome note.
Macro features
The Advanced Table Viewer BETA macro offers quick formatting options when viewing tables on the Confluence page. You can work with the data and create customizable views.
The Beta release offers a simplified version of the Sorting and Sum-up features:
Sorting: Sort the 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 [Beta].
Sum-up: Include the summarize option to automatically calculate and display the 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 [Beta].
