ExcelExcel 2013+
ENCODEURL function in Excel
Returns a URL-encoded stringThis function is not available in Excel for the web.
=ENCODEURL(text)ENCODEURL syntax and parameters
One argument, one required.
- textstringRequired
A string to be URL encoded
ENCODEURL examples
Formulas you'll actually reuse.
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"A clickable map link built from address parts:
=HYPERLINK("https://maps.example.com/?q=" & ENCODEURL(B2 & ", " & C2), "Map")
ENCODEURL in Google Sheets
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 Excel gets this done.
- FILTERXMLReturns specific data from the XML content by using the specified XPathThis function is not available in Excel for the web.WebNo Google Sheets equivalent
- WEBSERVICEReturns data from a web service.This function is not available in Excel for the web.WebNo Google Sheets equivalent
- ABSReturns the absolute value of a numberMathGoogle Sheets
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- ACOSReturns the arccosine of a numberMathGoogle Sheets