How to encode a hyperlink in CSV formatted file?

csv hyperlink encode
gep picture gep · Sep 27, 2011 · Viewed 54.3k times · Source

When I try to encode a HTML anchor link in CSV file cell it becomes corrupted and not readable by Excel.

Is there some sort of non-HTML solution or format to encode a hyperlink in CSV file cell?

Answer

stuartdotnet picture stuartdotnet · May 25, 2012

For when automagicalism doesn't work, and you're definitely using Excel, use this as the field content. 

=HYPERLINK("http://stackoverflow.com")

Related questions

Can Excel interpret the URLs in my CSV as hyperlinks?

Can Excel interpret the URLs in my CSV as hyperlinks? If so, how?

Read More
How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Read More
Writing a pandas DataFrame to CSV file

I have a dataframe in pandas which I would like to write to a CSV file. I am doing this using: df.to_csv('out.csv') And getting the error: UnicodeEncodeError: 'ascii' codec can't encode character u'\u03b1' …

Read More