Build and share spreadsheets with PGB Sheets

PGB Sheets is the spreadsheet app in Sheets. It handles the everyday jobs: tables, formulas and sharing a live sheet with your team.

Create a spreadsheet

1. Open Sheets.
2. Choose Start from scratch or a template under Start a spreadsheet.
3. Click the title at the top of the page to name it.

You can also use New, Spreadsheet from Drive.

Edit together

When live editing is available, everyone with edit access can edit at the same time and sees the others' changes as they happen. The page footer tells you which mode you are in:

• "Everyone with edit access can edit at the same time."
• "One person edits at a time; others follow along live." In this mode, finish with Done editing to save and let someone else edit.

The status next to the title shows whether your work is Saved, Saving, Connecting or has Unsaved changes. People with view access see Viewing or View only.

Share a sheet

If you own the sheet or have permission, choose Share at the top right. Sharing works like any file: pick people or groups, choose their access level, and optionally allow comments.

Bring data in and out

Open the File menu:

• Import CSV as a new sheet adds a CSV or TSV file as a new sheet. Files can be up to 5 MB.
• Download this sheet as CSV saves the sheet you are on.

Note: To move data in and out of Sheets, use the CSV import and download options.

Version history

Choose Version history in the toolbar to see saved versions. Name an important one with Save version, preview an earlier one, and choose Restore to go back. The current content is kept in the history, so a restore can itself be undone.

Tips

• Keep one header row and one table per sheet so imports and exports stay clean.
• Name a version before a large clean-up.
• Use separate sheets (tabs) for each topic rather than one giant sheet.

Common problems

• "Your access to this spreadsheet has changed. Reload the page." An owner changed your permissions.
• "This spreadsheet doesn't exist, or you don't have access to it." Ask the owner to share it again.
• I cannot edit. You have view-only access, or someone else is editing in one-person mode. Wait for them to choose Done editing.
• "That file is larger than 5 MB." Split the CSV into parts.