# IMPORTRANGE ## Definition(s) ### Context : [[Nexus - Google Analytics Certificate Course|Google Analytics Certificate]] #### Sub-context: [[Function#Spreadsheet functions]] >[! Definition] >This function can dynamically import a range of cells from a source google sheet spreadsheet ## Examples ```spreadsheet =IMPORTRANGE("URL","sheet_name!cell_range") ``` ## Related [[Function#Spreadsheet functions|List of Spreadsheet functions]] [[IMPORTHTML|=IMPORTHTML()]] [[IMPORTDATA|=IMPORTDATA()]] ## Resources [Docs: Google Sheets IMPORTRANGE](https://support.google.com/docs/answer/3093340?hl=en&ref_topic=9199554) ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/) This function can dynamically import a range of cells from a source google sheet spreadsheet @@@ [[IMPORTRANGE|=IMPORTRANGE()]]