How to get (Import) data form one google sheet to another

 How to get data from one google sheet to another 

Hi, Friends through this article going to teach you how to get data from one google sheet to another google sheet.

Let's get started, let's take one example google sheet with example data. Name is taking, "one google sheet". 

And copy sheet address from address bar for putting in formula.

Put this formula where you want to import data. and select the range according to you. After putting this formula excel and When you place your cursor over the formula cell excel will ask you for permission. After that click on "Allow Access".

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O9q6nWmUm9Hc52xVo0Wz1q2IW03EkO-8pJmWqKpnPaU/edit#gid=0","maindata!A:C")

After putting importance formula successfully you will get all the data from a selected range.

IF you want to get any help please comment below. 
Thanks for reading this blog and learn something new.