Press "Enter" to skip to content

How to open ODS file in Numbers app on a Mac

Last updated on 9/7/2019

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. 

15 Comments

  1. Cliff

    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. shanmugam

    Really helpful to open .ods file without installing any app related to this…

  3. stu

    This doesn’t work for me…it just crashes numbers

  4. Dennis Murphy

    When I do this all I get is a lot of gibberish in one column!

  5. charlotte

    Thank you so so much! yo are a life saver! 🙂

  6. Skyler

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

  7. Mr Pesco :D

    Bravo!!!!!!!

  8. Clare West

    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!

  9. murali

    Thanks a lot. It did help me a lot

  10. Susan Kayser

    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.)

  11. Jason

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

  12. Preeti

    Hey, thanks a lot for this. It really helped.

  13. confg

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

  14. Gombhet

    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!

  15. 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.

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.