{"id":14051,"date":"2021-09-20T10:56:54","date_gmt":"2021-09-20T08:56:54","guid":{"rendered":"https:\/\/dans.knaw.nl\/file-formats\/spreadsheets\/ods\/"},"modified":"2021-09-20T10:56:56","modified_gmt":"2021-09-20T08:56:56","slug":"ods","status":"publish","type":"page","link":"https:\/\/dans.knaw.nl\/en\/file-formats\/spreadsheets\/ods\/","title":{"rendered":"ODS"},"content":{"rendered":"<p>ODF is an ISO standardized format for office documents. For spreadsheets, it uses the .ods extension; the other two extensions are .odt for textual files and .odp for presentations. ODF files are essentially XML files that comply with the XML schema defined in ISO \/ IEC 26300: 2006. The last revision dates from 2015.<br \/>The advantage of ODS is that it is an open standard that can be processed by multiple applications. Metadata can be added in the form of RDF to later versions of ODF. You can add metedata up to the level of cells, in the case of spreadsheets. Examples of office suites that use ODF include&nbsp;<a class=\"external-link\" title=\"\" href=\"https:\/\/www.openoffice.org\/\" target=\"_blank\" rel=\"noopener\" data-mce-href=\"https:\/\/www.openoffice.org\/\">OpenOffice<\/a>&nbsp;and&nbsp;<a class=\"external-link\" title=\"\" href=\"https:\/\/www.libreoffice.org\/\" target=\"_blank\" rel=\"noopener\" data-mce-href=\"https:\/\/www.libreoffice.org\/\">LibreOffice<\/a>. MSExcel files can also be saved as ODS. There are various software libraries that can be used to program ODF programmatically.<\/p>\n<p>Media type<br \/>The media type of ODS files is&nbsp;<em>application\/vnd.oasis.openocument.spreadsheet<\/em>&nbsp;and&nbsp;<em>application\/vnd.oasis.openocument.spreadsheet-template<\/em>&nbsp;for templates.<\/p>\n<p>Also see<br \/>Planning for Library of Congress Collections:&nbsp;<a class=\"external-link\" title=\"\" href=\"https:\/\/www.loc.gov\/preservation\/digital\/formats\/fdd\/fdd000439.shtml\" target=\"_blank\" rel=\"noopener\" data-mce-href=\"https:\/\/www.loc.gov\/preservation\/digital\/formats\/fdd\/fdd000439.shtml\">https:\/\/www.loc.gov\/preservation\/digital\/formats\/fdd\/fdd000439.shtml<\/a><\/p>\n<p>ODS is a preferred format for the Spreadsheets file type.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ODF is an ISO standardized format for office documents. For spreadsheets, it uses the .ods extension; the other two extensions are .odt for textual files and .odp for presentations. ODF files are essentially XML files that comply with the XML schema defined in ISO \/ IEC 26300: 2006. The last revision dates from 2015.The advantage [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"parent":13058,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false,"footnotes":""},"class_list":["post-14051","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>File formats: ODS | DANS<\/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:\/\/dans.knaw.nl\/en\/file-formats\/spreadsheets\/ods\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"File formats: ODS | DANS\" \/>\n<meta property=\"og:description\" content=\"ODF is an ISO standardized format for office documents. For spreadsheets, it uses the .ods extension; the other two extensions are .odt for textual files and .odp for presentations. ODF files are essentially XML files that comply with the XML schema defined in ISO \/ IEC 26300: 2006. The last revision dates from 2015.The advantage [&hellip;]\" \/>\n<meta property=\"og:site_name\" content=\"DANS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Data-Archiving-and-Networked-Services-DANS-140231255994524\/\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-20T08:56:56+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@dans_knaw_nwo\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/file-formats\\\/spreadsheets\\\/ods\\\/\",\"url\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/file-formats\\\/spreadsheets\\\/ods\\\/\",\"name\":\"File formats: ODS | DANS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/#website\"},\"datePublished\":\"2021-09-20T08:56:54+00:00\",\"dateModified\":\"2021-09-20T08:56:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/file-formats\\\/spreadsheets\\\/ods\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/file-formats\\\/spreadsheets\\\/ods\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/file-formats\\\/spreadsheets\\\/ods\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"File formats\",\"item\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/file-formats\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Spreadsheets\",\"item\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/file-formats\\\/spreadsheets\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"ODS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/\",\"name\":\"DANS\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dans.knaw.nl\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"File formats: ODS | DANS","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:\/\/dans.knaw.nl\/en\/file-formats\/spreadsheets\/ods\/","og_locale":"en_US","og_type":"article","og_title":"File formats: ODS | DANS","og_description":"ODF is an ISO standardized format for office documents. For spreadsheets, it uses the .ods extension; the other two extensions are .odt for textual files and .odp for presentations. ODF files are essentially XML files that comply with the XML schema defined in ISO \/ IEC 26300: 2006. The last revision dates from 2015.The advantage [&hellip;]","og_site_name":"DANS","article_publisher":"https:\/\/www.facebook.com\/Data-Archiving-and-Networked-Services-DANS-140231255994524\/","article_modified_time":"2021-09-20T08:56:56+00:00","twitter_card":"summary_large_image","twitter_site":"@dans_knaw_nwo","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dans.knaw.nl\/en\/file-formats\/spreadsheets\/ods\/","url":"https:\/\/dans.knaw.nl\/en\/file-formats\/spreadsheets\/ods\/","name":"File formats: ODS | DANS","isPartOf":{"@id":"https:\/\/dans.knaw.nl\/en\/#website"},"datePublished":"2021-09-20T08:56:54+00:00","dateModified":"2021-09-20T08:56:56+00:00","breadcrumb":{"@id":"https:\/\/dans.knaw.nl\/en\/file-formats\/spreadsheets\/ods\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dans.knaw.nl\/en\/file-formats\/spreadsheets\/ods\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dans.knaw.nl\/en\/file-formats\/spreadsheets\/ods\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dans.knaw.nl\/en\/"},{"@type":"ListItem","position":2,"name":"File formats","item":"https:\/\/dans.knaw.nl\/en\/file-formats\/"},{"@type":"ListItem","position":3,"name":"Spreadsheets","item":"https:\/\/dans.knaw.nl\/en\/file-formats\/spreadsheets\/"},{"@type":"ListItem","position":4,"name":"ODS"}]},{"@type":"WebSite","@id":"https:\/\/dans.knaw.nl\/en\/#website","url":"https:\/\/dans.knaw.nl\/en\/","name":"DANS","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dans.knaw.nl\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages\/14051","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/comments?post=14051"}],"version-history":[{"count":1,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages\/14051\/revisions"}],"predecessor-version":[{"id":14052,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages\/14051\/revisions\/14052"}],"up":[{"embeddable":true,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages\/13058"}],"wp:attachment":[{"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/media?parent=14051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}