Bulk convert plaintext to links in Writer

I have made a .doc document to group and categorise a list of 5000 path statements of files dotted around my Documents folder.
.

Like this:
.

Group 1:
.
D:\Documents\Folder3\Subfolder6\filename5.html
.
D:\Documents\Folder9\Subfolder2\filename1.html
.
D:\Documents\Folder4\Subfolder9\filename3.html
.
.

Group 2:
.
D:\Documents\Folder7\Subfolder1\filename2.html
.
D:\Documents\Folder2\Subfolder2\filename4.html
.
D:\Documents\Folder8\Subfolder4\filename8.html
.
…etc

I want to turn each line in the document into a hyperlink, so I have a clickable “homepage” in this layout. (I need to preserve the groupings/sequence of lines in the document and I can’t mess with the locations of the individual files).

I can make hyperlinks by going through each line individually and use “Edit>Insert link”, but this is very tedious for 5200 lines! Is there a “bulk” way to turn every line into a hyperlink? Both the address and the label can be the same (=the path statement), if that helps.


Separately, at some point in the future, I might want to move all the source files
from
.

D:\Documents\ etc
.
to
.
D:\Documents\NEWSUBFOLDER\ etc
.
in which case, I would need to create/edit all the links again. Again, I want to do this in bulk, not line-by-line.

I’m using Windows (10) and the latest version of Libreoffice.

thanks

hi

folks at another forum suggested

  1. just search-replace the “d:” with “file:\\d:”

or

  1. in Excel/Calc use the operator =HYPERLINK(a1), then a html editor to put them back into a text list