# Google Sheets for realtors on Mac: deal trackers, commission math and help from Lazur

> Google Sheets for realtors on Mac covers deal trackers, commission splits and critical dates. Setup, Excel imports, Mac shortcuts and Lazur help.

URL: https://www.lazur.app/for/realtors/google-sheets
Updated: 2026-11-06

Google Sheets works well for realtors on a Mac. You can track open deals, run commission math, keep critical dates and share one file with your team, all in a browser. This guide covers setup, Excel imports, Mac shortcuts, common mistakes, and what Lazur can do while you work.

## Quick answer

- Start from the Template Gallery or import your Excel tracker. Both open in Google Sheets on your Mac.
- Keep one row per deal, one input cell per rate, and no merged cells in the deal table.
- Press Option + / to find any menu item by name with Tool finder.
- Google's pages disagree on the cell limit. Plan around ten million cells.
- Ask Lazur where a menu item is or what a formula does. It points and explains. It does not click for you.

Most realtors do not need a full deal system on day one. They need a list of open transactions, the price and rate on each one, and a warning when a date is close. Google Sheets handles that job well. It runs in a browser window on your Mac, and you can share the file with an assistant or transaction coordinator in a few clicks.

![Realtor at a desk with a Mac laptop reviewing open deals, the daily work behind Google Sheets for realtors on Mac](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/realtors-google-sheets/google-sheets-for-realtors-on-mac-1-e0fc00.jpg)

## What a Google Sheets real estate tracker does well

The features that matter most are plain. Sharing controls decide who can see and change the file. Revision history lets you go back after a bad paste. Offline access keeps a tracker usable when the signal drops at a listing. Google's product page also says you can open and edit Excel files in Sheets without copying them.

- Co-editing: two people can work in the same file at the same time.
- Sharing controls: choose view or edit access for each person.
- Revision history: open File > Version history > See version history to restore an older version.
- Offline access: keep working without a connection, then let the changes sync.
- Excel without copying: open and edit an .xlsx file in place.
- Connections: Google's page lists third-party links to tools such as HubSpot and Salesforce.
- Gemini features: prompts, Fill with Gemini and formula help. Some need a Workspace plan.

Be careful with the Gemini features. Google says some of them are available only on Google Workspace plans. Google's product page gives no prices, so check Google's pricing page before you plan around them. Set up offline access while you are online, then test it before a showing.

## Google Sheets templates for real estate, or your own Excel file

Templates save the most time. Select Template Gallery at the top right, click a template, and Google opens a copy. The original template is not edited. Some template features work only with work or school accounts, so check the template before you share it with anyone outside your office.

Paperless Pipeline offers a free real estate transaction tracker. It is a 36 KB .xlsx workbook that opens in Excel, Google Sheets or Numbers, with no signup. Its tabs are How to use, Transactions, Critical dates, Contacts and Summary by status. It is a sensible starting point if you have nothing yet.

## Real estate transaction tracker in Google Sheets

Start with three tabs. A deal pipeline tracks each transaction. A critical dates list tracks what is due. A contacts list links people to deals. Keep each tab simple. Each one should answer one question, such as what is open, what is due, or who to call.

### The deal pipeline rules

One row per deal is the rule that saves you later. Put the address, status, agent, client, price, rate, contract date and closing date in separate columns. Do not merge cells in the table. Merged cells get in the way of sorting and filtering, and they make formulas hard to copy down.

| Tab | Columns to keep | Why it helps |
| --- | --- | --- |
| Transactions | Address, status, agent, client, price, rate, contract date, closing date | One row per deal, easy to filter by status |
| Critical dates | Deal reference, task, due date, owner, done | A flag formula shows what is overdue |
| Contacts | Deal reference, name, role, phone, email | Ties people to a deal, not to a loose note |
| Summary | Count and total by status | A quick view for your weekly review |

_Tab layout based on the free Paperless Pipeline tracker, adapted for Sheets._

### Set a status dropdown

Free text makes filters fail. Select the status column, then go to Data > Data validation and choose a dropdown list. Type the status names you use, such as Active, Pending, Under contract and Closed. Now every row uses the same words, and the summary tab counts them correctly.

Closed deals should stay in the file. Change the status to Closed instead of deleting the row. Then filter the status column to hide closed rows during the week. Once a year, move closed rows into an archive copy of the file. Your totals stay honest, and the working tab stays short.

## Commission split spreadsheet for Google Sheets

