This article explains how to convert URL texts text as links using the using CSV Table macro in in the Advanced Tables for Confluence app.
Instructions
- Prepare a CSV file with URLs. The URL is shown as links in the CSV file, though, it is not converted as links on the Confluence page. In this example, the following CSV file is used:
- Log in to the Confluence.
- Insert the Table Plus macro of Advanced Tables.
- Insert the table and enter the data.
- Edit the Table Plus macro:
- On the Advanced Tables Editor > Column settings > Start formatting and give Column type as Hide the Column (H) from the drop-down and Save settings as mentioned in the below screenshots:
Screenshot# 1:
Screenshot# 2:
Screenshot# 3: - Once the page is published, it can be observed that the columns for which the formatting was applied are hidden:
Confluence, and go to an existing page or create a new page.- If the page already exists, attach the CSV file to the page.
- If a new page is created, create a sample page and publish it before attaching the CSV file to the page.
- If the page already exists, attach the CSV file to the page.
- Edit the page and insert the CSV Table macro from the Advanced Tables for Confluence app.
- Edit the CSV macro, go to CSV settings > Data source and provide the details as shown:
- Edit the CSV macro, go to Data format, and provide the value [%URL%] in the Augments to data row values field.
- Go to Data settings, select Output format as wiki, and click Save settings.
- Publish the Confluence page.
The URL from the CSV file is converted and displayed in a URL format. The URLs in the CSV file used in this example is converted to links as shown: