Hi,
Are some .xls files different from others?
I use an external booking system where I can download data.
If the file is .xls it will not open - just shows nonsense. Their .csv files are fine.
I understood the 3.6.1 version had addressed this problem.
I can convert the files but it would be easier just to have them open in Numbers
iMac, OS X El Capitan (10.11.4)
Not all .xls files are created equal:
It appears that Numbers cannot open 'Excel 5.0/95 Workbook (.xls)' that can still sometimes be the only format offered for download from some websites.
But Numbers should be able to open 'Excel 97-2004 Workbook (.xls)' and of course '.xlsx'.
Not all features in every '.xls' or '.xlsx' file import as expected, but you shouldn't encounter too many problems with sheets containing mainly data and common formulas.
SG
Not all .xls files are created equal:
It appears that Numbers cannot open 'Excel 5.0/95 Workbook (.xls)' that can still sometimes be the only format offered for download from some websites.
But Numbers should be able to open 'Excel 97-2004 Workbook (.xls)' and of course '.xlsx'.
Not all features in every '.xls' or '.xlsx' file import as expected, but you shouldn't encounter too many problems with sheets containing mainly data and common formulas.
SG
This is why I keep a current version of LibreOffice for those older document formats that Apple Pages or Numbers cannot open. Sometimes, just opening the files in LibreOffice and resaving them makes them palatable to Pages and Numbers.
Numbers 3.6.1 not opening some .xls files
