excelcsvhyperlink

Can Excel interpret the URLs in my CSV as hyperlinks?


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


Solution

  • You can actually do this and have Excel show a clickable link. Use this format in the CSV file:

    =HYPERLINK("URL")
    

    So the CSV would look like:

    1,23.4,=HYPERLINK("http://www.google.com")
    

    I tried to get some links with commas in them to work properly and it doesn't look like there's a way to escape them and still have Excel make the link clickable.