Function Created in CSV File - Execute Upon Import

Looking for a tip from an Excel expert. I'm programmatically creating a pipe-delimited CSV file with approximately 30,000 rows from external CSVs. One column I an creating contains a hyperlink formula to a file. Essentially, the row is a record for a job applicant and the link would be an associated file, such as a resume or cover letter.

=HYPERLINK("TheFile.PDF", "Open Link")

When I import the CSV into Excel (2024), the column is showing the formula rather than converting into a hyperlink. The formula is correct and tested by double-clicking and hitting enter on an individual field.

Is there a way to tell Excel to actually create the hyperlink, either during the import or in bulk once the file is imported?

I've tried the google box looking for a solution but I don't know that I'm using the correct terms to trigger the correct response from google's search algorithm.

Thanks for any tips!

Update: Mdayofearth suggested doing a replace of "=" for "=" in the resulting imported sheet and that converted the formula text to the formula result. Interesting but viable for what I'm trying to do. Thanks for the assistance!