Real-time co-editing in Google Sheets - Step-by-Step Guide

Introduction

Real-time co-editing lets multiple people work on the same Google Sheet at the same time. Everyone can see changes instantly, which helps teams collaborate without sending files back and forth.

When your team needs to update a budget spreadsheet together during a meeting

When multiple people are entering data into a shared inventory list simultaneously

When you want to review and edit a project plan with your coworkers in real time

When teachers and students collaborate on a class assignment spreadsheet

When you need instant feedback on data changes from your manager or client

Steps

Step 1: Open

- Google Sheets homepage or your Google Drive

You see your list of spreadsheets and can select one to share

Step 2: Click

- the Share button at the top right of the open spreadsheet

A sharing dialog box appears where you can add people

Step 3: Type

- email addresses or names of people you want to share with in the sharing dialog

The people you add appear in the list with sharing permissions

Step 4: Select

- the permission level dropdown next to each person (Viewer, Commenter, Editor)

You set who can edit or just view the spreadsheet

Step 5: Click

- Send button in the sharing dialog

Invitations are sent and collaborators can open the sheet to start editing

Step 6: Watch

- the spreadsheet while collaborators make changes

You see their cursors and edits appear instantly in different colors

Before vs After

Before

Only the owner can edit the spreadsheet; others cannot see changes live

After

Multiple collaborators edit the spreadsheet simultaneously; all see changes instantly with colored cursors

Settings Reference

Sharing permissions

📍 Share dialog box at top right

Controls what collaborators can do in the spreadsheet

Default: Editor for owner

Link sharing

📍 Share dialog under 'Get link'

Controls who can access the sheet via a shared link

Default: Restricted

Common Mistakes

Not setting collaborator permissions correctly

People may only view the sheet and cannot make edits if set as Viewer

Set permission to Editor for those who need to make changes

Sharing the wrong link type

If link sharing is set to Restricted, invited users may not access the sheet

Use 'Anyone with the link' if you want to allow access without sign-in, but be careful with privacy

Summary

Real-time co-editing lets multiple users work on the same Google Sheet at once.

You share the sheet by clicking the Share button and adding collaborators with Editor permission.

All edits appear instantly with colored cursors showing who is editing where.