# Excel for grant writers on Mac: budget templates, narratives and tracking in 2026

> Excel for grant writers on Mac: build budget workbooks, match narratives to numbers, track spending after award, and avoid Mac limits in Excel.

URL: https://www.lazur.app/for/grant-writers/excel
Updated: 2026-11-07

Excel for grant writers on Mac comes down to three jobs. You build the budget, you match the narrative to its numbers, and you track real spending after the award starts. Microsoft 365 for Mac covers all three with templates, tables and formulas, but it has gaps you need to know about. This page covers the setup, the formulas, and the Mac limits. Lazur can point at cells and answer out loud while you work.

## Quick answer

- Build the budget with the funder's categories, not your own.
- Put the indirect rate in one named cell and point every indirect formula at it.
- Add a check cell that reads total cost minus request minus match. It should show zero.
- Use tables and table names so totals keep working when you add rows.
- On Mac, avoid Data Model pivots and VBA-heavy tools. Check your build in Excel > About Excel.

## What grant writers do in Excel on Mac

Most grant writers use Excel for three jobs. They build the budget. They check that the budget narrative matches it. Then they track real spending once the award starts. Each job breaks in a different way, so each needs its own habit. This page covers all three, plus the Mac limits that catch people out.

Budget work takes real time. In one Instrumentl survey, 41.3% of respondents said one application takes 10 to 20 hours. The same article found that 25.21% named the budget as their least favorite section to write. The article does not state its sample size, so treat those percentages as a rough guide.

