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.
Step 1
First, navigate to the spreadsheet that includes the data you want to import. Copy the URL of this document to your clipboard.
Step 2
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.
Step 3
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:
=VSTACK(IMPORTRANGE(“<URL>”,”Sheet1!A1:F19″),
IMPORTRANGE(“<URL>”,”Sheet2!A1:F13″))
Step 4
We can also use the curly braces and semi-colon character to achieve a similar result
Summary
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.