How to encode a hyperlink in CSV formatted file?

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

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