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

Overview

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

Let’s assume there is a CSV data, located at some URL. To display the CSV data from this URL 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

Step-by-Step Instructions

  1. Create an empty Confluence page

  2. Edit the page

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

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

  5. In the Edit macro enter the CSV URL into the “CSV URL” parameter field.

  6. Set other parameters as you desire (refer to https://v-and-b.atlassian.net/wiki/spaces/PD/pages/995557384)

  7. Save the macro.

  8. Save the page.

  9. When the page loads it will have the table, built from the CSV data, downloaded from the URL.