Extracting URLs from spreadsheet

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.

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.