Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

  1. 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:
    Image Added
  2. Log in to the Confluence.
  3. Insert the Table Plus macro of Advanced Tables.
  4. Insert the table and enter the data.
    Image Removed
  5. Edit the Table Plus macro:
    Image Removed
  6. 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:
    Image Removed
    Screenshot# 2:
    Image Removed
    Screenshot# 3:
    Image Removed
  7. Once the page is published, it can be observed that the columns for which the formatting was applied are hidden:
    Image RemovedConfluence, and go to an existing page or create a new page. 
    1. If the page already exists, attach the CSV file to the page.
    2. If a new page is created, create a sample page and publish it before attaching the CSV file to the page.
  8. Edit the page and insert the CSV Table macro from the Advanced Tables for Confluence app.
    Image Added

  9. Edit the CSV macro, go to CSV settings > Data source and provide the details as shown:
    Image Added
  10. Edit the CSV macro, go to Data format, and provide the value [%URL%] in the Augments to data row values field.
    Image Added
  11. Go to Data settings, select Output format as wiki, and click Save settings.
    Image Added
  12. 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:
Image Added