This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. 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.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 3,586 times.
This How.com.vn 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
About this article
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.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
