Google Sheets ImportRange Function
In education there are times when we gather data into a sheet and need to share parts of the form out to others. How does one do that so that it populates automatically over time without copying and pasting time and time again?
Video
Warning: My goal is to take the questions people have about technology and provide solutions. This is just one solution. If you have other ideas or methods to solving the same issue, then please leave a comment or reach out so we can showcase the method. This is not the only method, but simply one that I use.
Steps
For those who don’t want to watch a video, here is a quick guide. To do this tutorial you need to have open
Existing spreadsheet with the data you want to move to another Sheet
The new Sheet you want to create
Step 1
Grab the key from the URL of the Google Doc you want to import.
screen-shot-2016-10-16-at-8-10-16-am
Step 2
Write down or take a mental note of the columns or range you want to import. You can import entire columns by entering something like Tab Title!A:F. Or, for a specific range, something like Tab Title!A6:F100.
Step 3
Go to your new Sheet that you are creating. Enter the following data in the Sheet where you want it to appear.
=IMPORTRANGE("1Nr7KSaqpkq52zRlPD0PybQ_AqKxh55jsY_LB-QWj-Mw","responses!D:F")
Make sure you swap out my key with your own as well as the range of data you want to copy over.
screen-shot-2016-10-16-at-8-24-12-am
Step 4
Format your data. You can do it by hand or use the Explore option to make it look nice. This is why choosing where to add the function is important.
Learn More
Check out the resources on my Google page on this website as well as my YouTube playlist of tips
Please be sure to leave a comment with other ways you sort data and any questions, tips, tricks, and ideas that you have.
Смотрите видео Google Sheets ImportRange Function онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Aaron Maurer 16 Октябрь 2016, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,019 раз и оно понравилось 12 людям.