Microsoft Excel: Interpret CSV URLs as hyperlinks

1149705 pts.
Tags:
CSV file
Microsoft Excel
URL
I have a CSV file and I'm wondering if it is possible to have Microsoft Excel interpret my URLs as hyperlinks. Can anyone help me? Thank you.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t know how many rows you’ve got, but when you open the CSV file in Excel you can click on a cell containing a URL and press the F2 function key followed by Enter to make it format as a hyperlink.  If you haven’t got too much data that’s probably the easiest way to do it (you could try writing a macro to do the same thing if you’ve got a lot of data).

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Just keying a URL into an empty cell will make it a hyperlink.
    Are you having any specific errors or are they not working.
    if so how are your cells formatted?
    134,720 pointsBadges:
    report
  • carlosdl
    I assume the file is not being written by hand.

    I did something similar in the past, and I remember I was able to make it work by writing the hyperlink function as part of the CSV string, but I'm not sure it will work in recent versions of Excel.

    I would try writing a simple CSV file by hand on Excel, including links, and then open it using Notepad or some other text editor, to see how the text was added, and try to replicate it on the new file.
    85,055 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: