Extract URLs extracts links and converts them to the HYPERLINK formula.
and select a range with links. Go to the menu - Add-ons - Extract URLs - Action
This program is distributed free of charge.
An useful add-on for Google Sheets
The Google QUERY alternative for Google Sheets