Import Data from Another Spreadsheet | IMPORTRANGE Function in Google Sheets in Hindi

[@ranjitalbert3054]

Excellent explanation, Thanks

[@TenPowerTen]

Glad you liked it Thank You.

[@_akashfitnessclub_]

Sir ek question hai.. please reply krna...agr muje sheet me likhi koi same city ka data import krna h toh kaise kr skte h

[@_akashfitnessclub_]

I mean ki me chahta hu ki sirf isi city ka data hi import ho

[@TenPowerTen]

Use Query function with importrange. You can watch videos from this channel list in this channel. Query Function in Google Sheets in Hindi. Thank you.

[@mohitjangra6374]

Sir kya ham isme selected cell ka data bi le sakte hai kya importrange se

[@akshaysinha9059]

How can we get the format(format conditioning in that sheet) along with the data?

[@TenPowerTen]

We can not import including formatting with importrange function not possible till date. You can use Copy To method to copy data including format then delete data before using importrange function.

[@rawatpahadi556]

Importrange use krne ke baad jo file upload hogi us me changes kt skte haa

[@TenPowerTen]

Rawatpahadi Ji bilkul change kar sakte ho. jo change hoga apke souce file me wo change hogayega apke destination file mein. Thank you.

[@rawatpahadi556]

@@TenPowerTen nhi sir souce file me change nhi krna, agar importrange kr ke jo file upload hui ha us me hum ne remark update krna ha to wo kese hoga

[@kawsarhamid5654]

Excellent

[@TenPowerTen]

Thank you so much 😀

[@r20g88]

Hi, Is there is video available where we can copy formatting of the cell from original sheet (like color coding, text type etc)

[@TenPowerTen]

Please watch this video, you can get idea. kzbin.info/www/bejne/j4GzZ2RrmrZ8bqM

[@manishsrivastava6203]

What to do if the excel file is in hindi font and import to google sheet without changing font.

[@deepcloud47]

How many sheet's data can be import by importrange function, any limits?

[@TenPowerTen]

Max of 50 cross-spreadsheet reference formulas and it may be up and down depend on google Team. Don't worry about limit. We can use importrange function more than 500 spreadsheets with other tricks. May be make video on this trick in near future. Thanks, Team *Ten Power Ten*

[@deepcloud47]

@@TenPowerTen thanks Please make a video soon.

[@deepcloud47]

If possible please make video in this week.

[@krishnasingh926]

🙏👌👌👌

[@TenPowerTen]

Thank you.

[@MuhammadZubair-yd9rc]

Allow permission is not appearing, formula is ok, shows you have not permission to that sheet although both sheets owned by me

[@muhammadabrar9948]

I am stuck in "Adding Permission" please help

[@TenPowerTen]

Please watch below video mentioned in details: kzbin.info/www/bejne/oqTHZZqHmtZjm9U If u still stuck then you can contact by email which is given in about section. Thank you.

[@dipaksingh1751]

Sir Importange Mai duplicate nahi aana chya....

[@TenPowerTen]

Thanks for your comments. What type of data you want to import multi column or single column? For unique value just use unique Function. UNIQUE(IMPORTRANGE("url","Range"). For single column work fine. In multiple column if entire column identical then import unique values with above same formula. Thanks. Ten Power Ten Team

[@RaviKumar-cf7gk]

Agar 1 sheet delete huaa to 2 dusra automatically delete ho jayegaa

[@TenPowerTen]

Yes, Dynamically rakhte hai to. Agar one time chahiye to Paste as Values kar sakte hai.

[@avanishchandra3795]

Please Thora zoom kar ke vedio banao dikh nahi raha hai

[@TenPowerTen]

Ok, new videos are with zoom focus. Thanks,

[@praveengoyal330]

Sir, maine formula sahi lagaya h. par data fetch nahi ho raha h. 9887901642

[@TenPowerTen]

Please follow all steps in video. =IMPORTRANGE(spreadsheet_url, range_string) Points to note!: 1. Another Spreadsheet must you have access. 2. url in Double Quotes "url" then use comma. 3. range string in double quotes including sheet name. 4. After sheet name must use exclamation mark (!) then range. I hope will work successfully. if again some issue you can email me, I will help personally. Email id is found in channel's about page.