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 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 now have (correct) results of those calculations, but in my case that was all I really needed.

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Printed from: http://www.deveblog.com/index.php/how-to-open-ods-file-in-numbers/ .
© Svemir Brkic 2017.

11 Comments   »

  • Cliff says:

    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.

  • shanmugam says:

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

  • stu says:

    This doesn't work for me...it just crashes numbers

  • Dennis Murphy says:

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

  • charlotte says:

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

  • Skyler says:

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

  • Mr Pesco :D says:

    Bravo!!!!!!!

  • Clare West says:

    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!

  • murali says:

    Thanks a lot. It did help me a lot

  • Susan Kayser says:

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

RSS feed for comments on this post , TrackBack URI

Leave a Reply