English Japanese

How to Open a .numbers File in Excel

A .numbers file is a spreadsheet from Apple Numbers. Excel cannot open it, and converting is less clean than with a word processor document because Numbers is structured differently from Excel in a way that has no direct translation.

.numbers

Why it will not open

  • Excel has no importer for it. The format is Apple's own and undocumented, so there is nothing to convert with locally.
  • The two applications disagree about what a sheet is. In Numbers a single sheet can hold several separate tables plus charts and text, laid out like a canvas. Excel's sheet is one grid, so the structure has to be flattened somehow.
  • Formulas do not map one to one. Numbers-specific functions and cross-table references frequently arrive in Excel as errors or as pasted values.

How to open it

Convert through iCloud

  1. 1 Sign in at iCloud.com with a free Apple ID and open Numbers.
  2. 2 Drag the file into the spreadsheet list, open it, then choose Download a Copy > Excel.
  3. 3 Check the result before relying on it. Pay particular attention to any sheet that had more than one table.

When you only need the data

  1. 1 Ask the sender to export as CSV instead — in Numbers that is File > Export To > CSV.
  2. 2 CSV loses formatting and formulas but carries the values reliably, and a separate CSV is produced per table, which sidesteps the multiple-tables-per-sheet problem entirely.
  3. 3 If the CSV contains Japanese text and Excel garbles it, the file is UTF-8 without a byte-order mark. Importing it via Data > From Text/CSV and choosing UTF-8 fixes it.

What usually breaks

Multiple tables on one sheet, cell-level conditional formatting, and charts. Values and simple formulas generally survive. Anything you are going to compute with should be spot-checked against the original.

Formats that turn up in the same situation

Not sure what your file is? Identify it

Frequently Asked Questions

Can Google Sheets open a .numbers file?
No. Google Sheets imports .xlsx and .csv but not Numbers. Convert to one of those first.
Is there an offline converter?
Nothing reliable. Because the format is undocumented, tools that claim to convert it locally tend to handle only simple files. iCloud uses Apple's own engine and is the accurate route.
Why did my formulas turn into values?
Because the converter could not express them in Excel's formula language and fell back to the computed result. That is safe for reading but means the spreadsheet no longer recalculates.