Google Sheets – Import CSV and Show Formatted Hyperlinks

google sheetsgoogle-sheets-import-csv

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.

Best Answer

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.

Related Topic