How to include links with CSV import

2

Hi there @anon98390245 and Welcome to the Community :tada: !

Ok, so Coda actually doesn’t support “Cell” formulas (contrary to Google Sheets for example where you could have a =Hyperlink() in a cell and a =Concatenate() just in the cell below).

So, I’ve done some testing in Google Sheets, where I just copy/paste links which were rendered as links.
And I didn’t have any trouble importing this in Coda as .csv :blush: … Except for the column C which effectively became a simple text.

Capture d’écran 2021-01-20 à 13.36.42
Capture d’écran 2021-01-20 à 13.36.42972×210 17.9 KB

Capture d’écran 2021-01-20 à 13.39.40
Capture d’écran 2021-01-20 à 13.39.40972×480 24.9 KB

Now, depending on how exactly your links are originally formatted, what you could do is find a way in your .csv to disassemble the hyperlink so you’ll have the Text in one column and the link in another.

Once imported in Coda, you can recreate your hyperlink using a formula looking like this :

Hyperlink(thisRow.[Column 2],thisRow.[Column 1])

1 Like