ENCODEURL function

Encodes text so it can be used in the query string of a URL.

Parts of an ENCODEURL function

ENCODEURL(text)

Part Description
text The text to be encoded as a URL.

Sample formulas

ENCODEURL(“hello world!”)

ENCODEURL(A10)

Notes

This function is useful for passing in URL arguments to functions that make web requests, like IMPORTHTML.

Examples

Encode the text “hello, world!” into a URL-friendly format.

  A B
1 Formula Result
2 =ENCODEURL(“hello, world!”) hello%2C%20world%21

 

Use ENCODEURL to create a hyperlink. 

  A B
1 Formula Result
2 =HYPERLINK("http://google.com?q=" & ENCODEURL("hello world")) http://google.com?q=hello%20world

Related functions

  • IMPORTHTML:  Imports data from a table or list within an HTML page.
  • CLEAN:  Returns the text with the non-printable ASCII characters removed.
  • REPLACE:  Replaces part of a text string with a different text string.
Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false