Hyperlink too long in Excel from csv file

Question

I am producing from Python a csv file in excel, with a column containing list of urls, such that a user can click on the link and open the internet site on the browser.

I am writing in the csv file a cell with this code:

=HYPERLINK("my_address";"Clickable_link")

Everything works fine, if the address is short (less than 255 characters), but fails otherwise.

What I tried:

• splitting the address into two cells and concatenate does not seem to work (e.g. =HYPERLINK(A1&A2;"Clickable_link")) does not work ;
• Programmatic based solutions Exceeding Max Char Limit in Excel , seem to have hardcoded the cell and the link name, so that I am not sure how to make the solution work for thousands of cells ( anyway, the linked question is quite old). I am not an everyday Excel user, so I may have missed something there.

What I want:

• A solution that does not require more than one manual intervention per file ( since the links in my application will be of the order of thousands ). Also opening the csv file in other ways would be a solution, as long as I am able to make hyperlinks, even if ideally I would like to stick to Excel 2016.