Hello. I have a spreadsheet file. The first column contains hyperlinks.
I can only import .csv files into Airtable, and during the conversion all the hyperlinks become plain text, but I need to preserve the link
I have tried customising the field type in Airtable to “Single Line Text” and “Hyperlink” but the former converts the link to plain text, and the latter tries to be clever (if my hyperlink text is “hyperlink” it tries to create a link to hyperlink[DOT]com instead of retaining the actual link).
Am I missing a trick, or does Airtable not support inputting hyperlinks yet? There are lots of records, so I don’t want to have to try and separate the link text and URL into two different columns manually, and don’t know enough code to separate them out with a script.