How to open Microsoft Excel spreadsheets in Apple Numbers on a Mac

How to open Microsoft Excel spreadsheets in Apple Numbers on a Mac

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—not to mention that Microsoft recently announced that its Office apps won’t have “formal” support for Apple macOS High Sierra operating system.

Every Mac comes with Apple’s iWork apps: Pages (word processor), Numbers (spreadsheet), and Keynote (presentations). 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.

  1. Launch Numbers (it’s in the Applications folder of your Mac).
  2. 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.)
    numbers open file IDG
  3. Once you’ve located your file, select it and click Open. A progress window will appear.
    excel import in progess IDG
  4. 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.
  5. That’s it. The Excel file should open in Numbers.

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.

  1. In Numbers, click on the File menu and move your cursor to “Export to”.
  2. A pop-up menu will appear. Select Excel.
    numbers export to IDG
  3. In the Export Your Spreadsheet window that appears next, you can opt to include a summary worksheet and require a password. Click on the Advanced Options, and you can select between .xlsx and .xls file formats. Click Next when you have finished selecting your options.
    export spreadsheet options IDG
  4. Choose where you want to save the file and name it.
  5. When you click Export, this will save the file.
    creating excel file IDG

Microsoft Office and macOS High Sierra

Here are some key points to know about running Office apps on macOS High Sierra.

  • Version 15.35 or later of Office 2016 for Mac will install and run on macOS High Sierra, but the apps may not be fully functional and you might run into stability issues (in other words the app might crash).
  • Version 15.34 and earlier of Office 2016 for Mac may not run at all on macOS High Sierra. Chances are you’ll see the error message below. You need to update to version 15.35 or later.
    outlook error message Microsoft
  • Office 2011 for Mac apps will no longer be supported by Microsoft on October 10th, 2017. You need to upgrade to Office 2016.
IDG Insider

PREVIOUS ARTICLE

«Logitech Circle 2 review: Second time's the charm for this wired home security camera

NEXT ARTICLE

How to open Microsoft PowerPoint presentations in Apple Keynote on a Mac»
author_image
IDG Connect

IDG Connect tackles the tech stories that matter to you

Add Your Comment

Most Recent Comments

Our Case Studies

IDG Connect delivers full creative solutions to meet all your demand generatlon needs. These cover the full scope of options, from customized content and lead delivery through to fully integrated campaigns.

images

Our Marketing Research

Our in-house analyst and editorial team create a range of insights for the global marketing community. These look at IT buying preferences, the latest soclal media trends and other zeitgeist topics.

images

Poll

Should companies have Bitcoins on hand in preparation for a Ransomware attack?