Sharing a spreadsheet safely with your team
Spreadsheets end up holding some of the most sensitive information a small business has: customer phone numbers, bank details, salaries, supplier rates, Aadhaar or PAN numbers collected for paperwork. Online sheets make teamwork easy, but a single careless share can expose all of it. This article gives a simple routine for sharing any online spreadsheet with the right people and nobody else.
Before you share: decide what the person needs
Ask two questions for each person: What do they need to see? and Do they need to change anything? A delivery boy needs today’s addresses, not your profit margins. Your CA needs the sales and expense figures, not your customer list. The answers decide what you share and how.
Step-by-step routine
- Split sensitive data out. Keep salaries, bank details and ID numbers on a separate workbook that only you and, if needed, one trusted person can open. Sharing settings usually apply to a whole workbook, so hiding a tab or a column is not a security measure.
- Make a sharing copy if needed. If someone needs only part of the data, copy just those columns into a new workbook and share that.
- Share with named people. Add each person by their own account rather than posting a link in a group. You then know exactly who has access.
- Choose the lowest access that works. Give view access by default; give edit only to people who must update the figures.
- Use read-only links carefully. A link that “anyone with the link” can open is convenient, but it can be forwarded. Use it only for information you would be comfortable seeing in public.
- Tell people the rules. A one-line note at the top of the sheet — “Do not download or forward” — sets expectations.
- Review access every month and immediately when someone leaves. Remove anyone who no longer needs it.
Worked example: a small distributor
Jaspreet runs a distribution business with three salespeople and an outside CA. Her master workbook has customers, outstanding balances, purchase rates and staff commission. She now keeps:
- “Master – private”: everything, shared with nobody.
- “Route list”: customer name, area, phone and balance due — shared with the three salespeople with edit access so they can mark collections.
- “Monthly figures for CA”: sales, purchases and expenses totals — view access for the CA, refreshed each month.
When one salesperson left, she removed him from “Route list” the same day. He never had purchase rates or commission figures in the first place.
Edit access without chaos
- Put clear headings in the first row and do not let others move or rename them.
- Use dropdowns for columns like Status so everyone writes the same values.
- Ask people to use comments for questions instead of overwriting a number.
- Agree who updates which column or tab.
- Check what changed before relying on totals after a busy day.
Personal data: be extra careful
Collect only the personal information you really need. If you must store ID numbers, keep them in the private workbook and consider recording only the last four digits elsewhere. Do not paste customer lists into public chat groups. India’s data protection law expects organisations to protect personal data they hold; a simple “need to know” routine is a sensible start.
When someone leaves or a phone is lost
Remove the person’s access the same day, before you do anything else. If a team phone that was signed in is lost, sign that account out from another device if the app allows it, change the password, and check what the phone could open. Afterwards, look at recent changes in the shared sheets for anything unexpected. Keeping a short list of “who has access to what” makes this a five-minute job instead of a guessing game.
Common mistakes
- Sharing the master file because “it’s quicker”.
- Posting an edit link in a large group chat.
- Hiding a column and assuming it is private.
- Former staff still having access months later.
- Downloading a copy to a shared computer and forgetting it in the Downloads folder.
Doing this in C Sheet
In C Sheet, open File → Share to add people and choose their access. A guest link opens the workbook read-only. Dropdowns, comments and filters help keep shared sheets tidy. The same principles apply to documents in C Docs.
Frequently asked questions
Is a view-only link safe?
It prevents changes, not copying. Anyone who can view can read and copy the data, so share only what they may see.
Should I password-protect a downloaded file instead?
Passwords on downloaded files help, but files get forwarded with their passwords. Named access in an online sheet is easier to control and to revoke.
How often should I review access?
Monthly, and whenever someone joins or leaves.