Hi Bob,

I can see you already solved this issue, but we will still advise just to clarify how our links are being rendered in our Tables, to avoid any future issues with them.

When we connect Spreadsheets such as CSV/Excel/ or Google Spreadsheets with our tables in the plugin,

our plugin can not read the hyperlinks directly from the source sheet, because the Spreadsheet has a different way how it is creating and rendering links, while our Plugin can only read links as HTML.

You would need to change the format of the data in the cells coming from the sheet in order for our plugin to properly render them as links.

Now, it depends if you have one link per cell, or if you have multiple links in the same cell.

1. If you have one link per cell,  perhaps the easiest way is to use our URL Columns.

They have specific rendering rules :

Rendering rules: If the content of the cells contains a combination of “two sticks” – || – everything to the left of this combination is used as an URL address for the link, and everything to the right as displayed text. For example:

https://wpdatatables.com||Check out wpDataTables

will be rendered as: Check out wpDataTables

If the “||” combination is not found in the content, the entire content will be used both for the link and as the display value. For example: https://wpdatatables.com will be rendered as: https://wpdatatables.com

2.

Alternatively, you can use String Columns.

They can render custom HTML,  in that case, you would have to wrap the links in the source data as HTML anchor tags, for example :

<a href="https://www.w3schools.com">Visit W3Schools.com!</a>

will be rendered as hyperlink of displayed text : " Visit W3Schools.com! "

 if you use String Columns, you will also be able to have multiple links in the same cell,  and combinations or images with links, etc ( if needed).

Let me know if that makes sense, and if you have any questions.

 Thanks