Ask Your Question

Bulk convert plaintext to links in Writer

asked 2016-04-15 07:00:52 +0200

Jack2359 gravatar image

updated 2016-04-15 07:09:45 +0200

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.


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-04-17 10:01:53 +0200

Jack2359 gravatar image


folks at another forum suggested

1) just search-replace the "d:\" with "file:\\d:\"


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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-15 07:00:52 +0200

Seen: 75 times

Last updated: Apr 17 '16