In this article:

How to Import Multiple Sheets Using the IMPORTRANGE Function

Importing a data range from a single sheet

The IMPORTRANGE function allows you to import a specific data range from another Google Sheets workbook. It has the following syntax:


=importrange("url_of_workbook","data_range")


For example, we will import the following Pivot Table from a source spreadsheet to a destination spreadsheet:


The range from the source spreadsheet to be imported to the destination sheet.
The range from the source spreadsheet to be imported to the destination sheet.


The URL to the source spreadsheet and the range are needed to import the array using IMPORTRANGE function.


Both the URL and the data range should be enclosed by quotation marks. The workbook must be either a public workbook or one that you have access to.


If the workbook you are including is also yours, a prompt will pop up, asking you to connect the sheets. Click Allow access. 


A pop-up prompt by Google Sheets to allow access to another Google Sheets worksheet. Statement: You need to connect these sheets. 


Afterward, the data will be loaded. 


The range from source spreadsheet imported in the destination spreadsheet. Note that the formatting and style from the source spreadsheet was not copied.
The range from source spreadsheet imported in the destination spreadsheet. Note that the formatting and style from the source spreadsheet was not copied.

A workaround to import multiple sheets

The question is, how can we import multiple sheets using the IMPORTRANGE function?

Unfortunately, we cannot specify multiple spreadsheets or multiple sheets via the IMPORTRANGE function. The function works with only one range from a single source specified. 

Nonetheless, there are workarounds. A simple workaround involves using a pair of braces with a set of items separated by a comma or a semicolon. The comma would put the ranges side-by-side:

={importrange(url1,range1),importrange(url2,range2),importrange(url3,range3)}

while the semicolon would put them on a single column:

={importrange(url1,range1);importrange(url2,range2);importrange(url3,range3)}

If we want to import multiple sheets from a single spreadsheet, we add an IMPORTRANGE function for each of the sheets, specifying their respective ranges, while specifying a single URL for all of them:

={importrange(url,range1);importrange(url,range2);importrange(url,range3)}

The result will look like this:

The ranges from multiple sheets combined in the single destination spreadsheet.
The ranges from multiple sheets combined in the single destination spreadsheet. 


Supercharge Your Spreadsheets with Lido

🚀 Import data from anywhere and build custom tools and powerful dashboards straight from your spreadsheet. Discover what's possible in our Build Gallery.

Schedule a free automation consult
Learn more

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started