Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

can an Excel spreadsheet on iMac be converted to Numbers spreadsheet

can an Excel spreadsheet on iMac be converted to Numbers spreadsheet

iMac 21.5" 4K, macOS 10.15

Posted on Jan 5, 2020 10:24 PM

Reply
Question marked as Best reply

Posted on Jan 6, 2020 2:06 AM

Hi IBM 1620Dude,


Yes, Numbers can import (and convert) an Excel spreadsheet. The original Excel spreadsheet (document) will be unchanged. Numbers makes a copy under the Numbers file format.

The conversion may not be perfect (for example, Numbers does not support all the Excel functions; missing functions will be replaced with the last Excel result). The layout may look different because Excel uses huge sheets of cells, whereas Numbers uses several tables (and other objects) on each 'canvas' (Sheet/Tab).

Excel Sheets (Tabs) may or may not import as Numbers Sheets (Tabs).


Several methods:

  • Double click on an Excel document in Finder;
  • Drag an Excel document onto the Numbers icon in the Dock, or onto the Numbers icon in your Applications folder;
  • Open Numbers and Menu > File > Open then navigate to the Excel document.


You can also Export from Numbers back to Excel. Give the file a new name and/or a new folder if you want to avoid overwriting the original Excel document.


Regards,

Ian.



1 reply
Question marked as Best reply

Jan 6, 2020 2:06 AM in response to IBM1620Dude

Hi IBM 1620Dude,


Yes, Numbers can import (and convert) an Excel spreadsheet. The original Excel spreadsheet (document) will be unchanged. Numbers makes a copy under the Numbers file format.

The conversion may not be perfect (for example, Numbers does not support all the Excel functions; missing functions will be replaced with the last Excel result). The layout may look different because Excel uses huge sheets of cells, whereas Numbers uses several tables (and other objects) on each 'canvas' (Sheet/Tab).

Excel Sheets (Tabs) may or may not import as Numbers Sheets (Tabs).


Several methods:

  • Double click on an Excel document in Finder;
  • Drag an Excel document onto the Numbers icon in the Dock, or onto the Numbers icon in your Applications folder;
  • Open Numbers and Menu > File > Open then navigate to the Excel document.


You can also Export from Numbers back to Excel. Give the file a new name and/or a new folder if you want to avoid overwriting the original Excel document.


Regards,

Ian.



can an Excel spreadsheet on iMac be converted to Numbers spreadsheet

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.