Ask Your Question

Extracting URLs from spreadsheet [closed]

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

1uckystrike gravatar image

updated 2020-08-13 16:44:20 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-13 16:44:37.672864

1 Answer

Sort by » oldest newest most voted

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

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

Question Tools

1 follower


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

Seen: 580 times

Last updated: Jan 05 '17