Numbers has the ability to open Excel files so you can work on them. You can also export spreadsheets in Numbers so that they are compatible with Excel.
If you use Microsoft Excel on a Mac, you can save the spreadsheet that you created and open it in Numbers, Apple’s spreadsheet application. This is a practical feature to use if you cannot access Microsoft applications.
Every Mac is equipped with the Apple iWork application: Pages (word processing), Numbers (spreadsheets), and Keynote (presentations). And this application can import Office documents. Here’s how you can open Excel spreadsheets in Numbers, and export the Numbers worksheet to use in Excel.
How to import a Microsoft Excel spreadsheet to Apple Numbers
This procedure works with the .xlsx and .xls file formats. You can also import .csv and tab-delimited files.
- Launch Number (in your Mac Applications folder).
- In the window that automatically opens when you launch the application, navigate to the location of your Excel file. For example, if it’s in Docs, 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.)
3. After you find your file, select it and click Open. A progress window will appear.
4. A window may appear, explaining any changes made during the import process. The more complex your Excel worksheets (many formulas, charts, etc.), the higher the likelihood that changes will have to be made. The simpler the spreadsheet, the more your files will resemble what you create in Excel.
5. There she is. Excel files must open in Numbers.
Before you start working on your spreadsheet, check it carefully. Formatting may have changed, especially with charts. Check to make sure the formula you are using is still intact. There are always lots of opportunities happening during import so you can’t use your spreadsheet.
How to export Apple Number files as a Microsoft Excel spreadsheet
If you have worked in Numbers and will eventually return to Excel, you can export your spreadsheet as an Excel file. This is how you do it.
- In Numbers, click on the File menu and move your cursor to “Export to.”
2. A pop-up menu will appear. Select Excel.
3. In the Export Your Worksheet window that appears next, you can choose to include a summary worksheet and require a password. Click Advanced Options, and you can choose between .xlsx and .xls file formats. Click Next when you have finished selecting your options.
4. Choose where you want to save the file and name it.
5. When you click Export, this will save the file.