# Google Sheets for supply chain planners on Mac: setup, shortcuts, and limits for 2026

> Google Sheets for supply chain planners on Mac: Mac shortcuts, file limits, offline setup, and forecast tips, plus how Lazur helps while you work.

URL: https://www.lazur.app/for/supply-chain-planners/google-sheets
Updated: 2026-11-07

Google Sheets for supply chain planners on Mac works well for inventory counts, forecast tables, and S&OP reviews, as long as you know its limits. Run it in Chrome or Edge if you need offline access, and learn the ⌘ shortcuts first. This guide covers both, plus file size limits, templates, and the common mistakes that slow a planning review.

## Quick answer

- Google Sheets runs in any Mac browser, and many planners use it for inventory, forecast, and S&OP files.
- Google's offline help names Chrome or Microsoft Edge for offline access. Safari is not mentioned.
- Learn ⌘+D, ⌘+R, ⌘+F, and Option+/ first. Option+/ opens Tool finder for any menu command.
- Google's Drive help lists up to 20 million cells or 100MB per spreadsheet. Connected Sheets previews only 500 rows.
- Give each shared number one owner and one tab. Most S&OP sheet problems come from copies that drift apart.

Most supply chain planners do not pick Google Sheets because it is the best tool for the job. They pick it because anyone with a Google Account can create a spreadsheet, and it opens in a Mac browser with no install. One file can hold a demand forecast, an inventory count, and a list of open orders. That mix is why so many S&OP teams still work this way.

## Why planners on Mac keep working in Google Sheets

The numbers back this up. An AbcSupplyChain survey of 164 S&OP and IBP professionals in 54 countries found that 81.1% run their process in Excel or Google Sheets. The article does not name its sponsor. It covers all S&OP and IBP roles, not planners alone. Treat it as a strong signal, not a census.

![Planner at a desk working on a laptop with a google sheets forecast open](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/supply-chain-planners-google-sheets/google-sheets-for-supply-chain-planners-on-1-1dd424.jpg)

