URL in field of CSV file

A

Al Grant

My web app generates a CSV file for import into Excel. One column is
a URL that links back to the app to retrieve the original record. Right now
Excel reads this URL as plain text and the user needs to right-click and
convert to a hyperlink. Can I get Excel to recognize the URL automatically,
e.g. by formatting it in a special way? I have complete control over the
content of the CSV file but want to make it as simple as possible for the
Excel users.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top