MAKE A RELIABLE HANDOFF
Apple Numbers Compatibility: Choose, Export and Check
Choose an exchange format by what the recipient needs to do, then check the parts that matter before handing over your workbook.
The short answer
Keep the Numbers master, export a separate copy, and verify it in the receiving app. Matching visible totals alone does not prove the formulas still work.
Choose the recipient’s task before the file format. A printable report, an editable model and a list of records need different checks. Keep the original Numbers document and treat every conversion as a separate exchange copy.
Editable calculations
Records for import
A report to read
Choose the right handoff
| The recipient needs to… | Start with | Check before delivery |
|---|---|---|
| Keep editing in Numbers | A Numbers document or agreed shared master | Correct file, access and platform. Avoid parallel masters. |
| Change inputs and recalculate in Excel | Excel export | Live formulas, references, worksheet layout and required objects. |
| Import records into another system | CSV or TSV | Exact columns, identifiers, separators, encoding and row counts. |
| Read or print the result | Page breaks, readable labels, complete tables and expected totals. |
Apple documents these export choices in its Mac export guide. The guide below is an acceptance checklist, not a promise that every workbook feature survives conversion.
Editable workbooks
An Excel exchange is a candidate for continued calculation, not automatic acceptance. Keep formulas and their inputs under review in the actual destination app.
Plain-text records
Agree on the schema before export: column names, order, separators and identifier handling. Inspect the exported text before the receiving import runs.
Readable reports
Check the final PDF at a realistic reading size. Confirm all intended sheets and tables are present; disclose that the deliverable is a report rather than an editable workbook.
What needs its own check?
Structure. A Numbers sheet can contain several tables. An Excel worksheet layout is not automatically a one-to-one match. Inventory the required sheets, tables and headings before conversion.
Calculations. A displayed answer can match even when its formula has become a static value. Inspect a formula and change an input in a disposable receiving copy. Check references to other tables deliberately; see cross-table references.
Identifiers and dates. An ID is a string, even when it contains only digits. Leading zeros and exact final digits matter. For dates, check the intended day, month and year, not just a familiar-looking display. Use the CSV identifier guide and language/region checks.
Presentation. Charts, fonts, controls, comments and page layouts need visual review. A readable chart is not a numerical audit. A matching total is not a layout audit.
Automation. List any scripts, shortcuts, macros or external refresh steps separately. A spreadsheet export does not demonstrate that those workflows transfer. Leave an untested requirement pending rather than quietly substituting values.
A reversible export workflow
- Agree on the destination. Record the recipient’s actual app and platform, plus whether they need editing or only reading.
- Save the master. Keep a distinct working
.numbersfile and write down expected values outside it. - Create an exchange copy. On Mac, choose File → Export To and select the format. For Excel, decide whether worksheets correspond to Numbers tables or sheets. For CSV/TSV, decide whether tables should be separate files or combined. Apple also documents text-encoding choices.
- Review warnings and options. Record conversion warnings rather than dismissing them as harmless. For protected documents, check the exported copy’s password settings; do not assume that every format preserves protection.
- Open in the intended receiving app. Inspect the copy there. Reopening it only in Numbers is not a test of Excel behavior.
- Validate and keep both. Check the sample below, inspect important objects and retain the master until the recipient accepts the deliverable.
The export controls and password-format distinctions are documented by Apple. For the full two-table walkthrough, use export Numbers to Excel and reconcile totals.
Download the practice materials
- Handoff practice CSV: the two synthetic equipment records used below. It supplies reference values, not a prebuilt formula workbook.
- Compatibility checklist CSV: record expected results, observations and pass/fail status.
- Practice readme: scope, expected totals and verification notes.
Keep these separate from production data. CSV files do not preserve workbook formulas or presentation.
A small handoff acceptance test
Use this synthetic equipment list to separate correct values from working calculations. Unit value is 12.50 for both records.
| Equipment ID | Quantity | Expected line value |
|---|---|---|
| KIT-007 | 4 | 50.00 |
| KIT-008 | 7 | 87.50 |
| Total | 11 | 137.50 |
For an editable model, add a separate calculated column for quantity × unit value and sum that calculated column. The CSV’s expected_line_value column contains fixed reference values for the original inputs, not formulas; do not use it as the recalculating column. Only the calculated column should respond to input edits; the supplied second reference value remains 87.50 during the test. After export, confirm both IDs exactly, all inputs and the two totals. Then, in a disposable receiving copy, change KIT-008’s quantity from 7 to 8.
The expected new line value is 100.00; total quantity is 12; total value is 150.00. If the visible values do not respond, the editable-model requirement has not passed. Undo the test or discard that copy; do not send a deliberately changed fixture as the production file.
These figures are independent arithmetic, not application test results. A PDF only needs the agreed report values; it should not be judged as an editable calculation model. A CSV must be checked as text as well as through the recipient’s import process.
Finish with an explicit result
- Ready: Required records, calculations and presentation passed in the receiving environment.
- Report only: The PDF is readable and complete, but no editable workbook is being supplied.
- Verification pending: Export exists, but the recipient’s app or a required feature has not been checked.
- Blocked: A required value or behavior changed. Keep the failed copy and resolve the discrepancy before delivery.
For reports, continue with printing and PDF output. For shared work, use one-master file management. If a check fails, use troubleshooting.
About this guide
Mac export documentation checked October 23, 2026. No Numbers-to-Excel round-trip or receiving-app execution is claimed. Controls can differ on mobile and in a browser; see versions and platform requirements.