​​ ​

The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.


You can continue to find trusted guidance and support on the official Apple Support site. 


We want to thank the community members who have contributed their time and expertise to help others with their Apple products.


Numbers

If I download an Excel file in the xlsx format, Numbers opens it just fine. If the file is in the xls format it opens in Numbers like this:


   <HTML xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel">  


     <head>

     

     


     <style>

       <!--

       table

       {

         mso-displayed-decimal-separator:"\.";

         mso-displayed-thousand-separator:"\,";


Is there something I need to do to be able to use .xls files?

iMac 21.5″, macOS 10.15

Posted on Feb 6, 2022 8:30 AM

Question marked as Top-ranking reply

Posted on Feb 6, 2022 9:42 AM

Downloaded from the web? Excel has quite a few different formats and too often companies/websites tack the "xls" extension onto excel files that are not actually in xls format. This one looks to be html. Numbers won't open Excel html files.


I do not have any of the free Office clones (LibreOffice, OpenOffice) or use Google Sheets nor do I know if they will import an Excel htm file. If one does, you could use get one of them and mess with your file there or export it from there to a true xlsx file to then import into Numbers.


For a really simple file that is data only (no formulas) and you are not all that concerned about text and cell formatting being correct, you might be able to open the file in Safari (drag and drop the file into a Safari window), select the table (Command A to select all), Copy, then Paste into a sheet in Numbers. It should create a table in Numbers.

1 reply
Question marked as Top-ranking reply

Feb 6, 2022 9:42 AM in response to Dave_K

Downloaded from the web? Excel has quite a few different formats and too often companies/websites tack the "xls" extension onto excel files that are not actually in xls format. This one looks to be html. Numbers won't open Excel html files.


I do not have any of the free Office clones (LibreOffice, OpenOffice) or use Google Sheets nor do I know if they will import an Excel htm file. If one does, you could use get one of them and mess with your file there or export it from there to a true xlsx file to then import into Numbers.


For a really simple file that is data only (no formulas) and you are not all that concerned about text and cell formatting being correct, you might be able to open the file in Safari (drag and drop the file into a Safari window), select the table (Command A to select all), Copy, then Paste into a sheet in Numbers. It should create a table in Numbers.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers

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