Skip to content
Google Sheets

ENCODEURL function in Google Sheets

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

=ENCODEURL(text)

ENCODEURL syntax and parameters

One argument, one required.

  • textstringRequired

ENCODEURL examples

Formulas you'll actually reuse.

  1. A safe query string from a customer name with spaces and accents:

    ="https://example.com/search?q=" & ENCODEURL(A2)

    Result"https://example.com/search?q=Maria%20L%C3%B3pez"

  2. A clickable map link built from address parts:

    =HYPERLINK("https://maps.example.com/?q=" & ENCODEURL(B2 & ", " & C2), "Map")

ENCODEURL in Excel

Same name — your formula ports as-is.

Try ENCODEURL in the playground

Edit the example — nothing to install.

Preloaded with the ENCODEURL formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.