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 from 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 totals (IMPORTRANGE and SUM functions)
8:32 Apply conditions to filter 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

#Importrange # Importrangefunction #ImportrangeGoogleSheets #ImportrangeQuery #ImportrangeError #ImportrangeExcel #ImportrangeFormula #importrangeInternalError