Watch this step-by-step IMPORTRANGE function tutorial for Google Sheets by Railsware Product Academy. In this video, you will learn to :

✅ Transfer data between the spreadsheets (or tabs) using the IMPORTRANGE function
✅ How to combine IMPORTRANGE with other functions, like SUM, ARRAYFORMULA, etc.
✅ Apply conditions for IMPORTRANGE with QUERY
✅ Apply some useful hacks, like how to get rid of empty rows, duplicate headers, etc.

📝To follow along, make your copy of the practice sheets below:
Destination file: http://bit.ly/practice-imptrng-dest
Source file 1: http://bit.ly/practice-imptrng-sc1
Source file 2: http://bit.ly/practice-imptrng-sc2

📘Read this useful blog post to learn more tricks with IMPORTRANGE: http://bit.ly/blogpost-rw-imptrng

🔌We use Coupler.io (the tool shown at 13:27) to import data between multiple Google Sheets files, as well as from other sources (e.g. Pipedrive, Hubspot, CSV, and many more): http://bit.ly/coupler-rw-imptrng

Timestamps:

• 0:00 Why transferring data manually is not the option
• 0:11 What makes the IMPORTRANGE function so useful
• 0:44 How to use the IMPORTRANGE function (basic example)
• 1:53 Transfer data from a specific tab
• 2:29 Make sure the updated data is transferred automatically
• 3:16 Transfer data between multiple spreadsheets
• 4:39 Importing from two unlimited ranges
• 4:59 Get rid of empty rows
• 5:59 Get rid of repeated headers
• 6:33 Transfer data within the same file (between the tabs)
• 7:23 Import the totals (IMPORTRANGE and SUM functions)
• 8:32 Import filtered data (IMPORTRANGE and QUERY functions)
• 12:05 IMPORTRANGE errors and how to fix them
• 13:26 How to use the Gsheets importer (Coupler.io)
• 14:12 Summary

We’d love to hear from you!🙋‍♀️💬 Share your IMPORTRANGE cases in the comments ⬇️ Make sure to subscribe and hit the bell button 🔔 to learn more Google Sheets tricks coming up soon!

Design and video production: Oleg Gorovoi, Vlad Shagov
Cases: Natalia Gorovaia
Speaker: Karina Plastun

#google-sheets #developer