Google Sheets is a free spreadsheet app that runs in your browser. You can use it to make lists, budgets, schedules, trackers and reports, and share them with your team in seconds. This guide takes you from a blank sheet to confident everyday use.
What you need
- A free Google account (Gmail), or a Google Workspace work account
- A web browser, or the Google Sheets app on your phone
Go to sheets.google.com and click Blank spreadsheet. That’s it. Everything saves automatically to Google Drive.
The basics: what you see on screen
| Part | What it is |
|---|---|
| Cell | One box, named by its column letter and row number, e.g. B3 |
| Range | A group of cells, e.g. A2:A10 |
| Sheet (tab) | One page at the bottom. A file can have many tabs. |
| Formula bar | Shows what’s really inside the selected cell |
| Toolbar | Formatting, borders, colors, charts and more |
Step 1: Enter and organize data
- Put headers in row 1 (e.g. Date, Item, Amount) and one record per row.
- Press Enter to move down and Tab to move right.
- Drag the small square at the bottom-right of a cell (the fill handle) to fill a series like 1, 2, 3 or Jan, Feb, Mar.
- Freeze the header row: View → Freeze → 1 row. See how to freeze rows.
Step 2: Your first formulas
Every formula starts with =. Try these:
| Formula | What it does |
|---|---|
=SUM(C2:C20) |
Adds up the numbers |
=AVERAGE(C2:C20) |
Average |
=COUNTA(A2:A20) |
Counts filled cells |
=MAX(C2:C20) / =MIN(C2:C20) |
Largest / smallest |
=C2*D2 |
Multiplies two cells |
=IF(C2>100,"Big","Small") |
Shows one result or another. See IF, AND and OR. |
=SUMIF(B:B,"Food",C:C) |
Totals only one category. See SUMIFS and COUNTIFS. |
Copy a formula down by dragging the fill handle. To keep a reference fixed while copying, add dollar signs: $E$1. See absolute vs relative references.
Step 3: Format to make it readable
- Bold headers and a light fill color.
- Number formats: Format → Number → Currency, Percent or Date.
- Alternating colors: Format → Alternating colors.
- Conditional formatting: Format → Conditional formatting, e.g. turn overdue dates red. See conditional formatting examples.
- Drop-down lists: Insert → Drop-down. See drop-down lists.
Step 4: Sort, filter and find
- Sort: select your data → Data → Sort range (tick “Data has header row”).
- Filter: Data → Create a filter, then use the arrows in the header row.
- Find and replace: Ctrl + H.
Step 5: Make a chart
Select your data and click Insert → Chart. Google Sheets suggests a chart type, which you can change in the Chart editor on the right. See how to make charts that look good.
Step 6: Share and work together
- Click Share (top right).
- Add people’s emails and choose Viewer, Commenter or Editor.
- Everyone sees changes live. Add comments with Ctrl + Alt + M.
Made a mistake? File → Version history lets you restore any earlier version. Learn more in how to share a Google Sheet safely.
Step 7: Work offline and on your phone
- Install the Google Sheets app for Android or iPhone.
- For offline work on a computer, turn on offline access in Google Drive settings (Chrome or Edge).
Google Sheets superpowers
Once you’re comfortable, try the features Excel doesn’t have in the same way:
- QUERY: build reports with simple SQL-like commands
- IMPORTRANGE: pull data from another spreadsheet
=GOOGLETRANSLATE(A2,"en","ar"): translate cells- Gemini in Sheets: ask AI for formulas and summaries
- Google Forms: collect answers straight into a sheet
Keep our free Google Sheets formulas cheat sheet next to you while you learn.
Google Sheets or Excel?
Google Sheets is free, browser-based and great for sharing. Excel is stronger for very large files and advanced analysis. Many people use both. See Google Sheets vs Excel.
Start with a free template
The fastest way to learn is to use a ready-made sheet. Download a budget, weekly planner or expense tracker, then open it in Google Sheets with File → Import → Upload.
FAQ
Is Google Sheets free?
Yes. Google Sheets is free with a Google account. Businesses can also use it as part of a paid Google Workspace plan with extra storage and admin controls.
Can I open Excel files in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it, or use File → Import in Google Sheets. Most formulas and formatting carry over.
Does Google Sheets save automatically?
Yes. Every change saves to Google Drive as you type, and File → Version history lets you go back to earlier versions.
How do I learn Google Sheets fast?
Start with one real task, like a budget or a to-do list. Learn SUM, IF and SUMIF, then sorting, filtering and sharing. Use a cheat sheet and templates to practice.