I've saved a spreadsheet in the old format .xls on my MacBook and shared it via WhatsApp. Some of the recipients have informed me that the file is not usable both by Android and iPhone smartphones.
Could anybody help?

  • Is it uploaded correctly? Download it yourself and check if the file is intact. – Biswapriyo Jan 29 '18 at 21:18
  • 1
    Do they have an app installed to open these files? – davidbaumann Jan 29 '18 at 21:27
  • Biswapriyo I have tried with my iPhone 5S, but it doesn't open it. Nevertheless, it works fine on my macBook. – G. Carbone Jan 29 '18 at 22:05
  • davidbaumann, I don't know for sure. But they can open the same file in the most recent version .xlsx. – G. Carbone Jan 29 '18 at 22:06

Mac uses another way to store .xls files. Try to store it as a .csv file and see if that works. Go to File > Save As and select "CSV (Comma delimited)" in the dropdown menu. Make sure that the ones who are receiving the spreadsheet open it in the right way.

Another post has been made that explains how to open it correctly. After opening it in Excel, you have to go the Data tab and select text to columns. here, select delimited and hit next. Then select comma as the delimiter and hit finish.

If this answer has helped you, you can accept this as the best answer.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.