> ## Content Index
> Fetch the complete content index at: https://en.blog.themarfa.name/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to convert Google Sheets link to HYPERLINK formula
- URL: https://en.blog.themarfa.name/how-to-convert-link-to-google-sheets-in-the-formula-hyperlink/
- Published: 2020-01-28T10:48:50.000Z
- Updated: 2020-01-28T10:48:50.000Z
- Description: Often when you insert links in Google sheets everything seems OK. Until you decide to edit a link and it turns out that this is impossible.
- Author: Konstantin Dokuchaev
- Tags: EXTRACT URLs, web

Often when you insert links in Google sheets everything seems OK. Until you decide to edit a link and it turns out that this is impossible.

*This is autotranslated version of [this post](https://blog.themarfa.name/kak-prieobrazovat-ssylki-v-google-sheets-v-formulu-hyperlink/).*

The problem is solved by a simple transformation of the text links in the HYPERLINK formula. But to convert all links in the document manually would be too long and boring.

**EXTRACT URLs** extracts links from Google table and converts them to a HYPERLINK formula.

After installing this extension in the Extension menu choose Extract all the links. You can select processing within the selected range or entire worksheet.

![](https://blog.themarfa.name/content/images/2020/01/image-57.png)

Choose the option and all the links will be immediately converted into a formula.

![](https://blog.themarfa.name/content/images/2020/01/image-58.png)

[Install](https://gsuite.google.com/marketplace/app/%D0%B8%D0%B7%D0%B2%D0%BB%D0%B5%D1%87%D1%8C%5F%D1%81%D1%81%D1%8B%D0%BB%D0%BA%D0%B8/143780651832)