- **81.1%** of 164 S&OP and IBP professionals run their process in Excel or Google Sheets ([source](https://abcsupplychain.com/sales-operations-planning-survey/))
- **20 million** cells or 100MB per Google Sheets spreadsheet, according to Google's Drive help page ([source](https://support.google.com/drive/answer/37603?hl=en))
- **500** rows in the Connected Sheets preview, while pivot tables and formulas use the full dataset ([source](https://docs.cloud.google.com/bigquery/docs/connected-sheets))

## Set up Google Sheets on your Mac for planning work

Open Google Sheets in Chrome or Microsoft Edge. Google's offline help names those two browsers for offline access, and it uses the Google Docs Offline extension. Private and incognito windows do not support offline access. Only one account per browser profile can have offline turned on. If you switch between a work account and a personal one, give each its own Chrome profile.

Google's offline page does not mention Mac or Safari. Some third-party guides say Safari works, and some say it does not. Test offline mode on your own Mac before you need it on a flight or in a warehouse with weak Wi-Fi. Very large files may fail to sync, so test with your real file, not a small sample.

To start from a template, open Google Sheets and click Template Gallery at the top right. Pick one, and a copy opens. Google's examples are CVs, budgets, and order forms. Some template features only work on work or school accounts.

## Keyboard shortcuts in Google Sheets on Mac

Google's keyboard page lists the Mac versions, with ⌘ for Command and ⌥ for Option. Learn these first. They cover most of the planning work you do each day.

- ⌘+A selects all cells in the sheet.
- ⌘+F opens Find, so you can jump to an item code.
- ⌘+D fills the selected cell down the column.
- ⌘+R fills the selected cell to the right.
- ⌘+Option+T converts a range to a table.
- ⌘+/ shows the common shortcuts list.
- Option+/ opens Tool finder. Google used to call it Search the menus.
- On a MacBook, Option+Right Arrow and Option+Left Arrow move between sheet tabs.

Here is a common case. You write a formula at the top of a forecast column, such as one that multiplies units by price. Select that cell and the cells below it, then press ⌘+D. The formula fills down the column. Check the first few rows after the fill, because a reference that should stay fixed can shift.

When you forget a shortcut, press Option+/ and type what you want. Tool finder searches the menus for you. Older guides may still say Search the menus, which is the old name for the same tool.

## Google Sheets limits for large planning data on Mac

Planners hit a wall when a sheet holds a long history of shipments. Google's Drive help says a Google Sheets spreadsheet can hold up to 20 million cells or 100MB. Many third-party guides still say 10 million cells. Use Google's figure, and still keep your file well under it.

| Item | Limit | Where Google states it |
| --- | --- | --- |
| Spreadsheet size | Up to 20 million cells or 100MB | Google Drive help |
| Connected Sheets preview | 500 rows shown | Google Cloud BigQuery docs |
| Connected Sheets extract | Up to 500,000 rows, and 5 million cells above 50,000 rows | Google Cloud BigQuery docs |
| Connected Sheets pivot table | 200,000 rows | Google Drive help |
| Excel conversion | Cells over 50,000 characters are removed | Google Drive help |

_Limits from Google's help pages and Google Cloud docs. Check them before you build._

Connected Sheets is the other route for big data. It links a sheet to BigQuery, so the data stays in the warehouse. Google Cloud says the sheet shows only a 500-row preview. Pivot tables, formulas, and charts still use the full dataset. The preview looks small, but the numbers come from everything.

Google's own pages disagree in one place. The BigQuery doc gives a 200,000 row limit for pivot tables in one section and 100,000 results in another. Plan for the smaller number until you test your own file.

Refresh rules also limit planners with Sheets-only access. They cannot refresh BigQuery data by hand or schedule refreshes. Scheduled refreshes can also fail under some VPC Service Controls perimeters. Ask your data team before you promise a weekly refresh to the planning group.

## Inventory and forecast templates for Google Sheets

The template gallery gives you a fast start, but it is thin for planning. I could not find a Google-made supply chain or planning template in Google's help. The gallery examples are general. Third-party inventory templates are a better starting point, if you check them first.

Sheetgo's review of free inventory templates describes one that tracks stock in and out across tabs. It keeps a running stock count and a minimum level for each item. A status column flags low stock. The article does not mention forecasting, so you add the forecast yourself.

A basic inventory tab needs these columns.

1. Item code, the same key in every tab, so lookups work.
2. On-hand count, updated from receipts and shipments.
3. Minimum level, the stock you want on hand before a reorder.
4. Status column, a formula that flags anything below the minimum.
5. Owner, the person who answers for this number.

Keep the forecast on its own tab with one named owner. Link the inventory tab to it with formulas, not copy-paste. Copy-paste is where versions split apart.

## Build a forecast tab that the team can read

Start with one row per item and one column per month. Put actuals on the left and the forecast on the right. Label each forecast column with its method, such as statistical or sales override. That label shows where each number came from.

Give sales overrides their own tab. Overrides change often. If they sit inside the forecast, nobody can see the baseline the statistics produced. Protect the baseline tab so that edits only happen when someone means them.

A chart helps the review. Plot forecast and actuals on one chart, then check the axis labels before the meeting. [Make a chart in Google Sheets](https://www.lazur.app/how-to/make-a-chart-in-google-sheets) shows the steps for Chrome and Safari.

Status columns break when one person types low and another types Low stock. A dropdown list stops that. Use one list per status column, and keep the values short. [Create a dropdown list](https://www.lazur.app/how-to/create-a-dropdown-list-in-google-sheets) shows the steps for Chrome.

![Supply chain team in a planning meeting reviewing numbers on a laptop for google sheets](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/supply-chain-planners-google-sheets/google-sheets-for-supply-chain-planners-on-3-46a167.jpg)

## Why shared S&OP sheets go wrong

The same survey gives the complaints. One respondent wrote, “Each team has their own spreadsheet. We waste time reconciling instead of deciding.” Another wrote, “No one really owns the number.” That line describes the gap between a statistical forecast and what sales or management expect.

Two more complaints fit this pattern. One says the meetings go in every direction. Another says nothing is centralized, with too many systems to update. A sheet will not fix a meeting. It can fix the number. Put one forecast tab in one file, and name the owner at the top.

Dated context helps too. A 2018 Adelante SCM survey of 140 executives, commissioned by BluJay Solutions, found 67.4% said they used spreadsheets as a supply chain system. That question covered the tool in general, not Google Sheets on Mac. A 2013 Logility and Consumer Goods Technology study reported that more than 70 percent could not execute their S&OP vision. It gave no sample size.

## Mistakes planners make in Google Sheets on Mac

- Trusting the 500-row preview as the full data. Pivots and formulas use the full set.
- Planning near the cell limit without checking the file size first.
- Opening offline mode in an incognito window. Google says private windows do not support it.
- Turning on offline access for two accounts in one Chrome profile. Only one account per profile can have it.
- Converting an Excel file with very long notes. Cells over 50,000 characters are removed.
- Treating a template as a forecast. Templates track stock, but the forecast is your job.

Most of these mistakes are cheap to fix early. They are expensive in a review meeting, when the numbers are already on a slide and someone has printed them.

## Where Lazur fits while you work in Google Sheets

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ to ask about anything on your screen, and Lazur answers out loud. It does not click buttons or edit your sheet. It is not a plugin or add-in for Google Sheets or any other app.

Use it for the questions that stop you mid-task. Ask where the Template Gallery is, and Lazur draws a circle and a label around it. Ask how to turn on a setting, and Lazur guides you one click at a time, waiting for each click.

Hold fn to dictate clean, formatted text at the cursor in any app. That helps with meeting notes or a comment on a cell. Dictation is unlimited on both paid plans. Snippets, a personal dictionary, and clipboard slots come with it.

Lazur has a 3-day Pro trial with no credit card. The trial starts when you first open the app. Pro costs $18/month, or $15/month billed annually, with 150 AI actions. Power costs $120/month, or $96/month billed annually, with 1,000 AI actions. Check [the pricing page](https://www.lazur.app/pricing) for current terms.

Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer you, and they are not stored. Content is never used to train AI models. If your sheet holds supplier or customer data, check your company policy before you ask about it.

## A weekly inventory check, step by step

Here is a routine many planners run each week. Import the warehouse counts as a CSV into a new tab. [Import a CSV in Google Sheets](https://www.lazur.app/how-to/import-a-csv-file-in-google-sheets) covers the File menu steps and common fixes. Then freeze the header row so item codes stay visible while you scroll, using [freeze the top row](https://www.lazur.app/how-to/freeze-the-top-row-in-google-sheets).

Sort by the status column to bring the low-stock items to the top. [Sort data by column](https://www.lazur.app/how-to/sort-data-by-column-in-google-sheets) shows the steps. If the warehouse file repeats an item code, [remove duplicate rows](https://www.lazur.app/how-to/remove-duplicate-rows-in-google-sheets) before you count. Then [count unique values](https://www.lazur.app/how-to/count-unique-values-in-google-sheets) so the total does not depend on repeats.

Save the finished check to a shared folder with the date in the file name. If a number changes after the meeting, [see the revision history](https://www.lazur.app/how-to/see-revision-history-in-google-sheets) to find who changed it and when.

![Warehouse shelves stocked with boxes, the kind of inventory a google sheets planner tracks](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/supply-chain-planners-google-sheets/google-sheets-for-supply-chain-planners-on-2-b2f66b.jpg)

## Next steps for your planning sheet

1. Pick one owner for each number that feeds a meeting.
2. Test offline mode in Chrome before you travel with the file.
3. Check your file size against Google's 20 million cell limit.
4. Learn ⌘+D, ⌘+R, ⌘+F, and Option+/ until they feel automatic.
5. Read the Connected Sheets docs before you promise a refresh schedule.

## 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

- “Where is the Template Gallery?”: Lazur draws a circle and a label around Template Gallery at the top right of the sheet, so you know where to click next. (Points at it)
- “Where is the Template Gallery in this sheet?”: Lazur circles and labels the Template Gallery at the top right, then tells you what it does.
- “Walk me through turning on offline access in Chrome.”: Lazur guides you one click at a time and waits for each click before it moves on.
- “What is the shortcut for Tool finder on my Mac?”: Lazur answers out loud: Option plus slash opens Tool finder for any menu command.
- “Why does my Connected Sheets pivot look like it only has 500 rows?”: Lazur explains the 500-row preview, and that pivot tables and formulas use the full dataset.
- “Draft a note asking the team who owns the forecast number.”: Lazur drafts a short message you can read, edit, and paste into chat or email yourself.
- “Hold fn and dictate my meeting summary into this cell.”: Lazur types clean, formatted text at the cursor in the cell you picked.
- “Research the current Connected Sheets pivot table limit.”: Lazur runs the research in its own Chrome tabs and comes back with a summary and a report.
- “Set a timer for the S&OP review.”: Lazur starts the timer by voice, so you keep your hands on the inventory tab.

## FAQ

### Does Google Sheets work offline on a Mac?

Google's offline help says offline access needs Google Chrome or Microsoft Edge with the Google Docs Offline extension. The page does not mention Mac or Safari, so test offline mode on your own machine before you rely on it.

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

Google's Drive help says a Google Sheets spreadsheet can hold up to 20 million cells or 100MB. Many third-party guides still say 10 million cells, so use Google's figure and keep your file well under it.

### Why does my Connected Sheets pivot table seem to show only 500 rows?

The sheet shows a 500-row preview. Google Cloud says pivot tables, formulas, and charts still use the full dataset. Check the results in the pivot itself, not in the preview rows.

### Can I refresh Connected Sheets data myself?

Google Cloud says users with Sheets-only access cannot refresh BigQuery data manually or schedule refreshes. Ask your data team which role you need before you promise a refresh schedule.

### Is there a Google Sheets template for supply chain planning?

I could not find a Google-made supply chain or planning template in Google's help. The Template Gallery has general examples. Third-party inventory templates exist, but check whether they include forecasting.

### How many planners use Excel or Google Sheets for S&OP?

An AbcSupplyChain survey of 164 S&OP and IBP professionals in 54 countries found 81.1% run their process in Excel or Google Sheets. The sponsor is not named, and the survey covers all S&OP and IBP roles.

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

No. Lazur does not click buttons, edit files, or operate other apps for you. It points at things on screen, answers out loud, guides you one click at a time, and drafts text you can paste.

### Is Lazur an add-in for Google Sheets?

No. Lazur is a voice assistant for the Mac, and it is not a plugin or add-in for Google Sheets or any other app. It points at things on screen, answers out loud, and guides you one click at a time.

## Sources

1. [Google Workspace - Google Sheets product page](https://workspace.google.com/products/sheets/), Google, checked 2026-11-07
2. [Keyboard shortcuts for Google Sheets - Computer - Google Docs Editors Help](https://support.google.com/docs/answer/181110?hl=en), Google, checked 2026-11-07
3. [Use Google Docs offline - Google Docs Editors Help](https://support.google.com/docs/answer/6388102?hl=en), Google, checked 2026-11-07
4. [Create a file from a template - Google Docs Editors Help](https://support.google.com/docs/answer/148833?hl=en-GB), Google, checked 2026-11-07
5. [Google Drive help: Google Sheets spreadsheet limits](https://support.google.com/drive/answer/37603?hl=en), Google, checked 2026-11-07
6. [Use Connected Sheets: BigQuery, Google Cloud Documentation](https://docs.cloud.google.com/bigquery/docs/connected-sheets), Google Cloud, checked 2026-11-07
7. [Why 81% Of Companies Still Run Their S&OP Process In Excel: And What Really Matters Instead](https://abcsupplychain.com/sales-operations-planning-survey/), AbcSupplyChain, checked 2026-11-07
8. [Two-thirds of companies consider Excel a supply chain system](https://www.supplychaindive.com/news/supply-chain-innovation-survey-BluJay-AdelanteSCM/530263/), Supply Chain Dive, checked 2026-11-07
9. [Most Businesses' Sales, Operations Planning Processes Still Spreadsheet-based or Rely on ERP](https://www.supplychainbrain.com/articles/17628-most-businesses-sales-operations-planning-processes-still-spreadsheet-based-or-rely-on-erp-survey), SupplyChainBrain, checked 2026-11-07
10. [Top 5 free Google Sheets inventory templates](https://www.sheetgo.com/blog/inventory-processes/top-5-free-google-sheets-inventory-templates/), Sheetgo, checked 2026-11-07