Overview
Markdown & CSV Table Calculator shows pasted Markdown, CSV or TSV text as a table on a Confluence page, with formulas, a total row, sorting and number formats.
Add a table
Section titled “Add a table”- On a page, type
/and choose Markdown & CSV Table. - Paste your text in Markdown table or CSV. The preview updates as you type.
- Choose options (see below) and select Save.
Supported input: Markdown tables, CSV (comma), TSV (tab) and semicolon-separated text. Format detects the type automatically; you can also choose it. Quoted CSV values such as "Tokyo, JP" are kept as one cell. Turn off First row is a header if your data has no header.
Formulas
Section titled “Formulas”Start a cell with =. Use cell addresses such as B2. The top-left cell is A1, including the header row.
| Item | Qty | Price | Amount |
|---|---|---|---|
| Apple | 3 | 1.20 | =B2*C2 |
| Pear | 2 | 0.50 | =B3*C3 |
Common spreadsheet functions work, for example SUM, AVERAGE, ROUND and IF. In CSV, a formula with commas such as =ROUND(A2,1) does not need quotes.
Cell addresses always use the row numbers of the pasted text, before sorting. Sorting only changes the display order.
Total row
Section titled “Total row”Under Totals row, choose SUM, AVERAGE, COUNT, MIN or MAX for each column. The row is labelled Total.
Choose a column in Sort by and an Order. Empty cells and errors go last.
Number formats
Section titled “Number formats”- Default number format (for example
#,##0.00) applies to formulas and totals, or to all numbers if you choose All numbers. - Column formats apply to every number in that column, including its total, and override the default. Examples:
#,##0,0.0%,0.0"%"(a literal %, no ×100),¥#,##0. - COUNT totals are never formatted as percent or currency.
Update the table
Section titled “Update the table”Open the macro settings, paste the new version and select Save. The table and total row update. If the columns change, check the total type and column formats again.
Limits
Section titled “Limits”- 500 rows, 30 columns and 200,000 characters per macro.
- Cells cannot be edited on the page; edit the source text.
- No file upload or external data source.