Can Excel interpret the URLs in my CSV as hyperlinks?

excel csv hyperlink
Lior picture Lior · Jul 3, 2011 · Viewed 44.1k times · Source

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

Answer

Dave picture Dave · Nov 6, 2011

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")

However, I'm trying 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.

Does anyone know how?

Related questions

Excel to CSV with UTF8 encoding

I have an Excel file that has some Spanish characters (tildes, etc.) that I need to convert to a CSV file to use as an import file. However, when I do Save As CSV it mangles the "special" Spanish characters …

Read More
Writing to an Excel spreadsheet

I am new to Python. I need to write some data from my program to a spreadsheet. I've searched online and there seem to be many packages available (xlwt, XlsXcessive, openpyxl). Others suggest to write to a .csv file (never …

Read More
Is it possible to force Excel recognize UTF-8 CSV files automatically?

I'm developing a part of an application that's responsible for exporting some data into CSV files. The application always uses UTF-8 because of its multilingual nature at all levels. But opening such CSV files (containing e.g. diacritics, cyrillic letters, …

Read More