Click-able URLs in Excel (Table Export)?

Options
Jozef_783863
Jozef_783863 Posts: 331 admin
edited February 2020 in Questions
  1. My data table contains a URLs in a column.
  2. I exported the data table to Excel and attempted to click one of the URLs in the URL column.
  3. The URL is not displayed as a blue hyperlink, so clicking the URL does not open the link.

Is there any way to make the URL cell click-able? Based on the Idea below, this appears to be expected behavior.

Create a Word Document - Support inserting URLs as hyperlinks
https://community.pushbot.com/discussion/698

Best Answer

  • Dylan_191182
    Dylan_191182 Posts: 92 admin
    Answer ✓
    Options

    This is currently expected behavior. We export data using the column type of the data table, in this case Text.
    You could do this by using the Excel: Insert data table action and having the template contain a column that uses the Excel =HYPERLINK function to display a hyperlink based on the column from the data table.