Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Based on a csv import, I would like to show formatted hyperlinks. There is a formula =HYPERLINK( "www.google.com" ; "Search Google" ) that does this, but is there any way to include this in a csv import?

This csv line does not work:

"test","=HYPERLINK(""""www.google.com"""";""""Search Google"""")"

I can manually change the spreadsheet after the input, but I would like to base everything on the csv.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

I've been searching the internet and found out that there's no way to do that in Google Spreadsheet. I did however created a fairly simple work-a-round:

  1. Prepare the following CSV line:
    test,'=&*HYPERLINK(C1;E1),www.google.com,"Search Google"

  2. Go to the Edit menu and select Find & Replace:

    enter image description here

  3. Enter the following:

    enter image description here

  4. The formula will be recognised and accepts the references.

Adding the special characters (&*) will make it very unlikely that other "fields" are affected by the "Find & Replace" function.

share|improve this answer
    
I was afraid it would be something like this, did you find any documentation stating that it is not possible? –  Jasper Duizendstra Dec 24 '12 at 8:24
    
No. I've uploaded many variations, down loaded them and uploaded them again. Together with your research, I'm pretty sure it isn't possible. –  Jacob Jan Tuinstra Dec 24 '12 at 10:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.