IMPORTRANGE

Definition

A Google Sheets function that imports data from another Google Sheets spreadsheet. The syntax is =IMPORTRANGE(spreadsheet_url, range_string). This function is essential for businesses that maintain separate spreadsheets for different departments or time periods and need to consolidate data into a master dashboard. The first time you use IMPORTRANGE, you must grant access between the two spreadsheets.

Related Templates

These SheetCraft templates use or relate to IMPORTRANGE:

• Small Business Bookkeeping System, Simple bookkeeping for small business owners who don't have an accountant, income, expenses, P&L, sales tax, and bank reconciliation.
• Marketing Campaign Dashboard, Track multi-channel marketing campaigns, Google Ads, Meta Ads, email, and organic, with ROAS, CPA, and A/B test logging.

Related Terms

• ARRAYFORMULA
• Conditional Formatting
• Data Validation
• INDEX-MATCH
• Named Range