Commission problems usually start with the split. Enterprise DNA describes split formulas that break when an agent changes teams in the middle of a deal. It also describes referral fees that get forgotten. Commission data that sits in a CRM, a spreadsheet and accounting at once drifts apart. Keep the rate and the split in their own input cells, then point every formula at them.

A basic gross commission is price times rate. If the price sits in B2 and the rate sits in C2, put =B2*C2 in D2. Put the agent's split in E2 as a percentage. Then put =D2*E2 in F2 for the agent's share. When the split changes, you edit E2 and nothing else.

![Real estate office desk with paperwork, a notebook and a laptop used for tracking closings in a spreadsheet](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/realtors-google-sheets/google-sheets-for-realtors-on-mac-2-318689.jpg)

Add a column for referral fees even if you do not use it yet. A blank column costs nothing. A forgotten referral fee costs real money. Format the rate and split cells with Format > Number > Percent so they read as percentages, not decimals.

> **Lock the math:** Select the commission columns and use Data > Protect sheets and ranges. Give the assistant edit access to the deal rows only. A locked formula is much harder to overwrite by accident.

### Critical dates and follow-ups

A critical date only helps if someone sees it. Add a flag column next to the due date. If the closing date sits in G2 and the status sits in H2, the formula in I2 can be =AND(G2<TODAY(),H2<>"Done"). Then use Format > Conditional formatting to shade overdue rows red.

Sort the critical dates tab by due date every Monday. A list sorted by date reads like a schedule. Check the flags every morning, or they are just decoration. A flag nobody reads will not catch a missed inspection.

## Import Excel to Google Sheets on Mac

Many realtors already have an Excel tracker from a broker or an old template. You can move it into Sheets in a few minutes. Google says the Excel file itself does not change when you import it. Here is the import path from the File menu.

1. Open Google Sheets in your browser, then choose File > Import.
2. Choose Select a file from your device, then pick the .xlsx file on your Mac.
3. Pick Create new spreadsheet, Insert new sheet(s) or Replace spreadsheet.
4. Click Import data and wait for the file to open.

Three options are missing from this import. Replace current sheet, Append and Replace data at selected cell do not appear. If you want to add rows to a tracker that already lives in Sheets, copy the rows from the Excel file into a new tab, then combine them by hand or with a formula.

You can also drag the file from Finder into Google Drive in Safari or Chrome. Or double-click an Excel file in Drive to open it in Sheets. To keep a converted copy, choose File > Save as Google Sheets. With automatic conversion on, Excel tables import as Sheets tables, and pivot tables can come across too. Files uploaded before you turned that setting on are not converted.

> **Some Excel features stay in Excel:** Google lists 3D pyramid and pie-of-pie charts, and the Hyperion add-on, as reasons to keep working in Excel. If your old tracker depends on any of them, keep the Excel file as the working copy.

## Cell limits and file size

In March 2022, Google raised the Sheets cell limit from five million cells to ten million. The change applies to new, existing and imported files. A different Google page says that above 20 million cells you should keep working in Excel. The two numbers conflict, and the current limits page was not available when this guide was written. Plan around ten million.

A realtor's tracker rarely gets near that size. The real risk is clutter. Keep closed deals in an archive file each year. Delete scratch tabs you made while testing a formula. A lean file is easier to check before a closing, and it is less likely to break.

