Export Apple Numbers to Excel and Check That Totals Match

Quick answer: Keep the .numbers master, export an Excel copy, then compare a written set of control totals in the receiving Excel application. An export that opens successfully is not proof that every formula or chart survived. There is no universal “keep all totals unchanged” switch.

Requirements and evidence

These instructions target Numbers for Mac 15.4, identified by Apple’s Mac guide when checked on October 16, 2026. Use Numbers → About Numbers to check your installation. iPad, iPhone and iCloud have different controls. The receiving Excel version must be recorded separately; this is not an Excel-version compatibility certification.

Testing disclosure: Apple documentation was reviewed and the example arithmetic was independently calculated. This workflow has not been tested in the Numbers or Excel applications. No native round-trip results or screenshots are claimed.

You need Numbers and access to the Excel application your recipient actually uses. If that second application is unavailable, stop at “export prepared, destination verification pending.” Reopening the file only in Numbers does not establish its behavior in Excel.

Keep the right master format

Use Numbers for continued work on the original. Use Excel export for an editable exchange copy, PDF for fixed-layout reading, and CSV/TSV for values in a flat data transfer. CSV is not a backup of formulas, charts, formatting or a multi-table workbook. Numbers sheets can contain independent tables, so table structure deserves explicit attention during conversion.

Make an untouched backup before preparing a real workbook. Record which features matter: formulas, dates, number formats, charts, merged cells, categories or pivot reports, controls, comments and print output. Include any automation or downstream processes in your acceptance checklist rather than assuming a file extension preserves them.

Build a small export audit

In a blank practice document, name the first sheet Audit. Use the existing blank table or click Table in the toolbar and choose a basic style. Name the table Sales, with one header row, no footer rows, four columns and five rows. Enter these headers and inputs; column D will contain formulas, not the expected numbers shown here.

Row	Item (A)	Units (B)	Unit price (C)	Expected amount (D)
1	Item	Units	Unit price	Amount
2	Notebooks	12	8.25	99.00
3	Pens	9	5.50	49.50
4	Folders	15	3.00	45.00
5	Binders	4	18.00	72.00

1. Select Sales D2, type =B2*C2, and press Return.
2. Copy D2 and paste into D3:D5. Verify that each formula uses its own row.
3. Format C2:D5 as numbers with two decimal places in Format → Cell → Data Format. These are synthetic amounts in one unspecified currency; do not infer a currency conversion.
4. Click Table in the toolbar to add a second table on Audit named Checks, with two columns, one header row and seven total rows. Enter Metric in A1 and Result in B1, then the following labels and formulas.

Cell in Checks	Label in column A	Formula or input in column B	Expected result
B2	Gross	=SUM(Sales::D2:D5)	265.50
B3	Tax rate	0.20	20% when percentage-formatted
B4	Tax	=B2*B3	53.10
B5	Total including tax	=B2+B4	318.60
B6	Units	=SUM(Sales::B2:B5)	40
B7	Numeric amounts	=COUNT(Sales::D2:D5)	4

For table setup, see Apple’s table instructions. The rate is only an arithmetic test input, not tax advice. Format B3 as Percentage and the amounts as numbers with two decimals. Do not multiply 0.20 by 100 before percentage formatting. Apple’s cell-format guide explains the number and percentage controls.

Numbers uses :: between table and cell references. You can build the cross-table reference by selecting the source cells in the Formula Editor instead of typing the table name. See Apple’s formula instructions and the cross-table reference walkthrough. The SUM and COUNT checks test different things: amount total versus numeric population.

Write the expected figures outside the workbook before conversion. A comparison formula that travels inside the same export could break along with the cells it was supposed to check.

Export a separate Excel copy

Follow Apple’s export workflow:

1. Save the Numbers master, then choose File → Export To → Excel.
2. Choose a worksheet for each table or each sheet. Table mapping separates Sales and Checks; sheet mapping keeps their sheet grouping. Do not assume exported cell addresses will be identical under both choices.
3. For this exercise, choose one worksheet per table. Leave the optional summary worksheet off to keep the comparison simple. Record the choice.
4. Review password options if shown. Do not unintentionally remove protection from a confidential exchange copy.
5. Click Save, enter a distinct name such as Audit-exchange, choose the destination under Where, then click Export. Record any warnings. Keep the original intact.

Do not type Numbers-style references into Excel to “repair” an export automatically. The destination has its own reference syntax; inspect the converted formula and its target first.

Reconcile in the receiving Excel application

Open the exported file in Excel, keeping the Numbers master available for comparison. Record the actual Excel version and any opening or conversion warnings. Use this acceptance checklist:

• Find both Sales and Checks by their labels and values, even if their worksheet names or coordinates changed.
• Compare all four amounts: 99.00, 49.50, 45.00 and 72.00. Equal grand totals can hide two offsetting errors.
• Confirm gross 265.50, tax 53.10, final total 318.60, units 40 and numeric amount count 4.
• Inspect at least one line formula and the cross-table sum. A matching cached value or pasted constant does not prove the dependency remains editable.
• In a disposable copy, change the Notebooks quantity from 12 to 13. Expected line amount becomes 107.25, gross 273.75, tax 54.75, final total 328.50 and units 41. The amount count stays 4. Restore 12 afterward.
• Check representative dates, percentages, identifiers, comments, controls, formatting and print output from your actual workbook. The small fixture does not exercise those features.

For an existing chart of these four line amounts, check its source range and category labels, not just its colors. It should represent the four item amounts, excluding totals and tax. Check that the changed Notebooks input affects the corresponding plotted value. In Numbers, select the chart and use Edit Data References to inspect its inputs; see Apple’s chart-data guide. Destination chart inspection must be done in Excel as well.

Resolve a mismatch without losing the original

The displayed total matches but editing does nothing: Inspect whether the destination contains formulas or only values, and whether the receiving application has recalculated. Keep the failed exchange copy for diagnosis; do not replace the master with it.

The difference is one cent: Compare stored inputs and formula logic, not only two-decimal display formatting. Decide explicitly whether your real model rounds each line or only a final total. Do not hide a discrepancy by adjusting a displayed number.

A table or chart is missing or rearranged: Recheck the table-versus-sheet export choice. Export another separately named copy using the other mapping and repeat the whole audit. A visually tidier arrangement is not evidence of correct references.

A total omits a new row: This fixture uses bounded ranges ending at row 5. Expand the formulas deliberately when adding data and update the expected count. Check filtered or categorized real data against the intended business population.

Long identifiers or dates changed: Treat them as separate compatibility tests. See preserving long IDs during CSV import; CSV is not a repair for an already altered identifier.

Keep the master and exchange copy until the recipient confirms both results and editable behavior. If only a readable report is needed, use Numbers printing and PDF output instead of treating an unverified workbook export as equivalent.