Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Google sheets import not converting links properly

Topic Labels: ImportingExporting
296 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, I am trying to import a google sheet where the one columns is all URLs. In order to make the URL column readable, I made each cell the word LINK and then linked that to the actual URL. To put that into HTML terms,

<a href="http://www.airtable.com">LINK</a>

(I am not sure how Google sheets stores that internally.)

Unfortunately, airtable converts that all into either the tag LINK (with rounded corners and pretty color) or the relative URL “link” if you assign the type URL to the column.

I suspect that on import already, Airtable discarded the URL information and just kept the link text?
Is there anything I need to tweak this on import to get the desired effect? Going through all thousand rows an hand-unpacking things back to just the URL is not really an option.

1 Reply 1

I tried downloading it as an Excel spreadsheet first. In the Excel spreadsheet the links were correct. However, importing the Excel spreadsheet produced the exact same behavior, only LINK.