Convert Numbers to XLSX Online

Why a Numbers File Is Not Already an Excel Workbook

Apple introduced Numbers in iWork '08. Modern .numbers files use Apple's IWA archive records, introduced with the 2013 iWork redesign, instead of the worksheet XML parts that Excel expects. IWA records are Protocol Buffer streams compressed with Snappy and stored in a Numbers package with preview and metadata material. This matters because renaming a .numbers file to .xlsx leaves the Apple records in place; Excel still has no workbook to open. Apple provides Export To > Excel because an actual translation is required. Apple also states that an exported copy does not alter the original Numbers document.

Numbers also lays out a sheet differently from Excel. A single Numbers sheet can contain several separate tables positioned on a canvas, while an Excel worksheet is one large rectangular grid. A conversion has to decide where each Numbers table belongs in the XLSX workbook. Blank space, chart placement, and table names can therefore need review even if the values are present. Record the source sheet and table names before exporting. That makes it easier to find a table that landed on a different worksheet or moved below another table.

What the Numbers Export Builds Inside XLSX

XLSX is an Office Open XML ZIP package. It contains separate parts for the workbook, worksheets, styles, shared strings, drawings, and relationships between those parts. Exporting from Numbers creates those Excel-oriented parts from Apple's table and layout model. The resulting file can use the modern Excel worksheet limit of 1,048,576 rows and 16,384 columns. That is a capacity fact, not a promise that every Numbers feature has an Excel equivalent. Formulas, charts, conditional rules, and external data are separate conversion questions.

The table-to-sheet decision is an important part of that translation, not a cosmetic export preference. Apple's Numbers export options can create an Excel worksheet for each Numbers sheet or for each Numbers table. With a spreadsheet that places a budget table, a notes table, and a chart source table on one Numbers canvas, the one-per-sheet choice keeps those objects together on one Excel worksheet, whereas one-per-table separates them. Apple also offers a summary worksheet with links to the tables when exporting one worksheet per table. Choose the arrangement that best matches the recipient's task, then compare the resulting Excel tab names and count against the source. A recipient who expects one tab per reporting period can be confused by a technically valid export that instead creates tabs for every supporting table.

A displayed number can survive even when its underlying expression does not. Numbers and Excel have overlapping but not identical functions, and a formula can refer to a table or feature arranged differently in the two applications. Compare a few important formulas before and after conversion. Then change one harmless input in the XLSX copy and confirm that a dependent result recalculates. This test distinguishes a translated formula from a cached result that merely looks correct on first opening. Check formulas that feed charts and totals first because a small error there can affect several visible results.

Use a reversible test value and record both the source result and the Excel result before changing it back. In Excel, select the result cell and inspect the formula bar: an editable formula begins with an equals sign, while a plain displayed total does not prove that its calculation survived. If a changed precedent does not update the result, first look at Excel's calculation mode. Microsoft documents Automatic as the default and Manual as a mode in which formulas update only when the user explicitly recalculates, for example with F9. That separates an export problem from a workbook opened under manual calculation. Models that deliberately use circular references need another check: Excel disables iterative calculation by default, so a model that depends on repeated calculation needs its iteration settings reviewed instead of being judged from its first displayed value.

Concrete Gains and Limits of an XLSX Copy

• XLSX is Excel's default XML-based workbook format and is suitable for current Excel users.
• Excel can edit cells, sort ranges, filter tables, and recalculate formulas that exported successfully.
• Apple Community reports show that unsupported Numbers conditional-highlighting rules can be removed during Excel export.
• Charts may remain visible but need review for changed placement, labels, or unsupported options.
• Apple says a password on the original applies to an Excel export unless it is changed or removed.

The original Numbers document should remain the working reference until the XLSX copy has been opened in the receiving application. This is especially important for a workbook that will continue to be edited rather than merely read. An XLSX export is useful for sharing, but it does not make Numbers and Excel the same program. Treat source-only rules as items to verify, not as features that automatically disappear or automatically survive.

