How to open ODS file in Numbers app on a Mac

To actually open an ODS file with all the formulas you need to install Open Office or Libre Office or some other program that understands ODS format, but if you just need to quickly get the data and the basic structure of an old file:

  • Right-click (or two-finger-click/tap) the ODS file and select Open With -> Other
  • Select TextEdit app
  • Select all of the content
  • Paste it into a new Numbers spreadsheet

If you had formulas in some cells, they will not have (correct) results of those calculations, but at least you will have something to work with in another spreadsheet application. 

19 thoughts on “How to open ODS file in Numbers app on a Mac

  1. Thanks for taking the time to put this info out theree. It is really helpful to folks like myself and saves a lot of headaches.

  2. Thanks for this. I was scratching my head wondering why this functionality isn’t built in.

  3. Thanks for this – sone idiot sent out a rota to a group of volunteers using an ods file and I only opened it thanks to your advice …. and taking it from text edit, to Excel and then to Word!

  4. This didn’t work for me. I was able to open the file in TextEdit, which was a big help, but then could not copy it into either Numbers (3.6.2) or Excel (Office 2011). Numbers just hung, and Excel crashed. Pasting into Word put every cell into a single column. (For reference, I’m running macOS 10.11.6.)

  5. why hasn’t anyone mentioned that there is no “right-click” on Mac??!!! This was useless

    1. Thanks Jason, I updated the article. I assumed it was a common knowledge that “right click” from other platforms is the same as “two-finger click” on a Mac.

  6. I had a .ods file and change the extension from .ods to .xsl or .xslx and opened it in excel 2016 for mac

  7. Thanks dude! Awesome! I was scratching my nuts trying to figure this out, how to copy tons of data and formulas from ods into excel and it appears into one very long column. Well done mambo jumbo!

    1. Because itโ€™s an open standard and not everyone is in thrall to Apple.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.