Spreadsheets

Viewer, commenter or editor: sharing a Sheet with family or CA

What viewer, commenter and editor can really do in Google Sheets, link versus named sharing, and which role suits a spouse, a parent and a CA.

Editorial illustration for Viewer, commenter or editor: sharing a Sheet with family or CA

In Google Sheets, a viewer can only look, a commenter can look and leave comments, and an editor can change the data. Give a spouse who logs spending editor access, a parent who only wants to see the numbers viewer access, and a CA who will review and ask questions commenter access, unless they need to enter figures.

What can each role do in practice?

RoleCan doCannot do
ViewerOpen and read every tab they can see; usually copy, print or download unless you turn that offEdit cells, comment, or change who has access
CommenterEverything a viewer can, plus add comments and suggestions on cellsChange the data itself
EditorChange cells, add and delete rows and tabs, and by default change who has accessTake ownership away from you

The owner is the person who created the file. Owners can change anything, including removing other people's access. Ownership can be transferred, but that is a deliberate step, not something a role does by accident.

Yes, and the difference matters more than the role.

  • Named person: you type their email, pick a role, and only that Google account gets in. You can see who has access in the Share box.
  • Anyone with the link: whoever holds the link gets the role you chose, whether or not they are signed in. If it is forwarded, the new person gets in too.
  • Restricted: the default when you have not turned link sharing on. Only people you added can open it.

For anything that shows your income, loans or account balances, share with named people and leave link access restricted. A link set to editor for anyone is an open door: with sign-in off, edits can be recorded under anonymous names, which makes it hard to know who changed what.

Which role for a spouse, a parent and a CA?

PersonSuggested roleReason
SpouseEditorLogs spending and fixes entries; you trust each other with the data
Parent, who wants a viewViewerReads totals; no risk of an accidental delete
Parent, who also adds billsEditor on a separate entry tab, if you can arrange itGives them a place to type without the formulas in reach
CA or accountantCommenterCan ask questions on cells without changing your figures; move to editor only if they are meant to correct entries

These are suggestions, not rules. Think about what harm a role can do if someone clicks the wrong thing. A deleted formula column is the usual one, and version history lets you recover it.

Which setting should I check before sharing?

Open the Share box and click the gear icon. Look at the option that lets editors change permissions and share. If it is on, any editor can add more people or change roles. For a sheet with money details, switch it off so only you decide who is in. The same box has an option that lets viewers and commenters see download, print and copy; turn it off if you do not want a copy leaving the file, knowing that someone can still read the screen and type the numbers elsewhere.

How do I send an invite properly?

  1. Click Share, then type the person's email address.
  2. Choose the role from the drop-down next to their name.
  3. Add a short message that says why you are sharing.
  4. Press Send, then check the list of people with access once.
  5. Set a reminder to review the list at the end of each financial year, in April.

When should I remove access?

Take a CA off the list once the filing season is over if they do not need it any more, and remove anyone whose role in your household has changed. Removing a person is a few clicks in the Share box, and you can add them again later.

If you find that sharing a sheet with many people is getting complicated, remember that more people means more places for a mistake. SpendixAI is built around one personal workspace on a single Pro plan, so it suits an individual or a couple who want their own records, not a team that needs approvals.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports