{"id":93,"date":"2014-04-15T22:03:40","date_gmt":"2014-04-16T02:03:40","guid":{"rendered":"http:\/\/www.deveblog.com\/?p=93"},"modified":"2019-09-07T16:30:57","modified_gmt":"2019-09-07T20:30:57","slug":"how-to-open-ods-file-in-numbers","status":"publish","type":"post","link":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/","title":{"rendered":"How to open ODS file in Numbers app on a Mac"},"content":{"rendered":"<p>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:<\/p>\n<ul>\n<li>Right-click (or two-finger-click\/tap) the ODS file and select Open With -&gt; Other<\/li>\n<li>Select TextEdit app<\/li>\n<li>Select all of the content<\/li>\n<li>Paste it into a new Numbers spreadsheet<\/li>\n<\/ul>\n<p>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.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To actually open an ODS file with all the formulas you need to install Open Office or Libre Office or&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-93","post","type-post","status-publish","format-standard","hentry","category-tech","post-archive"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to open ODS file in Numbers app on a Mac - deveblog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to open ODS file in Numbers app on a Mac - deveblog\" \/>\n<meta property=\"og:description\" content=\"To actually open an ODS file with all the formulas you need to install Open Office or Libre Office or...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/\" \/>\n<meta property=\"og:site_name\" content=\"deveblog\" \/>\n<meta property=\"article:published_time\" content=\"2014-04-16T02:03:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-07T20:30:57+00:00\" \/>\n<meta name=\"author\" content=\"svemir\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"svemir\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/\"},\"author\":{\"name\":\"svemir\",\"@id\":\"https:\/\/www.deveblog.com\/#\/schema\/person\/5269075d85da1c274f54c57dbdfd8ca7\"},\"headline\":\"How to open ODS file in Numbers app on a Mac\",\"datePublished\":\"2014-04-16T02:03:40+00:00\",\"dateModified\":\"2019-09-07T20:30:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/\"},\"wordCount\":116,\"commentCount\":19,\"publisher\":{\"@id\":\"https:\/\/www.deveblog.com\/#\/schema\/person\/5269075d85da1c274f54c57dbdfd8ca7\"},\"articleSection\":[\"tech\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/\",\"url\":\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/\",\"name\":\"How to open ODS file in Numbers app on a Mac - deveblog\",\"isPartOf\":{\"@id\":\"https:\/\/www.deveblog.com\/#website\"},\"datePublished\":\"2014-04-16T02:03:40+00:00\",\"dateModified\":\"2019-09-07T20:30:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.deveblog.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to open ODS file in Numbers app on a Mac\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.deveblog.com\/#website\",\"url\":\"https:\/\/www.deveblog.com\/\",\"name\":\"deveblog\",\"description\":\"This blog is recursive. See tagline for details.\",\"publisher\":{\"@id\":\"https:\/\/www.deveblog.com\/#\/schema\/person\/5269075d85da1c274f54c57dbdfd8ca7\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.deveblog.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.deveblog.com\/#\/schema\/person\/5269075d85da1c274f54c57dbdfd8ca7\",\"name\":\"svemir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.deveblog.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/543dbf778ac75bc3ebec8366d50566e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/543dbf778ac75bc3ebec8366d50566e3?s=96&d=mm&r=g\",\"caption\":\"svemir\"},\"logo\":{\"@id\":\"https:\/\/www.deveblog.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/www.deveblog.com\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to open ODS file in Numbers app on a Mac - deveblog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/","og_locale":"en_US","og_type":"article","og_title":"How to open ODS file in Numbers app on a Mac - deveblog","og_description":"To actually open an ODS file with all the formulas you need to install Open Office or Libre Office or...","og_url":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/","og_site_name":"deveblog","article_published_time":"2014-04-16T02:03:40+00:00","article_modified_time":"2019-09-07T20:30:57+00:00","author":"svemir","twitter_card":"summary_large_image","twitter_misc":{"Written by":"svemir","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/#article","isPartOf":{"@id":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/"},"author":{"name":"svemir","@id":"https:\/\/www.deveblog.com\/#\/schema\/person\/5269075d85da1c274f54c57dbdfd8ca7"},"headline":"How to open ODS file in Numbers app on a Mac","datePublished":"2014-04-16T02:03:40+00:00","dateModified":"2019-09-07T20:30:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/"},"wordCount":116,"commentCount":19,"publisher":{"@id":"https:\/\/www.deveblog.com\/#\/schema\/person\/5269075d85da1c274f54c57dbdfd8ca7"},"articleSection":["tech"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/","url":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/","name":"How to open ODS file in Numbers app on a Mac - deveblog","isPartOf":{"@id":"https:\/\/www.deveblog.com\/#website"},"datePublished":"2014-04-16T02:03:40+00:00","dateModified":"2019-09-07T20:30:57+00:00","breadcrumb":{"@id":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.deveblog.com\/index.php\/how-to-open-ods-file-in-numbers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.deveblog.com\/"},{"@type":"ListItem","position":2,"name":"How to open ODS file in Numbers app on a Mac"}]},{"@type":"WebSite","@id":"https:\/\/www.deveblog.com\/#website","url":"https:\/\/www.deveblog.com\/","name":"deveblog","description":"This blog is recursive. See tagline for details.","publisher":{"@id":"https:\/\/www.deveblog.com\/#\/schema\/person\/5269075d85da1c274f54c57dbdfd8ca7"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.deveblog.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.deveblog.com\/#\/schema\/person\/5269075d85da1c274f54c57dbdfd8ca7","name":"svemir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.deveblog.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/543dbf778ac75bc3ebec8366d50566e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/543dbf778ac75bc3ebec8366d50566e3?s=96&d=mm&r=g","caption":"svemir"},"logo":{"@id":"https:\/\/www.deveblog.com\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/www.deveblog.com\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/posts\/93","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/comments?post=93"}],"version-history":[{"count":7,"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/posts\/93\/revisions"}],"predecessor-version":[{"id":659,"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/posts\/93\/revisions\/659"}],"wp:attachment":[{"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/media?parent=93"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/categories?post=93"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.deveblog.com\/index.php\/wp-json\/wp\/v2\/tags?post=93"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}