Formulas > =ENCODEURL()

How to Use ENCODEURL() in Google Sheets

Description

Encodes a string of text for the purpose of using in a URL query..

How To Actually Use ENCODEURL() in Sheets

ENCODEURL(text)

Try ENCODEURL yourself

In cells A1:A5, enter some text phrases that you want to encode for a URL. Use the ENCODEURL formula in cell B1 to encode the text from A1, and then drag the formula down to B5 to encode the rest.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

SearchLord: One Sheet to Search Them All

I created a new product called SearchLord. It's free for now and really fun to search multiple sites with 1 key word, or 1 phrase. Free for everyone at bettersheets.co/sheetlord

In this video I add 1 more feature to SearchLord to show you how to use a FILTER() function. And we add a custom menu with a little quick apps script function.

Intermediate Beginner

ENCODEURL() FILTER() IFNA() SUBSTITUTE()

Transcript-matched member videos for ENCODEURL(). Click through to watch.

Watch more tutorials

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...

Advanced

Embed a Headline in a Website from Google Sheets

One of the most requested videos, Ever. How to put data, a number, some ...

Advanced

SUBSTITUTE()

Enter Google Drive File Name Get URL

Create a simple automation with an installable trigger that allows you t...

Intermediate

Creating a Custom URL Link for Your Spreadsheet

Create an apps script function that gets the url of your spreadsheet int...

CONCAT() HYPERLINK()

Unlock these tutorials

Learn more about the ENCODEURL() formula:

Generate a ENCODEURL() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses ENCODEURL(). 2 free AI generations, no signup. Members get unlimited use.

Generate a ENCODEURL() formula