- **41.3%** of respondents in one survey said one grant application takes 10 to 20 hours ([source](https://www.instrumentl.com/blog/how-long-to-find-grants))
- **25.21%** named the budget as their least favorite grant section to write ([source](https://www.instrumentl.com/blog/how-long-to-find-grants))
- **44%** of public-sector grant organizations still rely on spreadsheets or a mix of tools ([source](https://eunasolutions.com/resources/how-grant-management-software-costs-work/))
- **39%** of grants staff spend up to half their working hours on manual tasks ([source](https://eunasolutions.com/resources/how-grant-management-software-costs-work/))

![Grant writer using Excel on a Mac laptop to check budget lines](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/grant-writers-excel/excel-for-grant-writers-on-mac-1-f3da7c.jpg)

## Build a grant budget template that follows the funder's categories

Start with the categories, not the numbers. Federal forms use SF-424A object classes: personnel, fringe, travel, equipment, supplies, contractual, construction, and other. Many foundation forms use different labels, and some add a match column. Match the funder's labels exactly, even when they look odd to you.

Free templates save you the setup work. Givingarc's grant budget template follows the federal object classes and adds a match column that many foundation forms lack. Nonprofit Sheets offers a template too. It also works in Google Sheets, Apple Numbers, and LibreOffice, so you can test it in whatever you already use.

To start from a template, choose File > New from Template. Templates saved in your personal templates folder show up under the Personal tab. Keep one clean skeleton for each funder you apply to, and copy it for each new application.

- Givingarc: an Excel file with four tabs named Budget, Settings, Justification, and Instructions.
- Nonprofit Sheets: four tabs named Grant Budget, Budget Narrative, Budget vs Actual, and Instructions.
- Pick the layout that fits your funder, then rename the tabs to match the form.

| Budget line | What goes in it | Excel habit |
| --- | --- | --- |
| Personnel | Salary and effort for each staff member | One row per person, with rate and effort columns |
| Fringe | Benefits, usually a rate applied to personnel | Put the fringe rate in one cell and multiply from it |
| Travel | Trips tied to the project | Keep quantity, unit cost, and trip purpose in separate columns |
| Equipment | Items above the funder's cost threshold | Flag each row so the indirect formula can skip it |
| Supplies | Consumables and project materials | List each group, not every pen |
| Indirect | Overhead on a base you define | Read the rate from a named cell, never retype it |

_A starter layout. Check each line against your funder's guidelines._

## Set one indirect cost formula that reads a single rate cell

The Givingarc template sets the indirect rate to the 15% de minimis rate on its Settings tab. You can enter a negotiated rate instead. The template computes indirect costs on modified total direct costs. That base leaves out flagged equipment, rent, participant support, and subaward amounts above $50,000.

Here is the logic with made-up numbers. Say direct costs total $100,000, and $10,000 of that is flagged equipment. The base becomes $90,000. At 15%, indirect costs are $13,500. If your organization has a negotiated rate, only the rate cell changes, and every indirect row follows.

Name the rate cell so your formulas read clearly. Select the rate cell, then choose Formulas > Define Name. Type IndirectRate as the name. Your indirect row can now read =IndirectRate*(TotalDirect-FlaggedEquipment), with the other cells named the same way.

> **Check the base first:** Some funders cap indirect costs or define their own base. Read the funder's guidelines before you trust the 15% default. The template is a starting point, not the rule.

## Make the match column add up before you submit

The Givingarc template compares the match column with total project cost on its Budget tab. It shows any shortfall in dollars. Build the same check yourself, even if your template skips it. Add a cell with total cost minus requested amount minus match. It should show zero.

- Keep in-kind match in its own column so you can total it separately.
- Type match amounts as numbers. A number stored as text won't add up in a SUM.
- Use Home > Conditional Formatting to turn a non-zero check cell red.

## Write a budget narrative that matches the spreadsheet

A narrative fails when it drifts from the spreadsheet. Nonprofit Sheets says its narrative amounts flow straight from the budget tab. Copy that idea. Use the same order and category names as the budget. For each calculation, show quantity, unit cost, and the basis for the number.

You can build the sentence with a formula. In a narrative cell, type ="Personnel: "&TEXT(C5,"$#,##0"). TEXT formats the number as dollars, and the ampersand joins the words to the amount. Fill the formula down, and the wording updates when the budget changes.

Drafting the wording is a separate job. Ask Lazur to draft a sentence for one budget line, then check every figure against the spreadsheet yourself. For full narrative sections, see [Word for grant writers](https://www.lazur.app/for/grant-writers/word).

## Track grant spending in Excel after the award starts

Budget versus actual goes stale fast. Nonprofit Sheets advises checking it at least quarterly. For large awards, check monthly. Some funders require prior approval for moves above 10% between categories, so watch those lines closely.

Use three columns for each budget line: Budgeted, Spent to date, and Remaining. Remaining is =Budgeted-Spent. Percent used is =Spent/Budgeted, formatted as a percent. In this made-up example, a supplies line is $20,000 and you have spent $14,000. Remaining is $6,000, and 70% is used.

![Person checking a budget spreadsheet on a laptop screen at a desk](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/grant-writers-excel/excel-for-grant-writers-on-mac-2-468708.jpg)

Turn each range into a table. Select the range and press ⌘T, or choose Insert > Table. Tables extend when you add rows, and their formulas fill down on their own. This keeps a spending log from breaking every time a receipt arrives.

## Name tables and avoid merged cells

Once a table has a name, a formula can read =SUM(tblSpending[Amount]) instead of =SUM(D2:D40). The reference stays correct when you add rows. Keep names short and plain. tblPersonnel and tblTravel are easy to read later.

> **Name at creation:** Microsoft's October 2026 Excel post says you can now name a table when you create it on Mac. Name it before your first formula uses it, so every formula picks up the name.

Avoid merged cells in budget headers. Microsoft's September 2026 post lists Center Across Selection on the Merge & Center menu for Windows and Mac. It is Insiders-only on both, with no general release date. Plain left-aligned headers sort and filter without trouble.

## Mac limits that trip up grant workbooks

Mac Excel has gaps in pivot tables. Noble Desktop reports that pivot tables built on the Excel Data Model can't be filtered on Mac, and pivot charts are static. If your budget summary needs filters, build the pivot from a plain table range. The [pivot table guide](https://www.lazur.app/how-to/make-a-pivot-table-in-excel) walks through the steps.

Power Query had bigger gaps. An Excel Campus article from May 11, 2022 said Mac had no connection-only queries, no From Folder option, and limited data sources. That article is older, so test any Power Query step in your own workbook before you plan around it.

Other gaps matter for shared budgets. Noble Desktop says the Quick Access Toolbar can't be imported or exported on Mac. Find and Replace by format isn't offered. You also can't set a default autosave location. Power Pivot and some add-ins lag behind Windows as well.

> **Avoid VBA on Mac:** UserForm work is much slower on Mac, the Properties window is missing, and VBA code collections can't be imported or exported. If a budget tool depends on macros, build it on Windows or ask your IT team.

### Save a default Book template for new workbooks

Microsoft's help page describes a default Book template. Open a workbook with your standard tabs and column headers. Choose File > Save as Template. Name it Book and pick the .xltx format. Save it to Library > Group Containers > UBF8T346G9.Office > User Content > Start-up > Excel, then restart Excel. Your next blank workbook starts from that layout.

## Clean messy exports with Copilot in Excel

Funder exports and accounting reports often arrive messy. Numbers come in as text, dates look wrong, and columns carry stray spaces. Copilot in Excel has a clean-data skill. Microsoft says it is generally available on all platforms, including Mac. Invoke it with @clean-data or from the Skills menu.

The skill builder is also generally available on Mac. The skill recorder is still Insiders-only on Mac. Whether Copilot is included in your Microsoft 365 plan decides if you can use these at all. Ask whoever manages your Microsoft 365 account if you are unsure.

## Ask Lazur for help while you stay in Excel

Lazur works alongside Excel. Hold Option Command and ask about the cell or formula you are looking at. Lazur answers out loud, and it can draw a circle and a label around the cell you mean. When you ask how to do something, it guides you one click at a time and waits for each click.

Hold fn to dictate. Dictation writes clean, formatted text at the cursor in any app. That helps when you write justification text into a notes column. Snippets hold the organization description you paste into every budget. Your personal dictionary holds funder and program names, so they come out spelled right.

![Person writing a grant narrative at a desk beside an open laptop](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/grant-writers-excel/excel-for-grant-writers-on-mac-3-eb7464.jpg)

Lazur does not click buttons, edit your file, or run Excel for you. Background research is a different job. It runs in Lazur's own Chrome tabs and comes back with a summary and a report. Still, check any funder rule against the funder's own page before you rely on it.

## Mistakes that cost grant writers the most time

1. Typing the indirect rate into every row. One rate change then needs many edits.
2. Hardcoding totals. A typed total never changes when a line changes.
3. Storing amounts as text. Imported numbers often arrive that way and drop out of sums.
4. Using category names the funder doesn't recognize. Rename them to match the form.
5. Letting the narrative drift from the budget. Check the two together before each submission.
6. Skipping the budget versus actual check. Overspending then shows up in the final report instead.

A PLOS ONE study surveyed 195 academics about federal grant applications. Those were researchers, not professional grant writers, so read it as a rough signal. The average proposal took about 116 PI hours. Time spent writing did not relate to whether a grant was funded. Researchers who wrote more grants got more funding.

## How much manual work spreadsheets create for grants teams

Euna Solutions' 2026 State of Grants Management and Technology Report drew on responses from 51 public-sector grants professionals. It found that 44% of organizations still rely on spreadsheets or a mix of tools. It also found that 39% of grants staff spend up to half their working hours on manual tasks. Those tasks include data entry, documentation, and reporting. Another 14% spend more than three-quarters of their time on them.

> **Lock one template:** Keep one master template for each funder. Copy it for each application, instead of starting from last year's email attachment.

## Check your Excel build before you trust a feature

Some features arrive on a schedule, and builds differ across machines. Open Excel > About Excel to see yours. The Microsoft posts above describe what has shipped, but your build decides what you see. If a feature is missing, compare its post date with your build before you assume the feature is broken.

## Where Excel ends and the funder's rules begin

Excel does the math. It doesn't know your funder's rules. Keep a short rules sheet inside the workbook. List the funder's indirect policy, equipment threshold, and approval rule for budget moves. Add the page URL and the date you checked it, so you know when to check again.

If you want voice help while you work in Excel, Lazur is a Mac app that points at cells and answers out loud. It is not a plugin, and Lazur has no partnership with any app maker. Windows is planned, not available. See [pricing](https://www.lazur.app/pricing) for current plans and the free trial.

1. Confirm every indirect cell points at the named rate.
2. Check that the match check cell shows zero.
3. Compare the narrative figures with the budget tab.
4. Confirm category names match the funder's form.
5. Save the final version with the date in the file name.

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

- “Hold Option Command and ask where the indirect rate is.”: Lazur draws a circle and a label around the indirect rate cell, then says out loud what the cell holds. (Points at it)
- “Where is the indirect rate cell in this budget?”: Lazur circles the cell and labels it on screen, so you find it without hunting across tabs.
- “Explain what this formula does in the indirect row.”: Lazur reads the formula on screen and explains each part out loud, including what the excluded lines do.
- “How do I turn this range into a table?”: Lazur walks you through it one click at a time, and waits for each click before it moves on.
- “Hold fn and dictate the travel justification into the notes column.”: Your words land at the cursor as clean text, with names from your personal dictionary spelled right.
- “Draft a one-paragraph narrative for the personnel line from these rows.”: Lazur types a draft at your cursor. You check every figure against the budget before you keep it.
- “Find the funder's current indirect cost policy and summarize it.”: Lazur runs the search in its own Chrome tabs and returns a summary and a report you can check.
- “Remind me on Friday to update actuals for the supplies line.”: Lazur adds an Apple Reminders item for the day you name.
- “Why is my check cell not showing zero?”: Lazur reads the check cell and explains, out loud, which lines are in the sum.

## FAQ

### Does Excel for Mac have grant budget templates?

Yes. Givingarc and Nonprofit Sheets both offer free Excel budget templates. Givingarc's file has four tabs and puts the indirect rate on its Settings tab. Nonprofit Sheets' file includes a budget narrative tab and a budget versus actual tab. Both open in Excel for Mac.

### Can I build a federal grant budget in Excel on Mac?

Yes, if your budget uses the federal categories. The Givingarc template follows the SF-424A object classes. Check the current form and instructions from the funder, because forms change. Excel does the math, but the funder's form sets the rules.

### What is the best way to handle indirect costs in Excel?

Put the rate in one named cell. Flag equipment and other excluded lines so the base formula skips them. The Givingarc template defaults to 15% and allows a negotiated rate. Use the rate your organization actually has, not the default.

### Can Lazur fill in my budget for me?

No. Lazur does not click buttons, edit files, or operate other apps for you. It can point at cells, explain formulas, guide you one click at a time, draft text, and dictate when you hold fn. You make the changes yourself.

### Does Lazur see my grant budget file?

Lazur looks at your screen only while you hold Option Command. The screenshot and audio go to AI providers so they can answer, and they are not stored. Content is never used to train AI models. Still, check your funder's data rules before you share sensitive information.

### Why can't I filter my pivot table on Mac?

If the pivot uses the Excel Data Model, Mac can't filter it. Noble Desktop reports this limit, and it also says pivot charts are static. Build the pivot from a regular table range instead. Test your own workbook first, because the article is a third-party source.

### Is the Copilot clean-data skill available on Mac?

Microsoft's October 2026 Excel post says the clean-data skill is generally available on all platforms, including Mac. You invoke it with @clean-data or from the Skills menu. Whether you can use it depends on your Microsoft 365 plan.

### Does Lazur work on Windows?

Not yet. Lazur is a Mac app for Apple silicon and Intel Macs. Windows is planned, not available.

### Is there a free trial for Lazur?

Yes. Lazur has a free trial that does not need a credit card. Check the pricing page for the current plans and what each one includes.

## Sources

1. [What's New in Excel (October 2026)](https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-october-2026/4549758), Microsoft Tech Community, checked 2026-11-07
2. [What's New in Excel (September 2026)](https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-september-2026/4549755), Microsoft Tech Community, checked 2026-11-07
3. [Customize how Excel starts in Excel for Mac](https://support.microsoft.com/en-us/excel/customize-how-excel-starts-in-excel-for-mac), Microsoft Support, checked 2026-11-07
4. [Nonprofit Grant Budget Template](https://givingarc.com/accounting_resources/nonprofit-grant-budget-template/), Givingarc, checked 2026-11-07
5. [Grant Budget Template with Budget Narrative](https://nonprofitsheets.com/grant-budget-template/), Nonprofit Sheets, checked 2026-11-07
6. [Excel Update: Power Query Editor for Mac](https://www.excelcampus.com/power-tools/power-query-editor-mac/), Excel Campus, checked 2026-11-07
7. [Can I Use Excel on a Mac?](https://www.nobledesktop.com/blog/can-i-use-excel-on-a-mac), Noble Desktop, checked 2026-11-07
8. [How Long Does it Actually Take to Find Grants?](https://www.instrumentl.com/blog/how-long-to-find-grants), Instrumentl, checked 2026-11-07
9. [To Apply or Not to Apply: A Survey Analysis of Grant Writing Costs and Benefits](https://journals.plos.org/plosone/article?id=10.1371%2Fjournal.pone.0118494), PLOS ONE, checked 2026-11-07
10. [How Much Does Grant Management Software Cost for Government?](https://eunasolutions.com/resources/how-grant-management-software-costs-work/), Euna Solutions, checked 2026-11-07