Can I paste a Markdown or CSV table into Confluence and add totals and formulas?
Yes. Insert the Markdown & CSV Table macro, paste a Markdown table, CSV, TSV or semicolon-separated text, and save. The macro shows a table. You can add formulas such as =B2*C2 or =SUM(B2:B5), a total row (SUM, AVERAGE, COUNT, MIN or MAX for each column), sorting and number formats. The app is free.
How do I update the table? The source text stays in the macro. Open the macro settings, paste the new version and save. The table and its total row update. If the columns change, check the total type for each column again.
Which cell is A1? The top-left cell, including the header row. With a header row, data starts in row 2.
Do formulas change when I sort? No. Cell addresses always use the row numbers of the pasted text. Sorting only changes the display order.
Does my data leave Atlassian? No. The app runs on Atlassian Forge, makes no external network calls and requests no Confluence permissions (scopes). The pasted text and settings are saved in the macro on your page. See Data and permissions.
Can I upload a CSV file or link to a spreadsheet? No. Paste the text into the macro settings.
Can people edit cells on the page? No. Edit the source text in the macro settings.
Does it appear in PDF export? Yes, as a Confluence table.
Limits: 500 rows, 30 columns and 200,000 characters per macro.
Need help? Contact our team.