Where the Exported Workbook Can Be Opened

Apple documents Excel as a Numbers export format. Microsoft identifies XLSX as the default XML-based file format for Excel, and LibreOffice Calc can open and save XLSX as well. These facts make XLSX the practical editable delivery format when a recipient uses Excel or a workplace system asks for a workbook. They do not guarantee identical behavior after an application round trip. LibreOffice warns when a document may contain content or formatting that cannot be saved in an Excel 2007-365 format, which is useful evidence that this is a translation rather than a filename change.

Open the copy in the application that will actually receive it. Confirm sheet count, table placement, key formulas, dates, identifiers with leading zeros, charts, and print setup. A clean open message proves that the package can be read. It does not prove that a calculation rule or conditional format still means the same thing. That distinction is most important where the spreadsheet will be revised after delivery.

Reported Numbers-to-Excel Problems and Useful Checks

A Microsoft Community discussion described a converted Numbers inventory sheet that showed values in Excel but did not update when quantities changed. Calculation settings are one possible cause, but the important check is whether the target cell contains a usable formula. Apple Community discussions also document unsupported conditional highlighting being removed during export. These are specific feature-translation problems, not reasons to assume all conversions fail. Test the few rules and formulas that determine important totals before distributing the file.

The conditional-format report is particularly useful because Numbers gives a specific warning: "unsupported conditional highlighting rules were removed." Excel does have conditional formatting, but a rule does not transfer merely because both applications use a similar name. Before exporting, make a short list of rules that carry meaning rather than decoration: an overdue-date alert, a negative-margin warning, a duplicate-ID marker, or a threshold used for approval. In the XLSX copy, open Conditional Formatting Rules Manager and confirm that each expected range has a rule, the rule refers to the intended cells, and a deliberately chosen test value changes the appearance. If a rule is absent, recreate it in Excel and save the repaired XLSX; do not try to recover it by renaming or re-exporting the already converted file.

Numbers content can also contain text that looks numeric, such as an account code or a value with a currency symbol. Excel may interpret imported text differently from Numbers. Inspect the cell type rather than trusting alignment or display formatting. Dates deserve the same care because regional date order can change how a receiving application reads a text value. Keeping the original file makes it possible to compare the intended value and rebuild a target-side rule if necessary.

Long numeric identifiers need a separate audit from ordinary totals. Excel calculates with at most 15 significant digits; Microsoft therefore provides an option for incoming data with 16 or more digits to be stored as text so that all digits are retained. A bank reference, barcode, SIM number, or catalogue key may look like a number but is not a quantity that should be rounded or summed. In the exported workbook, compare the full value in the formula bar with the original Numbers value, especially when the cell displays scientific notation. Set the destination column to Text before entering or repairing such identifiers, and check that leading zeros remain present. This verification prevents a spreadsheet that looks normal at a glance from silently changing an identifier that another system relies on.

Numbers and XLSX at a Glance

Questions About Sending Numbers Workbooks to Excel

Can I rename .numbers to .xlsx?
No. The internal IWA records and Office Open XML workbook parts are different.

Will formulas stay editable?
Only formulas with an Excel equivalent can remain live. Edit an input and check a dependent value.

Why did conditional formatting disappear?
Unsupported Numbers conditional-highlighting rules can be removed during Excel export.

Should each Numbers table become its own Excel tab?
Apple's export options allow one worksheet per Numbers sheet or one per table. Use one per table when separate tables need separate Excel tabs, then check the tab count and names.

What about a 16-digit account or reference number?
Verify it character for character in Excel. Treat identifiers as text when every digit and any leading zero must be preserved.

Does export alter the Numbers original?
Apple says the exported copy does not affect the original document.

What should be checked before sharing?
Check table placement, formulas, identifiers, dates, charts, and the recipient's application.