- **35 hours** Median hours a week for all REALTORS in NAR's 2025 data, unchanged from the prior year ([source](https://www.housingwire.com/articles/nar-2026-member-profile-experience/))
- **96%** REALTORS who use a smartphone for business daily or nearly every day ([source](https://www.housingwire.com/articles/nar-2026-member-profile-experience/))
- **10 million** Cells allowed in a Google Sheets file after Google's March 2022 increase ([source](https://workspaceupdates.googleblog.com/2022/03/ten-million-cells-google-sheets.html))

## Mac shortcuts for Google Sheets menus

You do not need to memorize every menu. Press Option + / to open Tool finder. Google used to call it Search the menus. Press ⌘ + / to see the common keyboard shortcuts. Use the Ctrl + Option shortcuts to jump straight to a menu when you want to keep your hands on the keyboard.

| Menu | Mac shortcut |
| --- | --- |
| File | Ctrl + Option + f |
| Edit | Ctrl + Option + e |
| View | Ctrl + Option + v |
| Insert | Ctrl + Option + i |
| Format | Ctrl + Option + o |
| Data | Ctrl + Option + d |
| Tools | Ctrl + Option + t |
| Help | Ctrl + Option + h |

_Menu shortcuts from Google's Mac keyboard shortcuts page._

Undo with ⌘ + Z before you dig into version history. Copy and paste with ⌘ + C and ⌘ + V. Tab moves you right and Return moves you down, which keeps data entry fast. A typo is cheap to fix when you catch it on the same row.

## Share a Google Sheets tracker with a team safely

A tracker shared with an assistant, a lender and a transaction coordinator is useful. It is also where errors come from. Paperless Pipeline says consistency gets harder as more people edit a manual spreadsheet. It also says more people with access means a higher risk of errors. The fix is structure, not a warning in the header.

![Two people looking at one laptop screen together, the way a shared Google Sheets tracker gets reviewed](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/realtors-google-sheets/google-sheets-for-realtors-on-mac-3-bb4231.jpg)

- Give the lender and the client view access only.
- Protect commission and formula columns with Data > Protect sheets and ranges.
- Name one owner for each tab and write the name in the header row.
- After a big change, check File > Version history > See version history.
- Ask each editor to type in input cells only, not in formula cells.

## Common mistakes realtors make in Sheets

- Typing the rate inside a formula, so a new rate means editing many cells.
- Storing dates as text, which breaks sorting and overdue flags.
- Merging cells in the deal table, which breaks filters.
- Forgetting referral fees because no column exists for them.
- Keeping the same deal on two tabs that slowly drift apart.
- Deleting a row that a formula points at, which breaks the totals.

Most of these come down to two habits. Put one number in one input cell. Keep one deal on one row. Once those two habits are in place, the rest of the sheet is much easier to trust.

## Gemini in Sheets on Workspace plans

Google's product page lists Gemini features in Sheets. They include building or editing a sheet from a prompt, Fill with Gemini, writing and fixing formulas, and insights. Google says some of these work only on Google Workspace plans. The page gives no prices, so check Google's pricing page and your account before you count on them.

Gemini works inside the file. Lazur works beside it. Lazur can explain a formula you are looking at, or point to the setting you need. It drafts formula text for you, and you paste it into the cell yourself. Use each tool for what it does best.

## When Sheets stops being enough

A spreadsheet works until several people, many leads and several systems all depend on it. Enterprise DNA says commission data spread across a CRM, a spreadsheet and accounting leads to conflicting records. Google says Sheets can connect to third-party tools such as HubSpot and Salesforce. Check that connection before you copy records by hand.

Move on when you spend more time reconciling records than selling. That is the signal to look at a dedicated transaction or CRM tool. Keep the spreadsheet for the work it does well, such as quick analysis and a one-page status view. If you also run events, the [Google Sheets for event planners on Mac](https://www.lazur.app/for/event-planners/google-sheets) guide covers a similar setup.

## Where Lazur helps while you work in Sheets

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘, which is Option plus Command, and ask about anything on your screen. Lazur sees the sheet, points at things and answers out loud. It does not click buttons, edit your file or operate other apps for you.

Ask it the questions that stop you mid-task. Where is the status dropdown? What does this formula do? Draft a short note to the listing agent about the inspection date, then paste it yourself. Hold fn to dictate clean text at the cursor when you need to log a call.

Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models. Still, check your brokerage's rules before you paste client details into any tool.

## Your first week in Sheets

1. Pick a template from the Template Gallery, or import your Excel tracker.
2. Enter only open deals on the Transactions tab.
3. Add the Critical dates tab with an overdue flag.
4. Build the commission columns and protect them.
5. Share with one person, then watch the edits for a week.

Each step builds on the one before. Skipping the first two makes the last three hard to trust. Start small, then add tabs only when you need them. For the email side of the same work, see [Gmail for realtors on Mac](https://www.lazur.app/for/realtors/gmail). For the wider assistant, see [AI assistant for realtors on Mac](https://www.lazur.app/for/realtors). When you are ready, get the app from the [download page](https://www.lazur.app/download).

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Lazur, where do I set up the status dropdown in this sheet?”: Lazur circles the Data menu, then labels Data validation so you know which item to pick. (Points at it)
- “Lazur, where is Data validation in this menu?”: Lazur circles the Data menu and labels the item you need, then answers out loud.
- “Lazur, walk me through making this column a dropdown.”: Lazur guides you one step at a time, waiting for each click before it goes on.
- “Lazur, what does the formula in I2 do?”: Lazur reads the formula on screen and explains each part out loud in plain words.
- “Lazur, how do I import this Excel file without changing it?”: Lazur circles File, then Import, and you make each click yourself.
- “Lazur, draft a note to the listing agent about the inspection date.”: Lazur drafts the note as text. You read it and paste it into your email yourself.
- “Lazur, look up the current Google Sheets cell limit.”: Lazur runs the search in its own Chrome tabs and returns a summary with a report.
- “Hold fn and dictate a call note for the seller's agent.”: Your words appear at the cursor as clean text, ready for a cell or a note.
- “Lazur, add a reminder for the inspection on Friday.”: Lazur adds the reminder to Apple Reminders by voice, without leaving your sheet.

## FAQ

### Is Google Sheets good enough for realtors on a Mac?

For most solo agents and small teams, yes. It handles deal lists, commission math, critical dates and sharing well. It gets harder when many people and several systems depend on the same numbers. Watch for those signs before you add more tabs.

### Can I use Google Sheets offline on a Mac?

Google's product page lists offline access as a feature. Set it up while you are online, then open the file once without a connection to check that it works. Do this before a showing or a long day away from the office.

### How do I import an Excel file into Google Sheets on a Mac?

Open Google Sheets, then choose File > Import. Pick the .xlsx file, then choose Create new spreadsheet, Insert new sheet(s) or Replace spreadsheet. Click Import data. The Excel file itself stays unchanged. Replace current sheet, Append and Replace data at selected cell are not available in this import.

### What is the cell limit in Google Sheets?

Google raised the limit to ten million cells in March 2022. Google's Excel guidance says to keep working in Excel above 20 million cells. The two numbers conflict. Plan around ten million, and split the file if it grows past that.

### Does Lazur edit my Google Sheet for me?

No. Lazur does not click buttons, edit files or operate other apps. It points at menu items, explains formulas out loud and drafts text that you paste yourself. Holding fn dictates clean text at your cursor in any app.

### Is there a free real estate tracker I can open in Google Sheets?

Paperless Pipeline offers a free transaction tracker. It is a 36 KB .xlsx workbook that opens in Excel, Google Sheets or Numbers, with no signup. Its tabs include Transactions, Critical dates, Contacts and Summary by status.

### Where is the menu search in Google Sheets on a Mac?

Press Option + /. Google calls this Tool finder, formerly Search the menus. Type part of the menu item name, then pick the match. It is faster than hunting through File, Edit and Format one by one.

### Are the Gemini features in Google Sheets free?

Google's product page says some Gemini in Sheets features are available only on Google Workspace plans. The page gives no prices. Check Google's pricing page and your account settings before you assume you have them.

### Is it safe to put client details in a shared Google Sheet?

Use sharing controls to give view access only where it is needed. Protect the formula columns, and follow your brokerage's rules for client data. Keep the most sensitive details out of a file that many people can edit. Lazur sends screenshots to AI providers to answer, and they are not stored.

## Sources

1. [Google Workspace: Google Sheets product page](https://workspace.google.com/products/sheets/), Google, checked 2026-11-06
2. [Use templates, Google Docs Editors Help](https://support.google.com/docs/answer/148833?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-06
3. [Keyboard shortcuts for Google Sheets, Google Docs Editors Help](https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-06
4. [Google Workspace Updates: Google Sheets doubles cell limit](https://workspaceupdates.googleblog.com/2022/03/ten-million-cells-google-sheets.html), Google Workspace Updates Blog, checked 2026-11-06
5. [Use both Excel & Sheets: Best practices, Google Docs Editors Help](https://support.google.com/docs/answer/9331167?hl=en), Google, checked 2026-11-06
6. [How to Convert Excel to Google Sheets on Mac, The Bricks](https://www.thebricks.com/resources/guide-how-to-convert-excel-to-google-sheets-on-mac), The Bricks, checked 2026-11-06
7. [HousingWire: NAR 2026 member profile shows Realtors more experienced](https://www.housingwire.com/articles/nar-2026-member-profile-experience/), HousingWire, checked 2026-11-06
8. [Free Real Estate Transaction Management Spreadsheet, Paperless Pipeline](https://www.paperlesspipeline.com/blog/free-real-estate-transaction-management-spreadsheet-from-paperless-pipeline), Paperless Pipeline, checked 2026-11-06
9. [Track Agent Commissions Without the Spreadsheet Chaos, Enterprise DNA](https://enterprisedna.co/resources/blog/real-estate-commission-tracking-automation/), Enterprise DNA, checked 2026-11-06