How to create a URL link in Numbers from a CSV file

I have a CSV file that I open in Numbers, I need one of the cells to be a URL clickable link though, and in the CSV file if I use something like this, it does not turn into a clickable link in Numbers:

=HYPERLINK("https://www.apple.com ","Apple")

If I type in the above in a cell in the Numbers app, then it automatically turns into a clickable link with the words "Apple". I am guessing if Numbers opens a CSV file, it does not support functions such as =HYPERLINK. Perhaps it has to be a Numbers formatted file for it to support functions? Is there a way to "ask" Numbers to open a CSV file in Numbers format so that it can understand the HYPERLINK function?