This wikiHow teaches you how to import data from one sheet to another in Google Drive for Android.
Steps
-
Open Google Sheets. It’s the white table on a green background. You’ll usually find it in the app drawer.
- If the data to be imported is in a different file (rather than another sheet in the same file), see Use Importrange on Google Sheets on Android instead.
-
Tap the spreadsheet you want to edit.Advertisement
-
Tap the sheet you want to import data to. Sheets are listed along the bottom of the screen.
- For example, if you want to import data from Sheet3 to Sheet1, tap Sheet1 now.
-
Tap a blank cell. This is the cell where the imported data will soon appear. This opens the function (fx) bar at the bottom of the screen.
-
Type = followed by the location of the data. The format is =Sheet1!A1 .
- Ex: To import the value of B3 on a sheet called Totals, type: =Totals!B3 .
- If the sheet’s name contains spaces (e.g. Sheet Name), surrounded the name in single quotes. Ex: =’Sheet Name’!B3 .
-
Tap the blue check mark. It’s at the top-left corner of the sheet. The data from the other sheet now appears in the current cell.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
About this article
Article Summary
X
1. Open Sheets
.
2. Tap the spreadsheet.
3. Tap the destination sheet.
4. Tap a blank cell.
5. Type the path to the cell to be imported.
6. Tap the check mark.
Did this summary help you?
Thanks to all authors for creating a page that has been read 3,680 times.
Advertisement
