How to Use Importrange on Google Sheets on Android

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

Steps

  1. Image titled Use Importrange on Google Sheets on Android Step 1
    1
    Open Google Sheets on your Android. It’s the green icon with a white table inside. You’ll usually find it in the app drawer or on the home screen.
  2. Image titled Use Importrange on Google Sheets on Android Step 2
    2
    Tap the file that contains the data. This is the file you’ll be importing data from.
  3. Image titled Use Importrange on Google Sheets on Android Step 3
    3
    Tap ⁝. It’s at the top-right corner of the screen.
  4. Image titled Use Importrange on Google Sheets on Android Step 4
    4
    Tap Share & export.
  5. Image titled Use Importrange on Google Sheets on Android Step 5
    5
    Tap Get link. A link to this spreadsheet is now copied to your clipboard.
  6. Image titled Use Importrange on Google Sheets on Android Step 6
    6
    Tap the back button to return to the file list.
  7. Image titled Use Importrange on Google Sheets on Android Step 7
    7
    Tap the file where you want to import the data. This is the file where you’ll enter the formula.
  8. Image titled Use Importrange on Google Sheets on Android Step 8
    8
    Tap the cell where you want the range to begin. Make sure to give yourself enough space to accommodate all of the cells in the range.
  9. Image titled Use Importrange on Google Sheets on Android Step 9
    9
    Type =importrange. A list of suggestions will appear.
  10. Image titled Use Importrange on Google Sheets on Android Step 10
    10
    Tap IMPORTRANGE. The “fx” box now reads =IMPORTRANGE().
  11. Image titled Use Importrange on Google Sheets on Android Step 11
    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").
  12. Image titled Use Importrange on Google Sheets on Android Step 12
    12
    Tap
    Image titled Android7done.png
    .     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.

You Might Also Like

Allow Apps from Unknown Sources on Android
How to
Allow Apps from Unknown Sources on Android
Remove the Emergency Call Button on Android
How to
Remove the Emergency Call Button on Android
Change Number of Rings on Android
How to
Change Number of Rings on Android
Check What Kind of Android Phone You Have
How to
Check What Kind of Android Phone You Have
Unlock an Android Tablet
How to
Unlock an Android Tablet
Change the Screen Resolution on Your Android
How to
Change the Screen Resolution on Your Android
Connect Android Phone to Computer
How to
Connect Android Phone to Computer
See if Someone Read Your Text on Android
How to
See if Someone Read Your Text on Android
Access the Clipboard on Android
How to
Access the Clipboard on Android
Switch to Portrait or Landscape Mode on Android
How to
Switch to Portrait or Landscape Mode on Android
Hide Apps on Android
How to
Hide Apps on Android
Check the RAM on Android
How to
Check the RAM on Android
Access a Shared Folder on Android
How to
Access a Shared Folder on Android
Boost Microphone Volume on Android
How to
Boost Microphone Volume on Android

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 3,027 times.
How helpful is this?
Co-authors: 4
Updated: May 25, 2021
Views: 3,027
Categories: Android