If you use Microsoft Excel on your Mac, you can save the spreadsheets you create and open them in Numbers, Apple’s spreadsheet app. It’s a handy feature to use in case you can’t access Microsoft’s apps.
Apple’s iWork apps are available for free in the App Store: Pages (word processor), Numbers (spreadsheet), and Keynote (presentations). Your Mac must have macOS Catalina 10.15 or later to run these apps. And these apps can import Office documents. Here’s how you can open Excel spreadsheets in Numbers, as well as export Numbers spreadsheets for use in Excel.
How to import Microsoft Excel spreadsheets into Apple Numbers
This procedure works with .xlsx and .xls file formats. You can also import .csv and tab-delimited files.
- Launch Numbers (it’s in the Applications folder of your Mac).
- In the window that automatically opens when you launch the app, navigate to the location of your Excel file. For example, if it’s in Documents, click on the Documents folder in the left sidebar. (You can also click on the File menu and select Open, then navigate to your spreadsheet.)
- Once you’ve located your file, select it and click Open. A progress window will appear.
Numbers for Mac lets you import an Excel spreadsheet into Numbers from your Mac or a PC. And now anyone can collaborate on a spreadsheet in real time.
- A window may appear, explaining any changes that were made during the import process. The more complicate your Excel spreadsheet (lots of formulas, charts, etc.), the higher the possibility that a change had to be made. The simpler the spreadsheet, the more your file will resemble what you created in Excel.
- That’s it. The Excel file should open in Numbers.
- Download Numbers for macOS 11.0 or later and enjoy it on your Mac. Create gorgeous spreadsheets with Numbers for Mac. Get started with one of over 30 Apple-designed templates for your home budget, checklist, invoice, mortgage calculator, and more.
- Apple Numbers vs. Microsoft Excel When it comes to Numbers and Excel, the differences are greater. Pages is basically a stripped down version of Word, but Numbers and Excel take different approaches to working with spreadsheets.
- Features available. Numbers does the work for you. So you can visualize data like never before. With newly redesigned forms, it's never been easier to create and customize a form. Simply provide input to a single row in Numbers for iPadOS by adding a form to any table or using the new Basic form template.
- Download Numbers app. Features available. Pages for Mac, Numbers for Mac, and Keynote for Mac are available on the Mac App Store. MacOS 11 or later required.
Before you start working on your spreadsheet, look it over carefully. Formatting may have changed, especially with charts. Check to make sure the formulas you are using are intact. There’s always a chance that so much happened during the import that you can’t use your spreadsheet.
How to export Apple Numbers files as Microsoft Excel spreadsheets
If you’ve been working in Numbers and will eventually return to Excel, you can export your spreadsheet as an Excel file. Here’s how.
- In Numbers, click on the File menu and move your cursor to “Export to.”
- A pop-up menu will appear. Select Excel.
- In the Export Your Spreadsheet window that appears next, you can opt to include a summary worksheet and require a password. Click on Advanced Options, and you can select between .xlsx and .xls file formats. Click Next when you have finished selecting your options.
Download Numbers For Mac Without App Store
- Choose where you want to save the file and name it.
- When you click Export, this will save the file.