Skip to content

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.

  1. On a page, type / and choose Markdown & CSV Table.
  2. Paste your text in Markdown table or CSV. The preview updates as you type.
  3. 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.

Start a cell with =. Use cell addresses such as B2. The top-left cell is A1, including the header row.

ItemQtyPriceAmount
Apple31.20=B2*C2
Pear20.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.

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.

  • 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.

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.

  • 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.