Convert cells into links based on the cells' data. Fast and convenient way to link to more information.
By:James Burns
Works with:
3K+
Overview
Text2Link allows you to add a link to cells of plain text, where the link built contains the text of the cell somewhere in it. If you know that the text within your cells are used to build a URL or Web address, you can use Text2Link to build and attach that link to your cells.

Example: 

MyTaskSite.com/taskpage?task=(my task number here)

Let's say you have a column of task numbers that have a corresponding task webpage based on the URL above. You can create a formula in Text2Link that can then be used to convert all your cells of text to have a link as well.

Your cell text is "%s" so, in this case, the Text2Link formula would be, where %s is your cell text:

MyTaskSite.com/taskpage?task=%s

Then run the Text2Link add-on over selected cells and you're done! Now all cells are linked to webpages and you can access them whenever you want. Saves time, especially when there are many cells to link.

As you browse, see how the webpage URL/Web address is built and see how Text2Link can benefit you today.

Add-on comes with two working examples for you to quickly see how it works and it's easy to create your own! There is no limit to the amount of links you can keep on hand for easy reference. Link to most webpages to accomplish your web-based productivity needs (search results, site webpages, Server-side utility pages, etc). 

FAQ also included to find answers to common questions.

If you've already used Google Chrome's keyword-based search engine in the Omnibox, "Web Searches" for Alfred (Mac), or the "Weby Plugin" for Launchy, then you already have the understanding on how to create links quickly in your Google Sheets using Text2Link! You can even copy & paste non-Javascript Chrome Search Engine items to Text2Link! Bring that ease of use you know and love to your Google Sheets!


Like this? Check out the Google Docs version at:
https://chrome.google.com/webstore/detail/text2link4docs/chlcggfpipiighbhpmgamilojcpkjpgm?utm_source=permalink


This version:
Published to G Suite Marketplace
Additional information
PricingNot available
Developer
James BurnsTrader status unspecified
Privacy policy
Terms of service
Text2Link will ask for the permissions shown below. Learn more
Text2Link will need access to your Google account
This will allow Text2Link to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of Text2Link
May 25, 2020
Hi team, really love the app. however, the app is now blocked by Google. Hopefully you can resolve the restriction.
Is this review helpful?
Yes
No
Profile Picture
A User of Text2Link
March 12, 2017
I tried to convert the cell containg Fedex tracking number into link to track shipping status as shown following but it does not work: https://www.fedex.com/apps/fedextrack/?tracknumbers=###########
Is this review helpful?
Yes
No
1-2 of 2
Search
Clear search
Close search
Google apps
Main menu