Text plain to hyperlink in Calc

Hi all,

I have imported a column from a CSV to an ODS file with links (local files, not url) to photos like this:



By now they are text plain and I’d like to convert them to clickable hyperlinks. If I rewrite manually the routes, it works, but I have hundreds of files and I need to do it in an automatic way.

Any suggestions? Many thanks in advance!


did you check the Ask-ed questions beforehand?

Also, querying my preferred search engine: “calc automatic convert text to hyperlink”

I found this question (and response :slight_smile: Calc: Convert text to link

Does it fit your needs?