{"id":304,"date":"2021-10-14T19:40:29","date_gmt":"2021-10-14T19:40:29","guid":{"rendered":"https:\/\/unionline24.co.za\/apps\/?p=304"},"modified":"2021-10-14T19:42:12","modified_gmt":"2021-10-14T19:42:12","slug":"how-do-i-open-a-ods-file-in-excel","status":"publish","type":"post","link":"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/","title":{"rendered":"How do I open a ODS file in Excel?"},"content":{"rendered":"<div class=\"3b0f01c982c849478b934f73fd22ce2a\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2361696526152498\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- apps responsive ads -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-2361696526152498\"\r\n     data-ad-slot=\"4647471924\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<p id=\"bmbacktotop\">You can open and save files in the OpenDocument Spreadsheet (.ods) file format that is used by some spreadsheet applications, such as OpenOffice.org Calc and Google Docs.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_31_1 ez-toc-wrap-left counter-hierarchy counter-numeric ez-toc-white\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" style=\"display: none;\"><label for=\"item\" aria-label=\"Table of Content\"><i class=\"ez-toc-glyphicon ez-toc-icon-toggle\"><\/i><\/label><input type=\"checkbox\" id=\"item\"><\/a><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1\"><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/#Open_an_OpenDocument_Spreadsheet_in_Excel\" title=\"Open an OpenDocument Spreadsheet in Excel\">Open an OpenDocument Spreadsheet in Excel<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/#Save_an_Excel_worksheet_in_OpenDocument_Spreadsheet_format\" title=\"Save an Excel worksheet in OpenDocument Spreadsheet format\">Save an Excel worksheet in OpenDocument Spreadsheet format<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/#Learn_more_about_the_OpenDocument_Format\" title=\"Learn more about the OpenDocument Format\">Learn more about the OpenDocument Format<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Open_an_OpenDocument_Spreadsheet_in_Excel\"><\/span>Open an OpenDocument Spreadsheet in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Click&nbsp;<strong>File<\/strong>&nbsp;&gt;&nbsp;<strong>Open<\/strong>&nbsp;&gt;&nbsp;<strong>Computer<\/strong>&nbsp;&gt;&nbsp;<strong>Browse<\/strong>.<\/li><li>To only see files saved in the OpenDocument format, in the file type list (next to the&nbsp;<strong>File name<\/strong>&nbsp;box), click&nbsp;<strong>OpenDocument Spreadsheet (*.ods)<\/strong>.<\/li><li>Find the file you want to open, and then click&nbsp;<strong>Open<\/strong>.<\/li><\/ol>\n\n\n\n<p><strong>Note:&nbsp;<\/strong>When you open an OpenDocument Spreadsheet file in Excel, it might not have the same formatting as it did in the original application it was created in. This is because of the differences between applications that use the OpenDocument Format.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Save_an_Excel_worksheet_in_OpenDocument_Spreadsheet_format\"><\/span>Save an Excel worksheet in OpenDocument Spreadsheet format<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Important:&nbsp;<\/strong>If you want to keep an Excel version of your file, you need to save the file as an Excel worksheet, for example in the .xlsx file format, and then save it again in the OpenDocument Spreadsheet (.ods) format.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Click&nbsp;<strong>File<\/strong>&nbsp;&gt;&nbsp;<strong>Save As<\/strong>&nbsp;&gt;<strong>Computer<\/strong>&nbsp;&gt;&nbsp;<strong>Browse<\/strong>.<\/li><li>In the&nbsp;<strong>Save as type<\/strong>&nbsp;list, click&nbsp;<strong>OpenDocument Spreadsheet (*.ods)<\/strong>.<\/li><li>Name and save your file.<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Learn_more_about_the_OpenDocument_Format\"><\/span>Learn more about the OpenDocument Format<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>When you open or save worksheets in the OpenDocument Spreadsheet (.ods) format, some formatting might be lost. This is because of the different features and options, such as formatting and tables, that OpenDocument Spreadsheet applications and Excel support. For more information about the differences between the OpenDocument Spreadsheet format and the Excel format,<\/p>\n\n\n\n<p><\/p>\n<div class=\"3b0f01c982c849478b934f73fd22ce2a\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2361696526152498\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- apps responsive ads -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-2361696526152498\"\r\n     data-ad-slot=\"4647471924\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>You can open and save files in the OpenDocument Spreadsheet (.ods) file format that is used by some spreadsheet applications, such as OpenOffice.org Calc and Google Docs. Open an OpenDocument Spreadsheet in Excel Click&nbsp;File&nbsp;&gt;&nbsp;Open&nbsp;&gt;&nbsp;Computer&nbsp;&gt;&nbsp;Browse. To only see files saved in the OpenDocument format, in the file type list (next to the&nbsp;File name&nbsp;box), click&nbsp;OpenDocument Spreadsheet (*.ods).\u2026 <span class=\"read-more\"><a href=\"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[372],"tags":[],"class_list":["post-304","post","type-post","status-publish","format-standard","hentry","category-libreoffice"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How do I open a ODS file in Excel? - Applications And Software<\/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:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I open a ODS file in Excel? - Applications And Software\" \/>\n<meta property=\"og:description\" content=\"You can open and save files in the OpenDocument Spreadsheet (.ods) file format that is used by some spreadsheet applications, such as OpenOffice.org Calc and Google Docs. Open an OpenDocument Spreadsheet in Excel Click&nbsp;File&nbsp;&gt;&nbsp;Open&nbsp;&gt;&nbsp;Computer&nbsp;&gt;&nbsp;Browse. To only see files saved in the OpenDocument format, in the file type list (next to the&nbsp;File name&nbsp;box), click&nbsp;OpenDocument Spreadsheet (*.ods).\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Applications And Software\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-14T19:40:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-14T19:42:12+00:00\" \/>\n<meta name=\"author\" content=\"Applications\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Applications\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/how-do-i-open-a-ods-file-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/how-do-i-open-a-ods-file-in-excel\\\/\"},\"author\":{\"name\":\"Applications\",\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/#\\\/schema\\\/person\\\/3e8d396fe3af6061d44deafec1142817\"},\"headline\":\"How do I open a ODS file in Excel?\",\"datePublished\":\"2021-10-14T19:40:29+00:00\",\"dateModified\":\"2021-10-14T19:42:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/how-do-i-open-a-ods-file-in-excel\\\/\"},\"wordCount\":280,\"commentCount\":0,\"articleSection\":[\"LibreOffice\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/how-do-i-open-a-ods-file-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/how-do-i-open-a-ods-file-in-excel\\\/\",\"url\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/how-do-i-open-a-ods-file-in-excel\\\/\",\"name\":\"How do I open a ODS file in Excel? - Applications And Software\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/#website\"},\"datePublished\":\"2021-10-14T19:40:29+00:00\",\"dateModified\":\"2021-10-14T19:42:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/#\\\/schema\\\/person\\\/3e8d396fe3af6061d44deafec1142817\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/how-do-i-open-a-ods-file-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/how-do-i-open-a-ods-file-in-excel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/how-do-i-open-a-ods-file-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do I open a ODS file in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/#website\",\"url\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/\",\"name\":\"Applications And Software\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/#\\\/schema\\\/person\\\/3e8d396fe3af6061d44deafec1142817\",\"name\":\"Applications\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f94a53ca27c783bda59ca80dcae52b73ec93390eea2b389c95d7754a1f3ce484?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f94a53ca27c783bda59ca80dcae52b73ec93390eea2b389c95d7754a1f3ce484?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f94a53ca27c783bda59ca80dcae52b73ec93390eea2b389c95d7754a1f3ce484?s=96&d=mm&r=g\",\"caption\":\"Applications\"},\"sameAs\":[\"http:\\\/\\\/unionline24.co.za\\\/apps\"],\"url\":\"https:\\\/\\\/unionline24.co.za\\\/apps\\\/author\\\/amhere\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How do I open a ODS file in Excel? - Applications And Software","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:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How do I open a ODS file in Excel? - Applications And Software","og_description":"You can open and save files in the OpenDocument Spreadsheet (.ods) file format that is used by some spreadsheet applications, such as OpenOffice.org Calc and Google Docs. Open an OpenDocument Spreadsheet in Excel Click&nbsp;File&nbsp;&gt;&nbsp;Open&nbsp;&gt;&nbsp;Computer&nbsp;&gt;&nbsp;Browse. To only see files saved in the OpenDocument format, in the file type list (next to the&nbsp;File name&nbsp;box), click&nbsp;OpenDocument Spreadsheet (*.ods).\u2026 Read More &raquo;","og_url":"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/","og_site_name":"Applications And Software","article_published_time":"2021-10-14T19:40:29+00:00","article_modified_time":"2021-10-14T19:42:12+00:00","author":"Applications","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Applications","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/#article","isPartOf":{"@id":"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/"},"author":{"name":"Applications","@id":"https:\/\/unionline24.co.za\/apps\/#\/schema\/person\/3e8d396fe3af6061d44deafec1142817"},"headline":"How do I open a ODS file in Excel?","datePublished":"2021-10-14T19:40:29+00:00","dateModified":"2021-10-14T19:42:12+00:00","mainEntityOfPage":{"@id":"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/"},"wordCount":280,"commentCount":0,"articleSection":["LibreOffice"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/","url":"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/","name":"How do I open a ODS file in Excel? - Applications And Software","isPartOf":{"@id":"https:\/\/unionline24.co.za\/apps\/#website"},"datePublished":"2021-10-14T19:40:29+00:00","dateModified":"2021-10-14T19:42:12+00:00","author":{"@id":"https:\/\/unionline24.co.za\/apps\/#\/schema\/person\/3e8d396fe3af6061d44deafec1142817"},"breadcrumb":{"@id":"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/unionline24.co.za\/apps\/how-do-i-open-a-ods-file-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/unionline24.co.za\/apps\/"},{"@type":"ListItem","position":2,"name":"How do I open a ODS file in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/unionline24.co.za\/apps\/#website","url":"https:\/\/unionline24.co.za\/apps\/","name":"Applications And Software","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/unionline24.co.za\/apps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/unionline24.co.za\/apps\/#\/schema\/person\/3e8d396fe3af6061d44deafec1142817","name":"Applications","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f94a53ca27c783bda59ca80dcae52b73ec93390eea2b389c95d7754a1f3ce484?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f94a53ca27c783bda59ca80dcae52b73ec93390eea2b389c95d7754a1f3ce484?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f94a53ca27c783bda59ca80dcae52b73ec93390eea2b389c95d7754a1f3ce484?s=96&d=mm&r=g","caption":"Applications"},"sameAs":["http:\/\/unionline24.co.za\/apps"],"url":"https:\/\/unionline24.co.za\/apps\/author\/amhere\/"}]}},"_links":{"self":[{"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/posts\/304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/comments?post=304"}],"version-history":[{"count":1,"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/posts\/304\/revisions"}],"predecessor-version":[{"id":307,"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/posts\/304\/revisions\/307"}],"wp:attachment":[{"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/media?parent=304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/categories?post=304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unionline24.co.za\/apps\/wp-json\/wp\/v2\/tags?post=304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}