Skip to content
Tutorials Center
My learning

Topics

Lesson 1 of 29 ยท Getting Started

What Is Google Sheets?

Learn what Google Sheets is, how a spreadsheet is built from cells, rows, columns and tabs, how files live in Drive, and how Sheets compares with Excel.

A spreadsheet is a grid of boxes in which you keep numbers, text and dates, and in which any box can calculate its value from other boxes. Change one input and every result that depends on it updates by itself. That one idea powers budgets, grade books, invoices, inventories and the dashboards people show in meetings.

Google Sheets is Google's spreadsheet program. It runs in a web browser (and in mobile apps), saves every change automatically to your Google Drive, and lets many people edit the same file at the same time. You need no installation and no "Save" button. In this lesson you will learn the vocabulary the rest of the tutorial relies on: cells, rows, columns, ranges, tabs, files, sharing and how Sheets differs from Excel.

Google Sheets is a web product, so it cannot run inside this page. The screens are described in words, and every lesson adds small stand-ins (JavaScript you can edit) that reproduce the idea behind a feature. Each lesson says clearly what is the real product and what is the stand-in.

The building blocks

Four words explain the grid

Cell One box. It holds a value or a formula.
Row A horizontal line of cells, numbered 1, 2, 3.
Column A vertical line of cells, lettered A, B, C.
Tab One sheet inside the file.
1 / 2

Cells and addresses

Every cell has an address made of its column letter followed by its row number. The cell in column B, row 3 is B3. The address is how formulas point at data, so reading addresses fluently is the first real skill in Sheets.

A group of neighbouring cells is a range, written as the first and last cell with a colon between them. A1:C3 is the block of nine cells covering columns A to C and rows 1 to 3. B:B means the whole of column B, and 2:2 means the whole of row 2.

A new sheet starts with 1,000 rows and 26 columns (A to Z), and you can add more. A spreadsheet can hold up to 10 million cells in total, and columns can run as far as ZZZ, which is column 18,278. After Z the letters carry over like the digits of a counter: AA follows Z, and AAA follows ZZ. The stand-in below does that arithmetic.

JS Column letters are a base-26 counter

Press Run (or Ctrl + Enter) to see the console output here.

No output.

This is a stand-in written for the lesson. Sheets does the same conversion internally, but you never see it.

Values and formulas

A cell holds either a value you typed (a number, some text, a date, TRUE) or a formula, which starts with an equals sign, such as =B2*C2. The cell then displays the formula's result while the formula itself shows in the formula bar. You will write your first ones in Your First Formulas.

Tabs: several sheets in one file

The strip at the bottom of the window shows sheet tabs. A spreadsheet is a file that contains one or more sheets, and a formula in one sheet can read cells from another. A common layout is one tab for raw data, one for calculations and one for a summary. You can rename a tab, color it, reorder it by dragging, duplicate it or hide it. The details are in A Tour of the Interface.

The next stand-in models a spreadsheet as a set of named tabs, each one a map from address to value. It is a small model of what the real file stores, not Google's actual file format.

JS A spreadsheet as tabs of cells

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Notice that an empty cell simply has no entry. Sheets behaves the same way, and empty cells count as zero in arithmetic but are skipped by many functions.

Files, Drive and sharing

When you create a spreadsheet at sheets.new or from Drive with New > Google Sheets, you get a file in your Drive. Everything you type is saved continuously, and version history keeps earlier states so you can look back (see Sharing, Comments and Version History). A few practical facts:

  • Sharing uses the Share button. You invite people by email or create a link, and give each person a role: Viewer (read only), Commenter (read and comment) or Editor (change anything).
  • Several people can edit at once. Each person's cursor appears in their own color, so you see who is where.
  • Offline use is possible after you turn it on in Drive settings, and edits sync when you reconnect. Treat it as a convenience and check it works before you depend on it.
  • Files can be downloaded as Excel (.xlsx), CSV, PDF and other formats from File > Download, and Sheets can open Excel files.

Give every file a clear name the moment you create it. "Untitled spreadsheet (14)" becomes impossible to find after a month. Click the title at the top left to rename.

Google Sheets and Excel

Sheets and Microsoft Excel share the same core: cells, formulas, functions such as SUM and IF, charts and pivot tables. If you know one, most of the other transfers. The differences are mainly about where and how you work.

Topic Google Sheets Excel
Where it runs In the browser and mobile apps Desktop app, plus a web version
Saving Automatic, in Drive Manual or AutoSave for cloud files
Collaboration Built in from the start Available for files kept in the cloud
Large data and heavy analysis Fine for everyday sizes; slows down with very large files Stronger for big data models
Unique functions QUERY, IMPORTRANGE, GOOGLEFINANCE, ARRAYFORMULA Power Query, Power Pivot, many more built-ins
Automation Google Apps Script (JavaScript) VBA and Office Scripts

Neither is "better" for everything. Sheets shines when several people share live data and when you want connections to other Google tools. This tutorial teaches Sheets, and many formulas also work in Excel with little or no change.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which address refers to the cell in column C, row 5?

    An address is the column letter followed by the row number, so column C and row 5 is C5.
  2. 2. What does the range A1:B3 contain?

    A range covers the block between its two corners. Two columns times three rows is six cells.
  3. 3. Where does Google Sheets save your file?

    Sheets saves each change as you type, and the file lives in your Drive.
  4. 4. Which sharing role lets a person read a file and leave comments but not edit it?

    Commenter can read and comment. Viewer can only read, and Editor can change the content.

Summary

  • A spreadsheet is a grid of cells; each cell has an address such as B3, and a range such as A1:C3 covers a block.
  • A cell holds a value or a formula that starts with =.
  • A file contains one or more tabs, and formulas can read across tabs.
  • Sheets saves automatically to Drive, and sharing gives people Viewer, Commenter or Editor access.
  • Sheets and Excel share the core ideas; they differ in collaboration, size limits and automation tools.

Next: A Tour of the Interface