How to open XLS file in proper format using mac numbers?
I am using mac numbers to open an xls file but all I see is html tags when I open the file. Refer to screenshot attached.
How do I fix this?
MacBook Air 13", macOS 10.14
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.
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.
I am using mac numbers to open an xls file but all I see is html tags when I open the file. Refer to screenshot attached.
How do I fix this?
MacBook Air 13", macOS 10.14
That .xls file contains HTML syntax, so it is not a proper spreadsheet, but something someone changed the .html extension to .xls in belief it would convert the HTML table to Excel format. You probably would have better luck making a copy of it, and renaming that extension back to .html — then opening it in a browser.
Here is a Quick Look of an HTML table, where the extension was renamed to .xls. Not only does the original HTML present as it would in a browser, but that table is scrollable too. If I force open it in Numbers, the HTML syntax spews in the spreadsheet.
However, if this table is presented in a browser, I can select what is visible, and using Paste and Match Style starting with the selected cell A1 in a Numbers spreadsheet, deposit the selection in rows and columns of the spreadsheet as if typed in it.
That .xls file contains HTML syntax, so it is not a proper spreadsheet, but something someone changed the .html extension to .xls in belief it would convert the HTML table to Excel format. You probably would have better luck making a copy of it, and renaming that extension back to .html — then opening it in a browser.
Here is a Quick Look of an HTML table, where the extension was renamed to .xls. Not only does the original HTML present as it would in a browser, but that table is scrollable too. If I force open it in Numbers, the HTML syntax spews in the spreadsheet.
However, if this table is presented in a browser, I can select what is visible, and using Paste and Match Style starting with the selected cell A1 in a Numbers spreadsheet, deposit the selection in rows and columns of the spreadsheet as if typed in it.
Thank you for the detailed response, it was really helpful. I had been scratching my head since long over this issue.
You are welcome.
How to open XLS file in proper format using mac numbers?