← Sheets prep

9 / 12 ⏱ 18 minutes

Sharing with a teacher — view only

How to send an invite by email without opening it to the whole class.

The Share button top right opens a door into the workbook. You can invite a specific email of a teacher. They will see the spreadsheet. You decide if they may edit, or only view.

For homework with grades you usually want view. The teacher sees, you can still change. If you give “edit” by mistake, they can delete a row — or a classmate with the link too.

⚠️

Never “Anyone with the link can edit” on a workbook with grades and pocket money. The link leaks into a chat. Someone changes a cell “as a joke”. View only is safer.

التحضيرare the workbook before sharing

  1. Open Tables with Martin. Check the workbook name at the top.

  2. Sheet Grades has headings. Sheet ملاحظةs does not have to be seen by the teacher — you can leave it, the teacher opens the whole workbook. Sensitive things rather into another workbook.

  3. Click Share.

Invite the teacher — view only

  1. In the “Add people” field type the teacher’s email (school @…). Not the whole class.

  2. On the right of the name pick Viewer. Not Editor.

  3. Optionally type a message: “Spreadsheet homework.”

  4. إرسال. The teacher gets mail with a link.

💡

If the teacher does not have Gmail, the invite still works — they open the workbook after signing into their Google account or school account. Ask which email they use for Drive.

At the top of the Share window:

Check: under the workbook name in Share there must be restricted access. The teacher is in the list with the role Viewer.

What the teacher will see

A viewer sees cells, sheets, charts. They cannot write into cells (Sheets will not let them). They can download a PDF, if you allow it in settings — usually it is enough that they see it online.

You can still edit. A grade change refreshes for the teacher after a moment — they refresh the page if they do not see the new number.

In Excel on OneDrive it is similar Share with “Can view” / “Can edit”.

🏫 Grade average One sheet, two columns: subject and grade. At the bottom a sum and an average.
💰 Pocket money Rows = days, columns = income / spend / left.
📊 Class survey One question, answers in one column, later a chart.
🏆 Mini dashboard Three numbers at the top and one chart. Numbers as a link, not copied by hand.

Now you 💪

Do not send anything until the teacher says an email. Just practise the window:

  1. Open Share. Access is restricted, not “anyone with the link”.
  2. You know where Viewer vs Editor is chosen.
  3. In the list there is no random classmate with edit rights.
  4. When the teacher gets the invite, you can still write into cells.

When the teacher gives an email: send with Viewer. Check with them that they see the workbook.

Check: You can set sharing for a specific email with view-only rights. You know why not “anyone can edit”.

What to take from this lesson