ENCODEURL

Formulas / ENCODEURL
Encode a text string into a URL-safe format.

ENCODEURL(text)

Examples

=ENCODEURL("http://contoso.sharepoint.com/Finance/Profit and Loss Statement.xlsx")
The ENCODEURL function can be used to convert a URL into a URL-encoded string. This is useful for sharing and accessing files on a Microsoft SharePoint server. For example, this formula will return a URL-encoded string that points to a particular Sourcetable file on the SharePoint server.
=ENCODEURL("http://contoso.sharepoint.com/Finance/Profit and Loss Statement.xlsx?year=2020")
The ENCODEURL function can also be used to convert URLs that include query parameters. For example, this formula will return a URL-encoded string that points to a particular Sourcetable file on the SharePoint server and includes the query parameter "year=2020".
=ENCODEURL("https://www.google.com/drive/Finance/Profit and Loss Statement.xlsx")
The ENCODEURL function is also useful for sharing files stored in a cloud storage service and will return a URL-encoded string that points to a particular Sourcetable file stored in Google Drive.

The ENCODEURL function allows users to protect URLs from being copied and pasted by encoding the URL string into a shorter alphanumeric value.

The ENCODEURL function takes a US-ASCII string and returns a URL-encoded version of it.
The ENCODEURL function only uses US-ASCII characters for encoding.

What is the ENCODEURL function?

The ENCODEURL function is a string function that is used to encode text so that it can be used in a URL.

What is the syntax for the function?

The syntax for the ENCODEURL function is ENCODEURL (string).

What type of argument does the function take?

The ENCODEURL function requires a string argument.

What does the string argument mean?

The string argument is the text to be URL encoded.

What are some common uses for the function?

The ENCODEURL function can be used to encode characters in a URL so that it looks presentable and professional.
It can also be used to encode special characters in a URL.
The ENCODEURL function can also be used to encode text that needs to be passed as a parameter in a URL.

Drop CSV