How to Use Importrange on Google Sheets on Android

Written by Nicole Levine, MFA

This wikiHow teaches you how to import a range of cells from another spreadsheet using Google Sheets for Android.

Steps

It’s the green icon with a white table inside. You’ll usually find it in the app drawer or on the home screen.
This is the file you’ll be importing data from.

Advertisement
It’s at the top-right corner of the screen.
A link to this spreadsheet is now copied to your clipboard.
This is the file where you’ll enter the formula.
Make sure to give yourself enough space to accommodate all of the cells in the range.
A list of suggestions will appear.
The “fx” box now reads =IMPORTRANGE() .
11
Paste the copied link between the parentheses () at the end of “IMPORTRANGE.” Here's how:
- Tap the gray parentheses in the “fx” box.
- Tap your keyboard’s backspace button. This deletes the second parenthesis.
- Tap and hold the empty space next to =IMPORTRANGE( .
- Tap PASTE .
- Re-add the end parenthesis at the end by tapping the ) button below the “fx” box.
- The URL should be surrounded by quote ( “ ) marks, followed by a comma ( , ), followed by the sheet and cell range which will also be surrounded by quote ( “ ) marks.
- Example: =IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10") .
It’s on the right side of the “fx” bar. This runs the formula. In a few moments, the selected cell range will appear in the current file.

Advertisement

Search

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.