Can Excel interpret the URLs in my CSV as hyperlinks?

by

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?

More Related Contents:

  1. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  2. Stop Excel from automatically converting certain text values to dates
  3. Microsoft Excel mangles Diacritics in .csv files?
  4. Excel to CSV with UTF8 encoding [closed]
  5. Excel CSV – Number cell format
  6. Generating CSV file for Excel, how to have a newline inside a value
  7. Export hashtable to CSV with the key as the column heading
  8. Save each sheet in a workbook to separate CSV files
  9. Export each sheet to a separate csv file
  10. How to correctly display .csv files within Excel 2013?
  11. Convert xlsx file to csv using batch
  12. Importing CSV with line breaks in Excel 2007
  13. How do I use awk under cygwin to print fields from an excel spreadsheet?
  14. converting an Excel (xls) file to a comma separated (csv) file without the GUI
  15. Create hyperlink to another sheet
  16. sep=”;” statement breaks utf8 BOM in CSV file which is generated by XSL
  17. How to save excel columns with long numbers into csv?
  18. Extract URL From Excel Hyperlink Formula
  19. Function to convert column number to letter?
  20. Better way to find last used row
  21. 2 Dimensional array from range [closed]
  22. Dir() function not working in Mac Excel 2011 VBA
  23. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  24. How do you get a Range to return its Name?
  25. How can I import an Excel file into SQL Server? [closed]
  26. Excel VBA: Convert a date string to a Unix timestamp
  27. Insert picture into Excel cell [closed]
  28. Excel VBA – exit for loop
  29. Extract the last substring from a cell
  30. Why does Excel not round according to 8-byte IEEE 754

Leave a Comment