Libreria formule

Funzioni Google Sheets

Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.

Digita almeno 2 lettere per vedere i suggerimenti.

Web

ENCODEURL

ENCODEURL(text)

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

Apri scheda
Web

HYPERLINK

HYPERLINK(url, [link_label])

Creates a hyperlink inside a cell. Learn more

Apri scheda
Web

IMPORTDATA

IMPORTDATA(url)

Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. Learn more

Apri scheda
Web

IMPORTFEED

IMPORTFEED(url, [query], [headers], [num_items])

Imports a RSS or ATOM feed. Learn more

Apri scheda
Web

IMPORTHTML

IMPORTHTML(url, query, index)

Imports data from a table or list within an HTML page. Learn more

Apri scheda
Web

IMPORTRANGE

IMPORTRANGE(spreadsheet_url, range_string)

Imports a range of cells from a specified spreadsheet. Learn more

Apri scheda
Web

IMPORTXML

IMPORTXML(url, xpath_query)

Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Learn more

Apri scheda
Web

ISURL

ISURL(value)

Checks whether a value is a valid URL. Learn more

Apri scheda