# Export Numbers to Excel Without Breaking Formulas

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2026-04-11
- Updated: 2026-04-11
- Category: Google Sheets, Numbers and LibreOffice
- Canonical: https://www.fastbankconvert.com/blog/export-numbers-to-excel

> Export Numbers to Excel when someone needs an XLSX: what converts, which functions and tables change, and how to check the exported file.
To export Numbers to Excel, open the spreadsheet on a Mac and choose File > Export To > Excel, pick one worksheet per table or per sheet, then save. The exported copy is a separate XLSX file. Open it before sending, because formulas, table layout and formatting can arrive changed even when the export reports no problem.

## Export To > Excel in Numbers, click by click

The Excel export lives in the File menu of Numbers on a Mac. Apple's guide to [exporting to Excel or another file format](https://support.apple.com/guide/numbers/export-to-excel-or-another-file-format-tan3b922d4ad/mac) lists the steps: choose File > Export To > Excel, pick the worksheet option, decide on a password, then save and name the file.

The full sequence:

1. Open the spreadsheet in Numbers.
2. Choose File > Export To > Excel.
3. Choose whether Excel should get a worksheet for each table or for each sheet.
4. If you pick one per table, decide whether to include a summary worksheet that links to all the tables.
5. If a password box appears, keep, change or remove the password for the exported copy.
6. Click Save, type a name, pick a folder, and click Export.

Apple notes that changes made to the exported file do not affect the original. That cuts both ways. Fix a mistake in the XLSX and the Numbers file still has it, so decide which file is the master before anyone edits.

## Worksheet per table or per sheet in the Excel export?

Choose one worksheet per table when the people opening the file will work with each table on its own. Choose one per sheet when the tables only make sense side by side, as they are in Numbers. The choice exists because a Numbers sheet is a canvas that can hold several tables, while an Excel worksheet is one grid.

### Worked example

Take an example Numbers sheet called "March" that holds two tables: "Transactions", with 60 rows of statement lines, and "Summary", with totals by category that refer to the first table.

| Export option | What Excel shows |
| --- | --- |
| Worksheet for each table | Two worksheets, one holding Transactions and one holding Summary. With the summary option, a third sheet with links to both. |
| Worksheet for each sheet | One worksheet, "March", with both tables placed on the same grid. |

Per table gives the cleaner result for statement data. Each worksheet starts at the top-left with its own headers, so filters, sorting and pivot tables behave as Excel users expect. Per sheet keeps the visual layout but puts two tables on one grid, and sorting one can disturb the other if they share rows.

If your transactions table still has a description and amount stuck in one column from a pasted PDF, fix that first; [splitting a column in Numbers](/blog/split-column-in-numbers) shows how. Problems like that only get harder once the file is in Excel.

## Which Numbers formulas survive in an Excel file?

A formula survives when Excel has a function of the same meaning and the references can be rewritten to cell addresses. Everyday functions such as SUM, AVERAGE, IF and ROUND have equivalents in both programs. The way to know for your file is to click a few result cells in Excel and read the formula bar.

Numbers formulas often refer to cells by table and header name, such as a column called Amount in the table Transactions. Excel works in plain addresses like B2:B61. The export has to translate those references, and a formula that pointed across tables depends on where each table ended up, which is one more reason to prefer one worksheet per table.

When you test, look for three outcomes:

- **A working formula.** The formula bar shows a function, and editing a source cell changes the result.
- **A fixed value.** The formula bar shows only a number. The result was correct at export time but will not update.
- **An error.** The cell shows a message such as #NAME?, which means Excel does not know the function.

Fixed values are the dangerous ones because they look right. Change one transaction amount in Excel and check that the totals move.

## Opening the exported XLSX before you send it

Open the exported file yourself before anyone else does, ideally in the program they use. Ten minutes of checking saves a round of emails. Excel is best; if you do not have it, a free spreadsheet app still shows whether tables, formulas and formats came through.

Use this checklist on the XLSX:

1. Every table you expected is there, on the worksheet you expected.
2. Header rows sit in row 1 of each worksheet, not halfway down.
3. Dates are real dates: they align right and sort in calendar order.
4. Amounts are numbers, and a SUM over them matches the Numbers total.
5. Formulas update when you change a source value.
6. No column shows ##### instead of values. That usually means the column is too narrow, as the post on [Excel showing hashtags instead of numbers](/blog/excel-shows-hashtags-instead-of-numbers) explains.
7. Checkboxes, sliders, pop-up menus and images look acceptable or have been replaced.
8. The password, if any, is the one you meant to set.

If you have no Excel at all, LibreOffice Calc opens XLSX for free on Mac, Windows and Linux. The guide to [getting a PDF into LibreOffice Calc](/blog/pdf-to-libreoffice-calc) covers installing and using it for statement data.

## When CSV is a better Numbers export than Excel

Export to CSV instead of Excel when the receiver is going to import the data into another system, such as accounting or budgeting software, rather than open it as a workbook. CSV carries values only, one table at a time, so there is nothing to translate and nothing to break.

CSV is also the safer choice when the Numbers file has heavy formatting nobody needs, or when the receiver uses an old program. You lose formulas, but for transaction lists that is often what you want: the importing system calculates its own totals.

Keep XLSX when the receiver needs your formulas, several tables in one file, or formatting such as currency symbols and column widths. If the statement started life as a PDF, FastBankConvert is being built to produce both Excel and CSV files from it directly. It is getting ready to open; [join through the homepage](/) to hear when trials start.