7

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.

1

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.

| 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
8

This worked for me, via file -> import -> upload:

contents of test.csv:

=HYPERLINK("www.google.com"),howdy
=HYPERLINK("www.facebook.com"),yup
| improve this answer | |
  • This should be the accepted answer. – OddBrew Apr 11 '19 at 15:34
3

for me, @serenesat got me in the right direction, but it did not work.

I got the import to Google Sheets to work by doing this:

  1. Ensure that the CSV contains the HYPERLINK formula, and I used quotes (double, e.g. ") for all my data, and then two double-quotes (e.g. "") inside the text for a cell to get a quote in the imported data. Example:

    "Id";"Author";"Link"
    1243;"Google";"=HYPERLINK(""www.google.com"",""Search"")"
    1245;"Google";"=HYPERLINK(""www.google.com"",""Search"")"
    
  2. After doing the import, in Google Sheets, select the data with the links (rows, columns or all of the data in the sheet) and get Google Sheets to "activate" the imported formulas by selecting Format → Number → Automatic.

That worked for me, hope it helps someone. :-)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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