Excel for nonprofit fundraisers on Mac: donor logs, totals, and voice help in 2026

Most nonprofit fundraisers who use Excel on a Mac do one of three jobs. They keep a gift log, a donor list with contact details, or a budget for a campaign. Some keep all three in one workbook, which works until it doesn't. Neon One's donor tracking guide says transaction-focused sheets can make people lose sight of when donors last gave, how often they give, and which campaign brought them in. That is the main risk. The rest of this page is built around avoiding it.

Why Excel on a Mac still fits a small fundraising team

Excel is familiar to most staff, and it runs on the Mac you already have. A small team can run an appeal from one workbook without learning a new system. That matters when the development lead also writes the appeal letter and answers the phone. Excel does have real limits, and you should know them before you build. A single worksheet holds 1,048,576 rows and 16,384 columns, according to Microsoft. Most small appeals never come close to that. You will hit trouble from messy data long before you hit size.

Set up a gift log that does not break

Start with one row per gift, not one row per donor. A donor who gave three times gets three rows. Use these columns in this order: Date, Donor ID, Donor Name, Amount, Campaign, Payment Method, and Notes. Keep one value in each cell. Never type Smith, J and K into a name column. Neon One warns that when the same gift is entered several ways, that mess can break your formulas and skew your reports. A donor ID prevents most of that. Give each person one ID and never reuse it.

1. Type the headers in row one. Each header gets its own column and a short name, such as Amount or Campaign.
2. Click any cell inside the data and press ⌘T. Excel asks for the range and whether the first row holds headers.
3. Turn on the header row, then click OK.
4. Click inside the table. Open the Table Design tab and type Gifts in the Table Name box.
5. Write every later formula with names like Gifts[Amount], not cell addresses like C2:C900.

Named tables grow on their own. When you type a new gift in the row under the table, the table expands, and formulas that use Gifts[Amount] pick up the new row. Microsoft's October 2026 What's New post says naming a table as you create it is now available on both Windows and Mac. If your version skips that prompt, rename the table afterward in the Table Design tab.

Clean up addresses, dates, and duplicate donors

Messy data causes most bad totals. Neon One says donor addresses often get formatted in six different ways. The same person can show up as Robert Lee, Bob Lee, and Lee, Robert. Fix formatting first, then hunt for duplicates. Turn on the filter with ⌘⇧L and sort the name column. Look for matches on the same email address or postal code. Merge only when you are sure they are the same person.

1. Make a copy of the sheet first. Name it with today's date and the word before, so you know what it is.
2. Click any cell in the Gifts table.
3. Choose Data > Remove Duplicates. Pick the columns that define a duplicate, usually Donor ID.
4. Read the count Excel reports, then compare it with what you expected from the source export.
5. Keep the copy until the campaign total matches last year's report.

Copilot in Excel can help with this cleanup. Microsoft's October 2026 post says its clean-data skill finds issues that affect formulas, lookups, and PivotTables. Those issues include extra spaces, inconsistent formats, and duplicates. You choose which fixes to apply. The post describes the skill as rolling out to general availability on all platforms. I could not confirm which Microsoft 365 plans include Copilot, so check that before you plan a cleanup around it.

Campaign totals with SUMIFS and COUNTIFS

Totals are where a fundraising workbook earns its keep. SUMIFS adds up amounts that match a condition. Put the formula in a summary cell, not inside the table. This pattern gives the total raised for one appeal: =SUMIFS(Gifts[Amount],Gifts[Campaign],"Spring Appeal"). Because the formula reads table columns, it still works when new gifts go at the bottom of the table. Match the campaign name exactly, including spaces. A stray space at the end of a name makes SUMIFS skip that row.

Test every formula on a small slice first. Filter Campaign to one value, then select the Amount cells. Compare the sum shown in the status bar with your SUMIFS result. If they match, the formula is right. If they do not, look for amounts stored as text, extra spaces, or a currency symbol typed into the amount column. Bank exports often bring those problems along.

Pivot tables for giving patterns and board reports

Neon One says spreadsheets lack the dashboards and pivot tables needed to spot giving patterns, measure campaign success, or report to the board. Excel does include PivotTables. The gap is usually in how the sheet is built, not in the tool. A pivot works best on a named table like Gifts. Select one cell in the table, then choose Insert > PivotTable. Drag Campaign to Rows and Amount to Values. Add Date to Filters when the board wants a year view.

