Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to importrange multiple ranges in Google Sheets.
How To IMPORTRANGE Multiple Ranges in Google Sheets
The IMPORTRANGE function in Google Sheets is a great way to bring data from other spreadsheets into your current sheet.
However, you may need to import data from multiple sources into a single output using just one formula.
In this guide, we will show you how to use the IMPORTRANGE function to import multiple ranges of data in Google Sheets.
We will cover how to use the VSTACK and array syntax to combine two IMPORTRANGE outputs into a single result.
How to Use IMPORTRANGE With Multiple Ranges in Google Sheets
Here’s our step-by-step guide on how to use IMPORTRANGE with multiple ranges in Google Sheets.
First, navigate to the spreadsheet that includes the data you want to import. Copy the URL of this document to your clipboard.
In the destination spreadsheet, use IMPORTRANGE to add the external data into your spreadsheet.
The IMPORTRANGE function requires two arguments: the URL of the external data, and the complete cell reference to the data you want to import.
In the example above, we were able to import the range Sheet1!A1:F31 from our source spreadsheet.
We can use the VSTACK formula to append two IMPORTRANGE results.
In the example above, we used IMPORTRANGE to import data from Sheet1 and Sheet2 of our source spreadsheet.
We used the following formula to combine both results into a single array:
We can also use the curly braces and semi-colon character to achieve a similar result
This guide should be everything you need to learn how to importrange multiple ranges in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to import in Google Sheets:
- Fix IMPORTRANGE Internal Error
- IMPORTRANGE From Another Tab
- IMPORTRANGE With Conditions
- IMPORTRANGE With Formatting
- VLOOKUP + IMPORTRANGE
- Filter IMPORTRANGE Data
- Fix IMPORTRANGE Error Loading Data
- Fix IMPORTRANGE Formula Parse Error
- Open CSV File
- Create A CSV File
- Import Data Into Google Sheets
- Import Spreadsheet Into Google Sheets
- Export Google Sheets To Excel
- Download Google Sheets
- How To Use Importrange
- Import CSV
- Import Excel
- Save as a CSV
- Import Data From Another Sheet
- Import Google Sheets To Excel
- Import PDF
- Export a Google Sheet into Different Formats
- Pull Data From Multiple Tabs
- Connect Google Forms To Google Sheets
- Open Excel In Google Sheets