Web
★ 12 · ◉ 70 · Excel 2013
=ENCODEURL()
The ENCODEURL function returns a URL-encoded string, replacing certain non-alphanumeric characters with the percentage symbol (%) and a hexadecimal number.
=ENCODEURL(text)
External Data, Web & Cube
Web
★ 15 · ◉ 59 · Microsoft 365
=PY()
PY function
=PY(python_code,return_type)
External Data, Web & Cube
Web
★ 15 · ◉ 53 · Microsoft 365
=IMPORTCSV()
IMPORTCSV function
=IMPORTCSV(path, [skip_rows], [take_rows], [locale])
External Data, Web & Cube
Web
★ 12 · ◉ 51 · Excel 2013
=FILTERXML()
The FILTERXML function returns specific data from XML content by using the specified xpath.
=FILTERXML(xml, xpath)
Text Manipulation
External Data, Web & Cube
Web
★ 15 · ◉ 44 · Microsoft 365
=COPILOT()
COPILOT Function
External Data, Web & Cube
Web
★ 15 · ◉ 41 · Excel 2013
=WEBSERVICE()
The WEBSERVICE function returns data from a web service on the Internet or Intranet.
=WEBSERVICE(url)
External Data, Web & Cube
Web
★ 15 · ◉ 20 · Microsoft 365
=IMPORTTEXT()
IMPORTTEXT function
=IMPORTTEXT(path, [delimiter], [skip_rows], [take_rows], [encoding], [locale])
External Data, Web & Cube