Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

I keep sensitive customer or staff data in Google Sheets and I am unsure who can see it

Short answer

Check Share to see exactly who has access and in which role. Google states that protected ranges are not a security measure and that hidden sheets can still be reached by viewers, so do not rely on either for confidential data. Remove people who do not need access, and keep truly sensitive records out of shared sheets.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • I do not know everyone who has the link or access.
  • A sheet with salaries, IDs or customer details is shared with the whole team.
  • I hid a tab or column and assumed it was private.
  • Former staff or contractors may still have access.
  • Viewers can download or copy the whole file.

Why does this happen?

  1. Sharing accumulates

    Google lets you share with specific people or groups as Editor, Commenter or Viewer. Over time new people are added and old ones are never removed, so the list grows.

  2. Hiding is not protection

    Google states that hiding a sheet is not protection: editors can unhide it, and viewers can still access its content, including by making a copy and unhiding the sheets there.

  3. Protecting is not security

    Google states that protection is not a security measure, people can still print, copy, paste and import or export copies, and a range cannot be password-protected.

  4. Download, copy and print

    Google offers a setting for who may download, copy and print. If it is not changed, people with access can take the data out.

  5. Sheets are used for things they were not meant for

    Salaries, ID numbers, health notes or login details are pasted into a sheet because it is convenient. One shared file then exposes all of it at once.

What can I do about it today?

  1. Open Share and read the listFor each sensitive sheet, list every person and group and their role. Note anyone you do not recognise.
  2. Remove or downgrade accessChange people who only need to look to Viewer, and remove people who have left. This is reversible, since you can add them again.
  3. Turn off download, copy and print for viewers where suitableIn the Share settings, uncheck the option allowing viewers and commenters to download, copy and print.
  4. Set an end date for temporary accessFor contractors, use Add expiration beside the person's name.
  5. Stop adding sensitive dataDo not paste payment details, IDs or passwords into a sheet. Move existing ones out once you have a safe place.

When should I bring someone in?

  • The sheet holds regulated or very sensitive data.
  • You think someone outside the company had access.
  • Different people need to see different rows and you cannot split the data cleanly.

How do I handle it?

  1. Find what is sensitiveI list the fields that matter, such as IDs, salaries and contact details, and where each is stored.
  2. Split the file by audienceData that only a few people need goes to its own file, and others receive a summary without personal details.
  3. Set roles and settingsAccess is limited to named people, expiry is added and download settings are tightened.
  4. Move records that need real access controlPer-record permissions need software with accounts and roles, so I plan that move for the data that needs it.
  5. Record the decisionsYou get a short list of who has access and why. Legal duties remain a matter for your lawyer.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Is a sheet with a link and no sign-in private?

Not necessarily. Check the Share dialog for who can open it, and use named people for anything confidential.

Can I stop someone copying data they can see?

Settings can limit download, copy and print, but Google says protected content can still be copied by some routes. Do not share what must not leave.

Is this legal advice?

No. For data protection obligations ask a qualified lawyer.

Sources

How was this page made?

I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.