Web Functions¶

HYPERLINK¶

Creates a clickable link.

=HYPERLINK(url, [label])

=HYPERLINK("https://example.com", "Visit Site") -- displays "Visit Site" as a clickable link.

Encodes a string for use in a URL (percent-encoding).

=ENCODEURL(text)

=ENCODEURL("hello world") returns hello%20world.

Imports data from a URL (CSV or TSV).

=IMPORTDATA(url)

=IMPORTDATA("https://example.com/data.csv") -- loads the CSV content into the sheet.

Displays an image from a URL inside a cell.

=IMAGE(url, [mode])

=IMAGE("https://example.com/logo.png") -- renders the image in the cell.

Creates a small inline chart within a cell.

=SPARKLINE(data, [options])

=SPARKLINE(A1:A10) -- draws a line sparkline from the values.

Options can control chart type:

=SPARKLINE(A1:A10, {"charttype", "bar"})
=SPARKLINE(A1:A10, {"charttype", "column"})