You are viewing limited content. For full access, please sign in.

Question

Question

HTML Hyperlink Token to CSV file

asked on May 19, 2023

I'm writing a report that has a list of form links.  Is there a way to apply hyperlink coding to the link so its not in its native form and is clickable from the csv file?

0 0

Answer

SELECTED ANSWER
replied on May 19, 2023 Show version history

First, it should be noted that the CSV format does not natively support hyperlinks because it is a simple flat text file that uses comma delimiters hence "comma-separated values" (CSV).

That being said, if you are using the CSV file in a program that supports OpenFormula like Excel or Google Sheets, then you could try the HYPERLINK function.

=HYPERLINK("url.com")

The limitation is that this is basically a "hack" because csv doesn't support this but Excel and such will make sense of it when you open the file.

However, it is worth noting that this may or may not provide the stylized look of a clickable link even if it does make it clickable since CSV is far more limited than an xlsx file.

Additionally, if you save changes in a program like Excel, the link will be lost since CSV does not have native support for the functionality.

2 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.