Link from another file in Google Sheets in 2 mins

In Google Sheets, you cannot link two files (two separate spreadsheet documents) as easily as Excel but you do it through a function which imports a range of cells in a more secure way than Excel and it updates live. Use the function =IMPORTRANGE("file link","sheet name!Start cell:End cell"). Where you must physically type the special characters exactly as shown "!: but if something is written in the cell you don’t need to use speech marks " around it. I show what sort of things can go wrong as well and how to fix it.

[skins]

I have been searching for how to enter a file location into a cell in google sheets and every video and blog post has absolutely nothing to do with my request. Is it always this difficult to get answers out of google? It use to be so great and now it is a POS!!!! Your video was a the top of my last search results. I like how quickly you get to the point but unfortunately it is the wrong point.

[himalayanKite]

So quick to the subject. The best presenter of the stuff. without wasting any time. thumbs up

[chinhvd]

Liked! Very straight to the point. I love it! thank you!

[nicolaspeteuil]

Very useful! Please do more videos about Google Sheets!

[AngelMatsanov]

Thanks a lot for this information, David! You are awesome!

[TouhidulIslam]

You saved my hour of works. Thanks man!

[eliastouil]

=IMPORTRANGE("file link", "sheet name!Start cell:End cell")

[jonahbollinger]

This is the best video I have seen on this subject. Thank you.

[mrstardhi]

do u know why it a like still loading to have access, after pressing allow access, but i feel like they are not accessible, it stay 'adding permission' loading,

[deareeMusic]

what if the spreadsheet rows you want to link move from sheet to sheet, is there something I can put in those sections to link to a group of cells regardless of the vertical position on the spreadsheet that I am linking?

[yesegodoy]

This was awesome. Thank you so much for providing a concise answer to our question.

[Gerome_Collab]

Very helpful in monitoring progress from multiple sheets. Thank you!

[Fllxers]

How do you get it to also copy the formatting from the master spreadsheet to the other spreadsheet?

[KirkTe-ptwf]

okay what if the other spreadsheet only allows you to view it, how to give it access

[bardeesalaa]

very very helpful, god bless you
but if you may help with the ref message that I don't have access, i can't find the (allow access) button.. any help regarding this

[Gregoryleejrxyz]

Getting this error even though both files are under my personal email. Is this a bug?

"You don't have permissions to access that spreadsheet."

[lucyjoseph]

Hi, wanna ask if from 2 different GS and want to link it to each other, e.g GS file A link to GS B. If there is additional data add from time to time, how to ensure GS B will auto added as well?
pls help

[mr_shanes]

good tutorial, however "link" would be a misnomer, the files are not linked (as would be done with the fileID), only shows how to get the data automatically imported from a range.

[tinhunold]

First cell and linking works but after I try to connect another sheet right below the cell that is working, the sheet that is working fails and it says. "Array result was not expanded because it would overwrite data"

[ravi]

Hey thanks for this but in my sheet it's only show loading