How to Display a CSV File from Attachments as a Confluence Table

Overview

This howto provides step-by-step instructions on how to display a CSV file from a page attachments as a table on a Confluence page.

Let’s assume you a Confluence page with an attached CSV file. To display the CSV file as a table on a Confluence page, follow the steps below.

Prerequisites

  1. Confluence (Server)

  2. SQL-Powered Table Transformer macro for Confluence installed

  3. Documentation: https://v-and-b.atlassian.net/wiki/spaces/PD/pages/995557384/Table+from+CSV+URL+Macro

Step-by-Step Instructions

  1. Create an empty Confluence page

  2. Attach a CSV file to the newly created Confluence page (let’s assume the file name is test.csv).

  3. Edit the page

  4. Include “Table from CSV URL“ user macro into the page

  5. Click the macro container and select “Edit” (Edit macro dialog will appear)

  6. In the Edit macro set the CSV URL parameter as follows: “:^test.csv” (without quotes). Note, that the format of this fields allows referring to attachments of not only the current page, but any other pages in your Confluence instance (full format is <space>:<page title>^<attachment>#<version>. By default the current version of the attachment will be used, however, you can instruct to use the specific version of the attachment. For example, if you need version 7 of the file, append #7 to the CSV URL.

  7. Set other parameters as you desire (refer to https://v-and-b.atlassian.net/wiki/spaces/PD/pages/995557384/Table+from+CSV+URL+Macro)

  8. Save the macro.

  9. Save the page.

  10. When the page loads it will have the table, built from your attachment CSV file.