Get/Extract URL from hyperlink

[Jan_Tang]

Hi, Does anyone know if it is possible to import a list of hyperlink URLs from spreadsheet to airtable? I know CSV files can be imported. If you copy and past links directly from Excel file to import, then the hyperlinks will be displayed as text rather than hyperlink type in airtable. Thank you in advance.

[Kamille_Parks]

superuser.com

Excel: convert a column with hyperlinks to just display the links

microsoft-excel, microsoft-excel-2008

asked by nicole on 08:51PM - 29 May 12 UTC

[Jan_Tang]

Thank you very much, Kamille_Parks. The link you provided is very helpful. I did what I wanted to do.

[J_W1]

Is there a solution within AT already? With scripting maybe?

Usecase: want to export my Safari and Chrome bookmarks into Airtable including full urls to be able to sort better)

[J_W1]

Is it only me or would this be a quite useful for us if Airtable implemented a solution for this??
I’ve at least seen it asked in the forums a couple of times already.

At least for me, it would be great if we could:
1. copy/paste lines with hyperlinks to a rich text field in Airtable while retaining the hyperlink
2. an Airtable formula to convert such hyperlinks to a full URL (or otherwise a script)