How to open excel file in Numbers on Mac: three methods for Numbers 15.4

Open the file from inside Numbers with File > Open

This is the most direct route. It works whether or not Excel is installed on your Mac. Open Numbers first, then use the menu bar at the top of the screen. Make sure Numbers is the active app, or the menu will show another program's commands.

When the Open dialog appears, it looks like a normal Finder window. Go to the folder that holds your workbook, such as Downloads or Documents. Select the file and click Open. Numbers reads the workbook and makes a new Numbers spreadsheet from it.

Drag the Excel file onto the Numbers icon

Apple's guide suggests dragging for Excel files, and the reason is simple. Double-clicking an Excel file in Finder opens Microsoft Excel when Excel is installed. A drag sends the file to Numbers instead. Drop it on the Numbers icon in the Dock or in the Applications folder.

Dragging also suits a file you just downloaded. Keep a Finder window open beside the Dock. Point at the workbook, hold the mouse button, and move it over the Numbers icon. Let go when the pointer sits on the icon.

Control-click the file and choose Open With

Control-click works well when you want Numbers for one file and nothing else changes. Hold Control and click the Excel file. You can also right-click it with a mouse or trackpad. Hover over Open With, then choose Numbers from the list.

If Numbers is missing from that list, it may be out of date or not installed. Check the Mac App Store, install the latest Numbers, and try again.

You can also make Numbers the default for every .xlsx file. Select the file in Finder and press ⌘ I to open Get Info. Expand Open with, choose Numbers, and click Change All.

Pick the method that fits the job

Each method ends in the same place, a Numbers spreadsheet. The difference is where you start. The table below shows which method suits common situations.

If Numbers is already open and you need a file from another folder, File > Open keeps you in the app. If you are sorting files in Finder anyway, dragging is faster.

Reopen a workbook from File > Open Recent

After the first import, you may need the workbook again. Go to File > Open Recent in Numbers. Apple's guide says this list shows up to the last ten spreadsheets. Pick the one you need, and it opens without a file browser.

Open Recent tracks spreadsheets you have opened in Numbers. The copy you edit in Numbers is what appears there, not the original Excel file. Decide early which file is your master, so you do not edit two versions by accident.

Open several Excel workbooks in tabs

If you work from three or four workbooks at once, separate windows pile up fast. Numbers can open each file as a tab in one window instead. Go to System Settings > Desktop & Dock, open the Windows section, and turn on Prefer tabs when opening documents.

The setting applies to every app that supports tabs, not only Numbers. Once it is on, open each workbook with one of the methods above. Each file lands in a tab in the same window, so you can switch between them without hunting through the Dock.

Tabs help when you compare the original Excel file with the Numbers copy you are building. Keep the Excel file in one tab and the Numbers copy in another. Then check the totals side by side, one sheet at a time.

Check the sheet after it opens

Numbers does its best with Excel files, but the result is not always an exact copy. Macworld's guide says formatting may change, especially charts. It also advises checking that formulas are intact. The simpler the spreadsheet, the closer the match.

Start with the cells that matter most. Double-click a formula cell to read its formula. Compare the result with the Excel file. If totals differ, look for a function that Numbers handles differently.

• Formulas: compare totals and key results with the Excel original.
• Charts: confirm each chart points at the right table and sits on the right sheet.
• Images and text: check that they did not shift during import.
• Fonts: choose Format > Font > Replace Fonts for any font your Mac does not have.
• Conditional formatting: rules do not transfer, so set them up again if you need them.

Mistakes people make after opening Excel in Numbers

The most common mistake is editing the Numbers copy and forgetting the Excel file. A colleague then receives the old Excel version. Pick one master file and tell the team which one it is.

Another mistake is trusting the first look. A sheet can appear fine while one formula on another tab is wrong. Scroll through each tab and spot-check key figures against the original.

People also copy cells by hand when they need Excel again. Copying is slow and easy to get wrong. File > Export To > Excel handles the whole workbook in one step.

What Numbers does not carry over from Excel

Numbers is not a copy of Excel. It has about 250 functions. Excel has more than 450, according to How-To Geek. Check any function that is unusual in your file, since it may not exist in Numbers.

Macros and VBA code do not run in Numbers. Slicers and timelines are not supported. Conditional formatting rules are not transferred. Aptos Narrow does not work natively in Numbers, so text set in that font needs another font.

How-To Geek also notes that charts and images can end up in the wrong places after import. Macworld makes the same point about charts. Plan time to look at every sheet before you rely on the result.

Size limits for large Excel workbooks

Excel worksheets hold up to 1,048,576 rows and 16,384 columns, according to Microsoft. Each cell can contain up to 32,767 characters. Those limits describe Excel, not Numbers.

Datablist, a third-party guide, states that Numbers supports up to 1,000,000 rows per table. It does not name a Numbers or macOS version, so treat the figure as a rough guide. If your sheet approaches that size, split it before you import.

Large files also open more slowly and scroll less smoothly. Splitting one sheet into several smaller tables keeps each part easier to check.

Open Excel files in Numbers on iCloud.com

You can skip the Mac app entirely. Sign in to iCloud.com, open Numbers, and drag the file into the browser window. You can also click Upload, select the file, and click Upload again. Then double-click the file to open it.

Apple's iCloud page lists XLSX among the formats Numbers supports. It does not list .xls. Macworld's steps say .xls works in the Mac app, so results can vary. If an .xls file fails, save a copy as .xlsx in Excel and upload that instead.

Fix a file that will not open in Numbers

A dimmed file in the Open dialog means Numbers cannot open it. Apple's guide says to update Numbers from the Mac App Store and check the file format. Run those two checks before you try anything else.

If Excel opens when you expected Numbers, the default app is set to Excel. Get Info fixes that. Microsoft's support answer for a similar problem uses the same Change All step, so the steps carry over.

Save your work and export back to Excel

Numbers saves its own format. Press ⌘ S or choose File > Save to keep your changes. Close the spreadsheet with ⌘ W when you finish, as Apple's guide describes.

To send the workbook back to Excel, choose File > Export To > Excel. Apple's steps let you choose a worksheet for each table or for each sheet. You can also add an optional summary worksheet and a password.

Apple's steps finish with Save, then Where > Export. Check the destination before you confirm, so the file lands where your team looks for it.

Once the sheet is open, you may want to tidy it. See How to sort a table in Numbers on Mac by column, step by step and How to filter a table in Numbers on Mac: filter table rows step by step.

Who should open Excel files in Numbers

Numbers suits people who need to view, check, or lightly edit a workbook. It also suits a team that works on Macs and wants a Numbers file. Keep the Excel file as the master if the workbook uses macros, slicers, or many Excel-only functions.