Syncing one spreadsheet to another in Google Sheets

Introducing G Suite Pro Tips, quick tutorial videos to help you automate simple tasks at work. In this video, a G Suite Developer Advocate explains how to use the IMPORTRANGE function to import data from one spreadsheet into another...in just two minutes!

If you have additional questions or ideas for future G Suite Pro Tips, leave them in the comments below!

#GoogleWorkspaceProTips #CustomizingGoogleWorkspace

[josephleopard]

Nice to see you're putting up tips again. I like the 'bite-size' tip format. G Suite Show episodes were a bit too much at once for my less tech-savvy users.

[nomenetasaili]

Thank you Joanna. I like how straightforward and relatable these use cases are.

[kuremyona]

Amazing video but I can't get it to work. I keep getting errors

[StephanAshkenazy]

Thank you so much, young lady! Very helpful! Great job!

[nijanelson]

Awesome Teacher. By far one of the best instructional videos.

[Oyabun]

This is perfect in what I need, however, how do I also keep the source formatting? I want to maintain the formatting of the cells as well as for the data.

[kraftykatninja]

How can I get the data to constantly stay accurate? I found linking items by columns like that doesn't include new items. What is the best way to make the additions "infinite"?

[snowmail]

I want a function that will update data going both ways, one from the person sharing it, and the other from the person having it shared to can update valves

[juanrivascaban]

This is phenomenal! Love the video, love the instructions, and most of all, I love the functionality! Bravo!

[StoreGear]

Great tutorial, great production value, great execution of a video. Good job team!

[shaunekathleenpapilla]

This video tutorial is superb!!!! Very informative and easy to digest. I was also wondering if it's possible to sync updates from the primary spreadsheet be transferred to another spreadsheet where the latter will only be accessible and edited by those who have the access but won't make any direct changes from the primary spreadsheet/sourcewhere the data was acquired? Thank you!

[persecutedHim]

Great video!! works great after I figured out what I did wrong on a second listen.

[agustyan]

Thank you very much, this tutorial is very helpful

[gonzalozapata]

Hi Joanna, I´m google account user and can´t connect my google sheets as you show in the video. After I use the IMPORTRANGE function and give the Allow Permition the Adding Permissions step never stop!

[margauxpaine]

This is super helpful, but if the information is changed in one spreadsheet will it automatically be changed in the other?

[paigefrankovich]

Is there anyway to do this and then on the master still edit everything? Like delete lines that were imported for syncing?

[CarlosDaniel]

Amazing. It worked perfectly. Thanks for sharing

[fatimagajia]

Hiya this is great and i have linked data from other google sheets, however i have data in in multiple tabs and i need it to link to one master sheet . what i want to do is if i am looking at line 15 in tab A and then when i go to tab B, i want to be looking at line 15 so that i am able to update different information

[darcyg]

Love your video's Joanna! So comprehensive.

[andrewxzlee]

I have a master google spread file with many different column entries. However I do have other display spread files to show only specific set data from the master field to my different stakeholders. My query is how do I enable to data from the master file to be automatically imported to the other display spread files. Have tried Vlookup and import data but the system hangs. Would hope to hear from you shortly :) Warmest regards.