imports a range from another deepcalc workbook, addressed as {namespace}/{name} — e.g. worldbank/gdp. Resolution is journaled, never live-silent: refreshing the workbook's Sources materializes the target values as ordinary ops, so every upstream change arrives as a reviewable diff. Each source can track the latest version or be pinned to a specific one (the Sources panel). Before the first refresh the cell shows #NAME?. The inline form ={ns}/{name}!worksheet!A1:B10 is equivalent. · from google sheets · no excel equivalent · sheets: not yet compared

resolved at the workbook layer, not by the engine: values arrive when the workbook's Sources are refreshed (journaled, reviewable, pin/track per source) — before the first refresh the cell shows #NAME?.

signature

IMPORTRANGE(workbook, range_string)

returns: array

argument	required
workbook	required
range_string	required

examples

live results — the values below were fetched from the public worldbank mirrors when this page rendered; a refresh materializes exactly these values into your workbook.

related

• DECODEURL decodes URL-encoded text
• ENCODEURL encodes text for use in URLs using percent encoding
• FILTERXML selects values from an xml STRING with an xpath
• QUERY runs SQL-like query on data range