- last edited on
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 and I need to create another column which includes the html. So cell A2 contains https://example.com. I want cell A3 to contain <a href="https://example.com">Preview</a>
I am a bit lost, any help is appreciated
03-01-2018 02:13 PM
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?
03-01-2018 03:00 PM
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
03-01-2018 08:19 PM
I've made this Excel file for you that will take the URL and your description and turn it into <a href>.
You can populate the spreadsheet to produce your desired tags, then save the file as CSV which will convert your entries to text.
Let me know how it goes?