Description: If a csv file contains a column with hyperlinks these links will be imported as text. When importing the file the column type can be changed in the dropdown menu. Would it be possible to add the type Hyperlink or URL to this menu, and then automatically convert the column to links? Another option would be to have a "Link" option in the cell formatting menu. Steps to Reproduce: 1.Import CSV file with URLs in a column Actual Results: Column is formatted as text Expected Results: Column with links Reproducible: Always User Profile Reset: No Additional Info: There should be an easy way to format it as link
Can you attach a sample csv file?
Created attachment 180002 [details] Sample .csv with urls
[Automated Action] NeedInfo-To-Unconfirmed
UX team: what do you think? The only related one I found is bug 62828, which would give a lot of flexibility for imports.
There is no hyperlink cell aka number format. But when entering a hyperlink manually it's detected automatically. I could imagine to add this to the CSV import, maybe optionally since removing a hyperlink is as tedious as applying.
Meantime, it is not so difficult to convert to hyperlinks. Select the cells to be converted into hyperlinks. With search and replace: Search for: .* Replace by: =hyperlink("&") Mark: Selected range. Regular expressions. Replace all.