# IMPORTRANGE

web · from google sheets · no excel equivalent · sheets: not yet compared

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.

## signature

```
IMPORTRANGE(workbook, range_string)
```

returns: `array`

## arguments

- workbook: text — required
- range_string: text — required

## usage

- `=IMPORTRANGE("worldbank/gdp", "data!A1:E3")`
- `=IMPORTRANGE("worldbank/gdp", "data!D2")/IMPORTRANGE("worldbank/population", "data!D2")`

## related

- [DECODEURL](https://deepcalc.com/functions/decodeurl.md) — decodes URL-encoded text
- [ENCODEURL](https://deepcalc.com/functions/encodeurl.md) — encodes text for use in URLs using percent encoding
- [FILTERXML](https://deepcalc.com/functions/filterxml.md) — selects values from an xml STRING with an xpath
- [QUERY](https://deepcalc.com/functions/query.md) — runs SQL-like query on data range

## navigate

- [all web functions](https://deepcalc.com/functions/web-functions.md)
- [function index](https://deepcalc.com/functions.md) — all 601 functions
- [error values](https://deepcalc.com/errors.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)
- [everything in one file](https://deepcalc.com/llms-full.txt)

source: https://deepcalc.com/functions/importrange