Forum Discussion
export a hyperlink in a csv file
I am trying to create a csv file to import into a website I am building, I need the csv to include a cell which includes a hyperlinked word in html format.
I have a column which contains urls a...
Hi there
I have attached something similar to what you have asked (assuming I understand you right).
CSV files don't do hyperlinks as it's text based, so all cells are whatever you make them.
See if this is helpful?
Cheers
Damien
Thanks for your response, I think you've understand what I'm trying to achieve.
So if I have cells like A3 on your example and save them as a csv they would be saved as text?
The other part that I'm still struggling with and I'm not sure I've explained is how I create your A3 from A2, I've tried <a href="$A2">Preview</a> and various derivatives, but without success