nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to create a table with calculation formulas?

Sereima Kavetani

Hi Team,

I have a table created in excel, which contains calculation on rows/ columns (simple calculation like adding/multiplying/ dividing numbers). I want to create the same table in Confluence. So including the calculations/formulas so that the table is updated if the numbers change. I have looked at Macros ->other Macros but this table doesn't allow me to calculate. It would be perfect if I could import the excel table into Confluence and the calculations would remain. Is this (or something similar) possible in Confluence? If so, how to do it? Appreciate if someone can please assist me with this.

Thanks

Accepted answers

All comments

Mohamed Adel

Hi @Sereima Kavetani ,

it is not out of the box macro in confluence , i recommend for you to take a look at this plugin qron-calc-macro-excel-formula-in-table

Luiz Gregorio

Indeed, Confluence does not have this feature out of the box, you must rely on plugins for that.

As mentioned by @Mohamed Adel Qron plugin is very good on that job.

Sereima Kavetani

Thank you @Mohamed Adel

Sereima Kavetani

Thanks. The only problem is that it has to be paid:) and am working in an organization so will need approvals and etc.

Katerina Kovriga {Stiltsoft}

Hi @Sereima Kavetani ,

as it was mentioned before, there is no such feature in Confluence out-of-the box, so you'll need additional apps.

For example, you may use the Table Filter and Charts for Confluence app. Its Table Transformer macro allows you to perform a wide range of table calculations as well as conditional formatting.

Defne Alpdogan

Is there a template where I can see how Confluence takes the formulas on Excel ? My formulas from Excel do not work that is why I was wondering whether they use " ; " splitting arrays etc.

George Rozakis_d4l0w7

Are the above solutions applicable to a Confluence Database as well?

Stiltsoft support

And an update from our side: you may also use our Table Spreadsheet macro if you prefer to work with Excel-like features and cell formulas.

And if you have already created manual tables or macro generated tables (Jira Issues, Page Properties Report, etc.), you may take the Spreadsheet from Table macro.

These macros are also provided by the Table Filter, Charts & Spreadsheets for Confluence app that we develop.

James Kirion

Just like a VAT Cal instantly updates tax amounts when values change, you need a dynamic table in Confluence that auto-updates calculations. Confluence’s built-in tables don’t support formulas directly, but you can use the Table Spreadsheet Macro or embed an Excel file using the Excel Macro to retain calculations. This way, your table stays interactive and works just like a VAT Calculator—quick, accurate, and hassle-free!