Apple Intelligence is now available on iPhone, iPad, and Mac!

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

Can excel spreadsheets be imported into numbers

Can excel spreadsheets be imported into numbers

iPad, iPadOS 13

Posted on Nov 12, 2020 3:25 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 12, 2020 6:03 PM

To import: launch Numbers and File > Open and navigate to the Excel document you want to import.


Most, but not all, Excel formulas come over to Numbers intact and functioning. Bear in mind, though, that Numbers does not support so-called "array" formulas, the ones you enter in Excel with control-shift-enter so they are surrounded by curly brackets. Numbers also handles date math differently from Excel.


There are usually workarounds for all this in Numbers, but if you intend to make a "round-trip" from Excel to Numbers and back to Excel you will be disappointed.


Net, net. Numbers is pretty good at importing Excel documents so you can access your data in Numbers with most calculations intact. But it is no substitute for Excel if you are collaborating with others who use Excel.


Probably the best approach is to just try it with specific Excel documents and see if the results are good enough for your workflow.


SG



2 replies
Question marked as Top-ranking reply

Nov 12, 2020 6:03 PM in response to JJPARRA333

To import: launch Numbers and File > Open and navigate to the Excel document you want to import.


Most, but not all, Excel formulas come over to Numbers intact and functioning. Bear in mind, though, that Numbers does not support so-called "array" formulas, the ones you enter in Excel with control-shift-enter so they are surrounded by curly brackets. Numbers also handles date math differently from Excel.


There are usually workarounds for all this in Numbers, but if you intend to make a "round-trip" from Excel to Numbers and back to Excel you will be disappointed.


Net, net. Numbers is pretty good at importing Excel documents so you can access your data in Numbers with most calculations intact. But it is no substitute for Excel if you are collaborating with others who use Excel.


Probably the best approach is to just try it with specific Excel documents and see if the results are good enough for your workflow.


SG



Nov 12, 2020 3:37 PM in response to JJPARRA333

Yes, but…


MS Excel's feature set and Numbers feature set are not the same.


Any feature of Excel not supported in Numbers will not be translated when the Excel document is opened and translated to a Numbers document.


The same is true in the other direction. Exporting a Numbers document to an Excel file will result is the loss of any Numbers feature not supported in MS Excel.


Importing an MS Excel file into Numbers does NOT make any change to the original Excel file.

Exporting a Numbers file in an Excel format does NOT make any change to the Numbers document remaining in Numbers or to the original Numbers file saved as a Numbers file.


Regards,

Barry

Can excel spreadsheets be imported into numbers

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