How to share a Google Sheet with Someone - 5 Ways

[@lorrishafer5763]

GREAT video! Thanks! As a bonus, I would add that when you chose the "Publish to Web" option, before you click "Publish", go to "Published content & settings" drop down list and click "Automatically republish when changes are made" if desired.

[@saperis]

Great tip! 😀

[@nadianadia4655]

one of the best youtubers ...very clear and easy to understand..thank you💌

[@saperis]

Wow, thank you!

[@sumarnimg]

Thank you, this is the best and most useful video on sharing google sheets I've seen

[@saperis]

Glad it was helpful! 😃

[@financial84]

Very very good. Thank you.

[@saperis]

Glad you liked it!

[@ribierahmadalkeni8453]

Thanks to all apps and services provided by Google but actually I'm still not believe that Google doesn't have the PDF editor app and This is the one of the big problems when I want to add any PDF or ask for a signature or add some information or marked inside the Google drive please add this features because it will keep anyone can use it inside the Google drive easily Thank you for reconsider

[@saperis]

Thanks for the feedback. But I'm not Google and I can't add that feature.

[@ItsJusteCommerce]

The publish share feature is everything... thank you for showing us this ;-)

[@saperis]

My pleasure! 😃

[@rakimshahid797]

Thanks for your great content. Im new to sheets. I have created a pricing calculator for HVAC equipment. Its simply calculates the subtotal, taxes and final total for the entered equipment pricing. I would like to share this, not as a shared document, but as individual, stand alone calculators for anyone who has a copy. They should be able to manipulate the fillable cells without affecting anyone else's copy. Is this possible?

[@saperis]

To achieve this, everyone has to copy your document. You can share it with them with "Viewing permissions" and then tell them to make a copy of that document.

[@rakimshahid797]

@@saperis ok, thanks

[@ranelllewis6539]

Hi, thanks for making this tutorial. I have a question about sharing a google file on a FB group. If I add the web link, can I unshare it later? If so, how can I unshare a web link? Does this make sense? Thanks again for your time and attention.

[@saperis]

To share a file with lots of people, like a FB group, you have to choose "Anyone with the link". So anyone who klick on the link has access to the file. Obviously, you're sharing with literally anyone on the internet and not only the FB group. To unshare you change the settings back to "Restricted".

[@AmirAkram-s3j]

*Is it possible to share only one tab of a google sheet with editing permission and not share the whole sheet?) (while staying in the same sheet)*

[@elenabollito3728]

hi! may i ask you how can i make my code in apps script working for the other editors within i've shared my sheed?

[@saperis]

The other editors of the Google Sheet file can run the code themselves. They have access to any Apps Script you have added to the file.

[@quintus5180]

I have a question: if I have once shared an important file with someone, but not do not want them to be able to see this google sheet any more, what must I do? I have removed the person from the sheet, but if the person still has the web-address, he/she can still browse to this URL and see what is happening in the sheet, correct? Thanks in advance!!

[@saperis]

No, luckily it doesn't work that way. If you un-share a file with someone and they try to access it through the link you shared with them, they WON'T have access to the file anymore. Instead they will see a screen letting them know they don't have access and can request it from the file owner. You will receive an email notification and can then choose to share the file again or ignore the request.

[@quintus5180]

@@saperis Thank you for the swift response!

[@jimbob1883]

I would like to know if there is a way when sharing a google spreadsheet that person 1 sets some filters, how can person 2 still see the entire spreadsheet without having person 1's filter impact what person is viewing. Is this possible? How is that accomplished?

[@saperis]

Yes, that is possible. You use the filter view feature for this: support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DDesktop

[@jimbob1883]

@@saperis Thank you for your very kind assistance. This is very helpful. One last question is: Can I hide columns in a shared spreadsheet and not impact others sharing the same spreadsheet?

[@saperis]

@@jimbob1883 No, you would be hiding columns for all users and not only yourself.

[@thelucidumbrella]

Hi maybe mine is a beginner question , How do i send a google sheet to, say 10 people at once individually with their email addresses, but not make their edits affect each others' google sheet?

[@saperis]

Well, you would have to make each person a "viewer" of your original file and then tell them to make their own copy. But then everybody has their individual copy. Or you all are "editor" on the original copy. But that means everyone can edit everything. The type of sharing you want isn't available for Google Sheets.

[@gjone1]

I learned what it looks like when someone has commenter status and makes a comment 👍🏾👍🏾 Thanks

[@saperis]

Yep, that's an important thing to be able to identify in a document.

[@tegustanmisdientes]

How can I resolve a "Can't share" error? The email I want to share with is a Google account. If I try sharing by updating "General access" to "Anyone with the link" and paste the link in my email, an error pops up "This person won't have access to "". This person can't access the file because of its sharing permissions"...the sharing permissions are General Access to Anyone :-(

[@saperis]

Follow the instructions in this Drive support article: support.google.com/drive/answer/2494822?hl=en&co=GENIE.Platform%3DDesktop

[@RoeGabriel_i_EMPOWER]

Hi! I love your videos. They’re very helpful and clear. My only criticism is that the videos I have watched so far have variable sound. Your voice is too soft and music too loud. Not sure if you e fixed that. But just thought I’d mention it. I don’t want anything to take away from your great content

[@saperis]

Thanks for the feedback. I have struggled with getting the sound right in the past. And it's still "work in progress". 😉

[@RoeGabriel_i_EMPOWER]

@@saperis what tech equip are you using? For Music, editing, & voice microphones?

[@saperis]

@@RoeGabriel_i_EMPOWER Screenflow for recording, adding music & editing.

[@RoeGabriel_i_EMPOWER]

@@saperis Hmm I just watched the video tutorial for screenflow and found it's sound was just ok as well. It might be worth your while to investigate further. What Microphone you use, and also if you can audio balance in the program> I dont use that one so I'm not sure. I use iMovie or Adobe premiere but Premiere is only for bigger projects. Its a couple of things - one the balance between the music background and when you're just speaking and also you naturally speak softly so you need a more sensitive microphone to pcik it up. A lapel mike or even a desktop one is good - they come pretty cheap these days. Good luck anyway - I love your stuff - keep putting it out there

[@yunesabdulrab446]

i wanna share sheet to 5 person and i dont wanna each one see other with edit what i will do ?

[@saperis]

Nothing. That's simply not possible. If you make 5 people editors on the same document, they will inevitably see who has access.

[@vastyjean4061]

I’m not able to share at all. It say my filles has flagged because something is inappropriate, how do I change that please?

[@saperis]

Looks like there is some kind of content that has been flagged. There should be further information when you see this type of warning.

[@vastyjean4061]

@@saperis it says “ can’t share item You cannot share this item because it has been flagged as inappropriate “ I don’t how I would be able to unflagged it so I can share it.

[@saperis]

@@vastyjean4061 Found this article that might be helpful: support.google.com/drive/answer/2463328?hl=en

[@edwinalansilvatorres544]

Thanks

[@saperis]

Welcome 😀