Pivots do not refresh on their own. After you add gifts, choose Data > Refresh All. A pivot that still shows last month's total is a common reason two board reports disagree. For a full walkthrough, read How to make a pivot table in Excel on Mac.

Budgets and goal tracking for a campaign

A campaign budget needs three things: a goal, the money raised so far, and the gap. Put the goal in one cell and label it Campaign goal. Select that cell, then type Goal in the Name Box at the left of the formula bar. Now formulas read clearly. Raised to date uses the SUMIFS total from earlier. Percent of goal is the raised total divided by Goal. Format that cell as a percentage.

Edge cases matter here. If the goal cell can be blank, a division will return an error. Wrap the formula in IFERROR so the summary shows a blank instead of an error code. Keep the raised total and the goal on the same sheet. Board members read one screen faster than three tabs.

Where Excel gets stuck for fundraising work

Excel is a good workbook, but it is not a donor system. It has no built-in donor timeline, no contact history, and no email tool. Neon One lists the lack of dashboards and the difficulty of tracking giving history as common reasons teams move on. Know these limits before you promise a result to your board.

• Lost context: a gift list does not show what a donor was asked for or when someone last called.
• Many editors: two people sorting one sheet at the same time causes confusion. Keep one master copy with a clear owner.
• Version gaps: Microsoft lists some features as Insiders-only on Mac, such as the skill recorder. Check before you plan around them.
• Vendor framing: Neon One and Little Green Light sell donor software. Read their warnings as sales context, not neutral research.

How common is this? VolunteerHub reports that 30 percent of about 200 surveyed nonprofits still track donor information in spreadsheets or similar documents. Its survey year is not stated, and the post is dated December 2014. Little Green Light, citing a 2015 Software Advice report, says 52 percent of nonprofits use Excel and Google Docs for development operations. Both figures are old and come from vendors. Use them to understand how common spreadsheets are, not as a current count.

Mac keyboard shortcuts for faster donor work

Some older articles say Excel for Mac has no ribbon shortcut. Microsoft's own shortcut page lists ⌘⌥R, so try it first. Microsoft also notes that some dialog navigation shortcuts need Full Keyboard Access turned on.

Using Lazur with your donor spreadsheet

Lazur is a voice assistant for the Mac. Hold ⌥ ⌘ to ask about anything on your screen, and Lazur answers out loud. Ask where the Table Name box is, and Lazur draws a circle and a label around it. Ask how to remove duplicates, and Lazur guides you one click at a time. It waits for each click before it moves to the next step. You can also see the AI assistant for Excel on Mac on the Excel page.

Hold fn to dictate. Clean, formatted text lands at the cursor in any app. Use it for call notes in a comment column, or to speak a short gift note into a cell. Dictation is for text, not formulas. Read every dollar figure back before you save, because speech can mishear an amount.

Lazur does not click buttons, edit files, or operate other apps for you. It is not an add-in for Excel, and Lazur has no partnerships with any app maker. Think of it as a colleague who sits next to you. Lazur points, explains formulas, drafts text, and guides you through steps. You still press the keys. 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. Research runs in Lazur's own Chrome tabs and comes back with a summary and a report. Use that for outside comparisons, not for work inside your gift log. There is a free trial on the pricing page.

Mistakes fundraisers make in Excel on Mac

• Counting pledges as gifts, so totals show money that never arrived. Add a Status column.
• Typing one donor's name three ways, then wondering why the donor count is off.
• Using merged cells inside the data area. Merged cells break sorting, filtering, and pivot tables.
• Running Remove Duplicates on the only copy of the file.
• Forgetting to refresh a pivot table before a board meeting.
• Storing dates as text, so the last gift date formula returns nothing useful.

Most of these mistakes come from the same habit. People type data the way it arrives, not the way a formula needs it. Fix the input once, and the totals stay honest. A little structure at the start saves hours at the end of the campaign.

Next steps for this week

Start with a copy of your current gift log. Convert it to a table with ⌘T and name it Gifts. Then write one SUMIFS total for the current appeal, and check it against a number you already trust. Once the total matches, add a pivot table for the board. If your donor letters also depend on mail merge, read the Gmail guide for nonprofit fundraisers on Mac. Use the download page only when you are ready to try Lazur on your own Mac: Download Lazur.