Ask Your Question

Extracting URLs from spreadsheet

asked 2017-01-05 11:03:57 +0200

1uckystrike gravatar image

Hi everyone,

I'm quite new to Libreoffice Calc and I'm trying to extract URLs from a series of spreadsheets. I'm not talking about hyperlinked text/numbers, but URLs that are displayed in full (https:.. etc). Doing it manually is not really doable since it are several hundred (maybe thousands) URLs. I've tried looking for a solution through Google and on these forums but I can't find one. Is this even possible? Is there maybe another application which would allow me to extract URLs from a CSV file? Thanks in advance for your reply.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-05 23:01:33 +0200

m.a.riosv gravatar image

You can reference a csv file like a spreadsheet with rows and columns. If you want to have those URLs linkable put the reference inside the HYPERLINK( ) function.

But please explain with more detail what you want achieve.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-05 11:03:57 +0200

Seen: 322 times

Last updated: Jan 05 '17