Google Sheets - Protect or Totally Hide Data Using IMPORTRANGE

It is easy to protect certain cells or worksheets from editing. However, in this tutorial, we will review how to totally hide confidential data while allowing users to see a summarized version without the sensitive data. This prevents the data from being modified but also prevents it from being viewed.
Link to the example sheet with the IMPORTRANGE formula: bit.ly/import-range
Written version of this video: sheetshelp.com/hide-data/
More information on IMPORTRANGE: sheetshelp.com/importrange/
Learn more from Prolific Oaktree:
🌳 Next Video - Spreadsheets 3.0 - • Beyond Sheets and Exce...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-tutorials
Timestamps:
0:00 General Setup
1:37 Setup for this spreadsheet
3:34 IMPORTRANGE function
5:52 Security consideration
7:14 Next: Pivot Table Playlist
#googlesheets #IMPORTRANGE

[@user-gb1ju5oj5m]

hello dear, how I can also allow the people who share with them the specific sheet to edit also the sheet, not only see, when the another man edit or clear any data, there is error message showing for him

[@amosmurigu7463]

hi @Prolific Oaktree i had a question how to you synch two google sheets in such a way that if you update sheet A, it automaticaly gets updated in sheet B and aslo vice versar .

[@arunku83]

ruclips.net/video/ys1YOBlfKTM/видео.html

[@arunku83]

This will sync your data too

[@johnmecham9855]

@@arunku83 Can you please explain how two-way syncing is possible. I've spent hours trying figure this out, and can't.

[@srisri-tx4fd]

hi, if the end user copy and paste the importrange url in a seperate brower windows
, then he will be able to access all the tabs, whats the solutionf or this.pls advise

[@ProlificOaktree]

Don't give them permissions to that file.

[@rattanaknuonsinoeun6211]

I use import range and do the summary in other sheet ,but it can not load the data from the sheet of data entry, how can you solve this?

[@ProlificOaktree]

You may want to try it again and be sure you grant permission when you get the pop up.

[@stephensloan7878]

Amos Murigu, I have been trying to find out the same thing. What I've found so far is the parent sheet can change and will show up on the child sheet but not the other way around. But what I'm really trying to find out is, we have a file with 20 plus tabs/sheets. We want to share with different vendors. Some of those vendors need to add info into the sheet. But we don't want vendors to see the tabs that don't pertain to them. How can we hide those tabs. I know we can protect them but I don't want them to have viewing access to all tabs.

[@rafiqunnabi4353]

Same issue i am facing. Following

[@ProlificOaktree]

You can't do that in the same sheet. There's is no way to restrict viewing by worksheet.

[@husnayahaya8546]

One of the way is to always hide the sheet. Then only the other vendors cannot view sheets that are not pertained to them. I've been trying to do the same thing, and the only thing I can do is to emphasize them to always hide their sheet.

[@stephensloan7878]

@@husnayahaya8546 I agree but if they know where to look, they can still see the hidden sheets. So far, the only way is to keep separate files.

[@exanimumque]

Hello.
I have a list of data. I dont want people to see the entire list, they can search for keywords and that'll bring up the lists containing the keywords. How do I hide the entire list from plain view, and only show data once keywords have been typed in?

[@ProlificOaktree]

Aside from using App Script, which I don’t now much about, I can’t think of a way to do this.

[@ed3m1r]

When sharing publicly a spreadsheet you can create a TAB called SOURCE and HIDE it so others with public link will not know your source spreadsheet URL. this way SOURCE TAB It will not be available for reading for people with link. After that you can pull data from that tab in other tabs.

[@jkatqc]

Is there a way to hide the formula bar in the public sheet so users can't see the source sheet url?

[@ProlificOaktree]

Not that I know of.

[@GuiCarminati]

@@ProlificOaktree What I often do to prevent them from seeing or messing with the formula is to put it in the topmost row, protect the range for that first row and then hide it. In the source sheet, I make sure to leave an empty row on the top as well and in the IMPORTRANGE formula I just consider one extra row. For example, if the data I want to mirror to the view sheet is A1:C5 in the source sheet, I add an extra row on top (now the data is in A2:C6) and in the destination sheet I add =IMPORTRANGE(sheet_id, "A1:C6"), the data will start showing in row 2 but it won't matter because row 1:1 will be hidden (and protected so that no one can unhide it except you).
You could also just leave the destination sheet view only for everyone except you, this way they cannot view or edit any formulas. But if you need them to edit as well this is the option that I come up with and often use.