Transforming Confluence Tables: Adding Columns with Ease
In the dynamic world of project management and collaboration, Confluence serves as a powerful tool for teams to share information and collaborate effectively. One of its standout features is the ability to create and manipulate tables, making data organization a breeze. Today, we're going to delve into a common task: adding columns to Confluence tables, using the Table Transformer macro.
Understanding the Table Transformer Macro
The Table Transformer macro is a versatile tool that allows you to manipulate tables in Confluence, making it easy to add, remove, or rearrange columns and rows. It's particularly useful when you need to adjust your table's structure to accommodate new information or changing requirements.
Why Use the Table Transformer Macro?
- Ease of use: The macro provides a user-friendly interface for adding columns without requiring knowledge of HTML or other coding languages.
- Flexibility: It allows you to add columns at any position within the table, making it easy to insert new data points without disrupting existing content.
- Time-saving: By streamlining the process of adding columns, the Table Transformer macro helps you maintain your tables more efficiently.
Adding Columns with the Table Transformer Macro
Now that we've established the benefits of using the Table Transformer macro, let's dive into the step-by-step process of adding columns to your Confluence tables.

Step 1: Access the Table Transformer Macro
To get started, you'll need to access the Table Transformer macro. You can do this by clicking on the '+' icon in the editor toolbar, then selecting 'More' to view the full list of macros. From there, find and select the 'Table Transformer' macro.
Step 2: Select Your Table
Once you've added the macro, you'll see a list of tables in your page. Select the table you want to modify by clicking on the checkbox next to it. You can also use the search bar to filter the list if you have many tables on the page.
Step 3: Add a New Column
After selecting your table, click on the 'Add column' button. This will open a dialog box where you can specify the details of your new column.

Step 4: Configure Your New Column
In the dialog box, you can configure several aspects of your new column:
- Position: Choose where to insert the new column within the table. You can select 'Before' or 'After' an existing column, or choose 'First' or 'Last' to add the column to the edge of the table.
- Header: Enter a header for your new column. This will appear at the top of the column and serve as a label for the data it contains.
- Default value: If desired, you can set a default value for the new column. This value will be automatically inserted into each cell in the column when you add it to the table.
Step 5: Confirm and Save
Once you've configured your new column, click 'OK' to add it to your table. You'll see the new column appear in the table preview, and you can make any necessary adjustments to the column's width or other settings. When you're satisfied with the result, click 'Insert' to save your changes and close the macro.
Best Practices for Using the Table Transformer Macro
While the Table Transformer macro is a powerful tool, it's essential to use it judiciously to maintain the organization and readability of your Confluence tables. Here are some best practices to keep in mind:
- Plan ahead: Before adding columns, consider the structure of your table and how new columns will fit into that structure. This will help you avoid disrupting the table's layout and ensure that new data is easily understandable.
- Use descriptive headers: Clear and descriptive headers help users understand the purpose of each column and make it easier to find specific data within the table.
- Keep it consistent: Maintain a consistent structure across similar tables to promote clarity and ease of use. This helps users understand the layout of each table and quickly find the information they need.
Conclusion
Adding columns to Confluence tables using the Table Transformer macro is a straightforward process that empowers you to adapt your tables to changing needs. By following the steps outlined above and keeping best practices in mind, you can harness the full potential of this powerful macro to create and maintain organized, user-friendly tables that support your team's collaboration efforts.
More Details
28.01.2024 ... Confluence · Questions; Table Transformer - how to add column of values based off two other columns values. Table Transformer - how to add ...

Add Table Transformer on the page Link to Add Table Transformer on the page · Step 1. Wrap tables or table macros with Table Transformer in the edit mode: · Step ...

28.03.2019 ... The Table Transformer macro is included in the bundle of useful macros for tables processing of the Table Filter and Charts for Confluence ...
25.02.2022 ... Adding values of column of 2 tables by using another common column as key in sql in table transformer macro in Atlassian confluence ; katie, 23.

SQL-Powered Table Transformer - a tool to transform/convert/analyze Confluence tables using SQL. ... You can: filter; transform; add/hide/rename columns; replace/ ...

Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body. Select the macro and click Edit. In the Presets ...
06.09.2023 ... Filters can also be created for tables in Confluence. You can select different columns as filter values and the table only displays the ...

The Table Transformer macro supports Confluence Wiki Markup (the FORMATWIKI function ) and Markdown syntax (the FORMATMARKDOWN function) for the purposes of ...

26.10.2023 ... 0:00 Structure your Table 1:15 Contextualize your Table with Native Macros 1:56 Turn your Tables into Graphs 2:33 Leverage Native Report ...

{"serverDuration": 26, "requestCorrelationId": "7fb17715fcf0437e858e007aca1ed3fa"}

Added 11/25/20 4:45 PM. This as well as table column widths is what stops confluence adoption organization wide dead in its tracks. Very simple, anywhere ...

18.11.2022 ... Put three Jira macros on a Confluence page to fetch the relevant tables of A, B, and C data. Then wrap it in a table transformer macro, where I can (ala)SQL ...

10.02.2026 ... You can add new rows or columns with a click, and adjust column widths using the simple drag handle that appears when you hover cells. These ...

27.03.2026 ... ... Confluence. Today we're diving into the Table Transformer macro (your data cleanup and SQL wizard) and the Table Spreadsheet macro (your ...

... Transformer models of varying sizes. To ensure user comprehension ... We presented the results of this phase in four tables, including Table 10 and Fig.
10.05.2021 ... ... columns to depict and the number of issues in the table. Keep in mind ... Apply the Table Transformer macro to your tables and merge them.

Add quick sparkline graphs to monitor the trend line. Add the Total column or calculate ... Table Transformer or Table Filter caused table data to shift and break ...

feat: add GitHub Alerts transformer and renderers. 2 months ago. mermaid ... Insert Table of Contents. . If default TOC looks don't ...

Enhanced tables: Add programmable controls to selected tables; Enhancing ... Simple Columns: Create and manage columns in your notes effortlessly ...

25.02.2022 ... Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body. Select the macro and click Edit.
