Well, if you’re looking to import data from one Google Sheet to another — your quest ends here. We know how complex importing data from one Google sheet to another is.
The thing is, you have the option to copy/paste data from one sheet to another. However, this could be a lot of work if there are too many tabs with data in them. Also, once you make changes to the old sheet, the new sheet won’t get updated automatically.
To help you solve the hassle, we have featured a guide to help you transfer Google Sheets data from one to another.
Without further ado, let’s get straight to the list.
Ways to Import Data From One Google Sheet to Another
To easily import data from one sheet to another, follow the below-mentioned methods. You can follow any of the methods listed below.
1. Import Data From Other Sheet In The Same Document
Somehow if you want to import the same document from one cell to another, you just need to use a simple formula below in the destination cell.
This method works like a charm for simple data imports alongside calculations. What’s more, this option also links both the cells. This means once you make changes in the original cell, the changes will get reflected automatically right in the destination cell.
2. Import Data From A Google Sheet In the Other Document
You can follow this method if you want to import data from one document to another or if you just want to transfer multiple cells at a time.
In this particular case, you need to use the simple formula [=IMPORTRANGE]
Well, you need to follow the steps listed below:
1. Just open the Google Sheet where you want to import the data.
2. Now select an empty cell. Keep in mind that your data will transfer to the top left corner.
You need to make sure that all the cells covered by your data are just empty. If the cells are covered and not empty, you will get an error message.
3. In this step, you need to enter this formula [=IMPORTRANGE( “SheetURL.” SheetName!CellRange”)] right in the top-left cell.
4. Just use the sheet URL that you want to import the data. Remember the sheet name and cell range are optional.
5. Now press “Enter.”
6. In this step, you need just to allow access to your sheet
7. So this is how you can easily import and sync your data from one Google Sheet to another.
Wait, if all these steps seem foreign to you — we suggest following the method listed below.
3. The Easy Way to import Data From A Google Sheet to Other
This is one of the easiest ways to import data from one Google Sheet. Whether you want to import data from a sheet in the same doc or a different one, this method works like a charm.
This method requires you to have a subscription to Supermetrics, don’t worry; you always sign up for the free trial.
- First of all, open your destination sheet.
2. Now, you need to select an empty cell. Just remember that all your data will transfer to the top left corner.
3. In this step, you need to just click on “Add-ons >> Supermetrics >> Launch Sidebar.”
4. Just select the data source and then easily scroll to the Google Sheet.
5. Now enter the sheet URL for which you want to import your data right from the “Report Configuration” failed.
6. Just press on the “Get Data to Table.”
7. Yes, it’s done.
What’s more, you have the option to easily set up the automatic refresh and email right for the imported data. At last, simply click on the Schedule tab right from the sidebar menu.
Note: This method comes in handy when you’re sharing a report with your team or client. Once you update your original sheet, they will receive an email with all the refreshed data.
Final Verdict: How to Import Data From One Google Sheet To Another
So this is how you can easily import data from one Google Sheet to another. We have listed the three easy ways to import data from one Google Sheet to another easily. You can choose any method as per your suitability; however, the third method is easy.
Now over to you; share your thoughts in the comments section below.
Reference: Supermetrics Blog