CINXE.COM

<!doctype html> <html class="client-nojs vector-feature-language-in-header-disabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-disabled skin-theme-clientpref-day vector-toc-available" lang="en" dir="ltr"> <head> <base href="https://www.mediawiki.org/wiki/Help:Tabular_Data"> <meta charset="UTF-8"> <title>Help:Tabular data - MediaWiki</title> <script>(function(){var className="client-js vector-feature-language-in-header-disabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-disabled skin-theme-clientpref-day vector-toc-available";var cookie=document.cookie.match(/(?:^|; )mediawikiwikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""], "wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"0a6deb95-7497-4f45-80fa-7280f83753e4","wgCanonicalNamespace":"Help","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":12,"wgPageName":"Help:Tabular_data","wgTitle":"Tabular data","wgCurRevisionId":6849228,"wgRevisionId":6849228,"wgArticleId":634643,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["Help","Extension help"],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Help:Tabular_data","wgRelevantArticleId":634643,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgRedirectedFrom":"Help:Tabular_Data","wgNoticeProject":"mediawiki","wgCiteReferencePreviewsActive":true,"wgMediaViewerOnClick":true, "wgMediaViewerEnabledByDefault":true,"wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":false,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":10000,"wgInternalRedirectTargetUrl":"/wiki/Help:Tabular_data","wgTranslatePageTranslation":"source","wgCentralAuthMobileDomain":false,"wgEditSubmitButtonLabelPublish":true,"wgDiscussionToolsFeaturesEnabled":{"replytool":true,"newtopictool":true,"sourcemodetoolbar":true,"topicsubscription":false,"autotopicsub":false,"visualenhancements":false,"visualenhancements_reply":false,"visualenhancements_pageframe":false},"wgDiscussionToolsFallbackEditMode":"visual","wgULSPosition":"personal","wgULSisCompactLinksEnabled":true,"wgVector2022LanguageInHeader":false,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q33981669","wgCheckUserClientHintsHeadersJsApi":["architecture","bitness","brands", "fullVersionList","mobile","model","platform","platformVersion"]};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.translate.tag.languages":"ready","ext.pygments":"ready","ext.discussionTools.init.styles":"ready","oojs-ui-core.styles":"ready","oojs-ui.styles.indicators":"ready","mediawiki.widgets.styles":"ready","oojs-ui-core.icons":"ready","skins.vector.search.codex.styles":"ready","skins.vector.styles":"ready","skins.vector.icons":"ready","ext.translate.edit.documentation.styles":"ready","ext.translate":"ready","ext.wikimediamessages.styles":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","ext.uls.pt":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["mediawiki.action.view.redirect","ext.pygments.view","site","mediawiki.page.ready","mediawiki.toc","skins.vector.js","ext.centralNotice.geoIP", "ext.centralNotice.startUp","ext.translate.pagetranslation.uls","ext.gadget.syntaxhighlight-copy","ext.urlShortener.toolbar","ext.centralauth.centralautologin","mmv.bootstrap","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.discussionTools.init","ext.eventLogging","ext.wikimediaEvents","ext.navigationTiming","ext.uls.compactlinks","ext.uls.interface","wikibase.client.vector-2022","ext.checkUser.clientHints","wikibase.sidebar.tracking"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=en&modules=ext.discussionTools.init.styles%7Cext.pygments%2Ctranslate%2CwikimediaBadges%7Cext.translate.edit.documentation.styles%7Cext.translate.tag.languages%7Cext.uls.pt%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediamessages.styles%7Cmediawiki.widgets.styles%7Coojs-ui-core.icons%2Cstyles%7Coojs-ui.styles.indicators%7Cskins.vector.icons%2Cstyles%7Cskins.vector.search.codex.styles%7Cwikibase.client.init&only=styles&skin=vector-2022"> <script async src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector-2022"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector-2022"> <meta name="generator" content="MediaWiki 1.44.0-wmf.3"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <meta property="og:site_name" content="MediaWiki"> <meta property="og:title" content="Help:Tabular data - MediaWiki"> <meta property="og:type" content="website"> <link rel="preconnect" href="//upload.wikimedia.org"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//m.mediawiki.org/wiki/Help:Tabular_data"> <link rel="alternate" type="application/x-wiki" title="Edit" href="/w/index.php?title=Help:Tabular_data&action=edit"> <link rel="apple-touch-icon" href="/static/apple-touch/mediawiki.png"> <link rel="icon" href="/static/favicon/mediawiki.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="MediaWiki (en)"> <link rel="EditURI" type="application/rsd+xml" href="//www.mediawiki.org/w/api.php?action=rsd"> <link rel="canonical" href="https://www.mediawiki.org/wiki/Help:Tabular_data"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/"> <link rel="alternate" type="application/atom+xml" title="MediaWiki Atom feed" href="/w/index.php?title=Special:RecentChanges&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org"> <link rel="dns-prefetch" href="//login.wikimedia.org"> <meta http-equiv="X-Translated-By" content="Google"> <meta http-equiv="X-Translated-To" content="en"> <script type="text/javascript" src="https://www.gstatic.com/_/translate_http/_/js/k=translate_http.tr.en_GB.1hbgkFx4Qn8.O/am=DgY/d=1/rs=AN8SPfqlmAPxwfG457BPbRXwNq39oSMGHg/m=corsproxy" data-sourceurl="https://www.mediawiki.org/wiki/Help:Tabular_Data"></script> <link href="https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@20..48,100..700,0..1,-50..200" rel="stylesheet"> <script type="text/javascript" src="https://www.gstatic.com/_/translate_http/_/js/k=translate_http.tr.en_GB.1hbgkFx4Qn8.O/am=DgY/d=1/exm=corsproxy/ed=1/rs=AN8SPfqlmAPxwfG457BPbRXwNq39oSMGHg/m=phishing_protection" data-phishing-protection-enabled="false" data-forms-warning-enabled="true" data-source-url="https://www.mediawiki.org/wiki/Help:Tabular_Data"></script> <meta name="robots" content="none"> </head> <body class="ext-discussiontools-replytool-enabled ext-discussiontools-newtopictool-enabled ext-discussiontools-sourcemodetoolbar-enabled skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-12 ns-subject mw-editable page-Help_Tabular_data rootpage-Help_Tabular_data skin-vector-2022 action-view"> <script type="text/javascript" src="https://www.gstatic.com/_/translate_http/_/js/k=translate_http.tr.en_GB.1hbgkFx4Qn8.O/am=DgY/d=1/exm=corsproxy,phishing_protection/ed=1/rs=AN8SPfqlmAPxwfG457BPbRXwNq39oSMGHg/m=navigationui" data-environment="prod" data-proxy-url="https://www-mediawiki-org.translate.goog" data-proxy-full-url="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" data-source-url="https://www.mediawiki.org/wiki/Help:Tabular_Data" data-source-language="auto" data-target-language="en" data-display-language="en-GB" data-detected-source-language="en" data-is-source-untranslated="false" data-source-untranslated-url="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://www.mediawiki.org/wiki/Help:Tabular_Data&anno=2" data-client="tr"></script><a class="mw-jump-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#bodyContent">Jump to content</a> <div class="vector-header-container"> <header class="vector-header mw-header"> <div class="vector-header-start"> <nav class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-dropdown" class="vector-dropdown vector-main-menu-dropdown vector-button-flush-left vector-button-flush-right"><input type="checkbox" id="vector-main-menu-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-main-menu-dropdown" class="vector-dropdown-checkbox " aria-label="Main menu"> <label id="vector-main-menu-dropdown-label" for="vector-main-menu-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true"><span class="vector-icon mw-ui-icon-menu mw-ui-icon-wikimedia-menu"></span> <span class="vector-dropdown-label-text">Main menu</span> </label> <div class="vector-dropdown-content"> <div id="vector-main-menu-unpinned-container" class="vector-unpinned-container"> <div id="vector-main-menu" class="vector-main-menu vector-pinnable-element"> <div class="vector-pinnable-header vector-main-menu-pinnable-header vector-pinnable-header-unpinned" data-feature-name="main-menu-pinned" data-pinnable-element-id="vector-main-menu" data-pinned-container-id="vector-main-menu-pinned-container" data-unpinned-container-id="vector-main-menu-unpinned-container"> <div class="vector-pinnable-header-label"> Main menu </div><button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-main-menu.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-main-menu.unpin">hide</button> </div> <div id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation"> <div class="vector-menu-heading"> Navigation </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage-description" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/MediaWiki?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Visit the main page [z]" accesskey="z"><span>Main page</span></a></li> <li id="n-mw-download" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Download?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Get MediaWiki</span></a></li> <li id="n-mw-extensions" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Category:Extensions?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Get extensions</span></a></li> <li id="n-blog-text" class="mw-list-item"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://techblog.wikimedia.org/"><span>Tech blog</span></a></li> <li id="n-mw-contribute" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/How_to_contribute?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Contribute</span></a></li> </ul> </div> </div> <div id="p-support" class="vector-menu mw-portlet mw-portlet-support"> <div class="vector-menu-heading"> Support </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-help" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Help:Contents?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="The place to find out"><span>User help</span></a></li> <li id="n-mw-faq" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Manual:FAQ?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>FAQ</span></a></li> <li id="n-mw-manual" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Manual:Contents?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Technical manual</span></a></li> <li id="n-mw-supportdesk" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Project:Support_desk?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Support desk</span></a></li> <li id="n-mw-communication" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Communication?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Communication</span></a></li> </ul> </div> </div> <div id="p-development" class="vector-menu mw-portlet mw-portlet-development"> <div class="vector-menu-heading"> Development </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mw-developerportal" class="mw-list-item"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://developer.wikimedia.org/"><span>Developer portal</span></a></li> <li id="n-svn-statistics" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Development_statistics?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Code statistics</span></a></li> </ul> </div> </div> <div id="p-mediawiki.org" class="vector-menu mw-portlet mw-portlet-mediawiki_org"> <div class="vector-menu-heading"> mediawiki.org </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-portal" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Project:Help?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="About the project, what you can do, where to find things"><span>Community portal</span></a></li> <li id="n-recentchanges" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:RecentChanges?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="A list of recent changes in the wiki [r]" accesskey="r"><span>Recent changes</span></a></li> <li id="n-mw-translate" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:LanguageStats?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Translate content</span></a></li> <li id="n-randompage" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:Random?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Load a random page [x]" accesskey="x"><span>Random page</span></a></li> <li id="n-mw-discussion" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Project:Village_Pump?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Village pump</span></a></li> <li id="n-Sandboxlink-portlet-label" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Project:Sandbox?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Sandbox</span></a></li> </ul> </div> </div> <div id="p-lang" class="vector-menu mw-portlet mw-portlet-lang"> <div class="vector-menu-heading"> In other languages </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> <div class="after-portlet after-portlet-lang"> <span class="wb-langlinks-add wb-langlinks-link"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://www.wikidata.org/wiki/Special:EntityPage/Q33981669%23sitelinks-wikipedia" title="Add interlanguage links" class="wbc-editpage">Add links</a></span> </div> </div> </div> </div> </div> </div> </div> </nav><a href="https://www-mediawiki-org.translate.goog/wiki/MediaWiki?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-logo"> <img class="mw-logo-icon" src="/static/images/icons/mediawikiwiki.svg" alt="" aria-hidden="true" height="50" width="50"> <span class="mw-logo-container skin-invert"> <img class="mw-logo-wordmark" alt="MediaWiki" src="/static/images/mobile/copyright/mediawikiwiki-wordmark.svg" style="width: 7.5em; height: 1.125em;"> </span> </a> </div> <div class="vector-header-end"> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-collapses vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:Search?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only search-toggle" title="Search MediaWiki [f]" accesskey="f"><span class="vector-icon mw-ui-icon-search mw-ui-icon-wikimedia-search"></span> <span>Search</span> </a> <div class="vector-typeahead-search-container"> <div class="cdx-typeahead-search cdx-typeahead-search--show-thumbnail cdx-typeahead-search--auto-expand-width"> <form action="/w/index.php" id="searchform" class="cdx-search-input cdx-search-input--has-end-button"> <div id="simpleSearch" class="cdx-search-input__input-wrapper" data-search-loc="header-moved"> <div class="cdx-text-input cdx-text-input--has-start-icon"><input class="cdx-text-input__input" type="search" name="search" placeholder="Search MediaWiki" aria-label="Search MediaWiki" autocapitalize="sentences" title="Search MediaWiki [f]" accesskey="f" id="searchInput"> <span class="cdx-text-input__icon cdx-text-input__start-icon"></span> </div><input type="hidden" name="title" value="Special:Search"> </div><button class="cdx-button cdx-search-input__end-button">Search</button> </form> </div> </div> </div> <nav class="vector-user-links vector-user-links-wide" aria-label="Personal tools"> <div class="vector-user-links-main"> <div id="p-vector-user-menu-preferences" class="vector-menu mw-portlet"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-uls" class="mw-list-item active user-links-collapsible-item"><a data-mw="interface" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#" class="uls-trigger cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet"><span class="vector-icon mw-ui-icon-wikimedia-language mw-ui-icon-wikimedia-wikimedia-language"></span> <span>English</span></a></li> </ul> </div> </div> <div id="p-vector-user-menu-userpage" class="vector-menu mw-portlet emptyPortlet"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-dropdown" class="vector-dropdown " title="Change the appearance of the page's font size, width, and color"><input type="checkbox" id="vector-appearance-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-appearance-dropdown" class="vector-dropdown-checkbox " aria-label="Appearance"> <label id="vector-appearance-dropdown-label" for="vector-appearance-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true"><span class="vector-icon mw-ui-icon-appearance mw-ui-icon-wikimedia-appearance"></span> <span class="vector-dropdown-label-text">Appearance</span> </label> <div class="vector-dropdown-content"> <div id="vector-appearance-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <div id="p-vector-user-menu-notifications" class="vector-menu mw-portlet emptyPortlet"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-overflow" class="vector-menu mw-portlet"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://donate.wikimedia.org/?utm_source%3Ddonate%26utm_medium%3Dsidebar%26utm_campaign%3Dspontaneous%26uselang%3Den" class=""><span>Donate</span></a></li> <li id="pt-createaccount-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="https://www-mediawiki-org.translate.goog/w/index.php?title=Special:CreateAccount&returnto=Help:Tabular+data&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="You are encouraged to create an account and log in; however, it is not mandatory" class=""><span>Create account</span></a></li> <li id="pt-login-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="https://www-mediawiki-org.translate.goog/w/index.php?title=Special:UserLogin&returnto=Help:Tabular+data&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o" class=""><span>Log in</span></a></li> </ul> </div> </div> </div> <div id="vector-user-links-dropdown" class="vector-dropdown vector-user-menu vector-button-flush-right vector-user-menu-logged-out" title="More options"><input type="checkbox" id="vector-user-links-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-user-links-dropdown" class="vector-dropdown-checkbox " aria-label="Personal tools"> <label id="vector-user-links-dropdown-label" for="vector-user-links-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true"><span class="vector-icon mw-ui-icon-ellipsis mw-ui-icon-wikimedia-ellipsis"></span> <span class="vector-dropdown-label-text">Personal tools</span> </label> <div class="vector-dropdown-content"> <div id="p-personal" class="vector-menu mw-portlet mw-portlet-personal user-links-collapsible-item" title="User menu"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport" class="user-links-collapsible-item mw-list-item"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://donate.wikimedia.org/?utm_source%3Ddonate%26utm_medium%3Dsidebar%26utm_campaign%3Dspontaneous%26uselang%3Den"><span>Donate</span></a></li> <li id="pt-createaccount" class="user-links-collapsible-item mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Special:CreateAccount&returnto=Help:Tabular+data&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="You are encouraged to create an account and log in; however, it is not mandatory"><span class="vector-icon mw-ui-icon-userAdd mw-ui-icon-wikimedia-userAdd"></span> <span>Create account</span></a></li> <li id="pt-login" class="user-links-collapsible-item mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Special:UserLogin&returnto=Help:Tabular+data&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o"><span class="vector-icon mw-ui-icon-logIn mw-ui-icon-wikimedia-logIn"></span> <span>Log in</span></a></li> </ul> </div> </div> <div id="p-user-menu-anon-editor" class="vector-menu mw-portlet mw-portlet-user-menu-anon-editor"> <div class="vector-menu-heading"> Pages for logged out editors <a href="https://www-mediawiki-org.translate.goog/wiki/Help:Introduction?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" aria-label="Learn more about editing"><span>learn more</span></a> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-anoncontribs" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyContributions?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="A list of edits made from this IP address [y]" accesskey="y"><span>Contributions</span></a></li> <li id="pt-anontalk" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyTalk?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Discussion about edits from this IP address [n]" accesskey="n"><span>Talk</span></a></li> </ul> </div> </div> </div> </div> </nav> </div> </header> </div> <div class="mw-page-container"> <div class="mw-page-container-inner"> <div class="vector-sitenotice-container"> <div id="siteNotice">  </div> </div> <div class="vector-column-start"> <div class="vector-main-menu-container"> <div id="mw-navigation"> <nav id="mw-panel" class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-pinned-container" class="vector-pinned-container"> </div> </nav> </div> </div> <div class="vector-sticky-pinned-container"> <nav id="mw-panel-toc" aria-label="Contents" data-event-name="ui.sidebar-toc" class="mw-table-of-contents-container vector-toc-landmark"> <div id="vector-toc-pinned-container" class="vector-pinned-container"> <div id="vector-toc" class="vector-toc vector-pinnable-element"> <div class="vector-pinnable-header vector-toc-pinnable-header vector-pinnable-header-pinned" data-feature-name="toc-pinned" data-pinnable-element-id="vector-toc"> <h2 class="vector-pinnable-header-label">Contents</h2><button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-toc.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-toc.unpin">hide</button> </div> <ul class="vector-toc-contents" id="mw-panel-toc-list"> <li id="toc-mw-content-text" class="vector-toc-list-item vector-toc-level-1"><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#" class="vector-toc-link"> <div class="vector-toc-text"> Beginning </div></a></li> <li id="toc-Data_licensing" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#Data_licensing"> <div class="vector-toc-text"><span class="vector-toc-numb">1</span> <span>Data licensing</span> </div></a> <ul id="toc-Data_licensing-sublist" class="vector-toc-list"> </ul></li> <li id="toc-Data_types" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#Data_types"> <div class="vector-toc-text"><span class="vector-toc-numb">2</span> <span>Data types</span> </div></a> <ul id="toc-Data_types-sublist" class="vector-toc-list"> </ul></li> <li id="toc-Top-level_fields" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#Top-level_fields"> <div class="vector-toc-text"><span class="vector-toc-numb">3</span> <span>Top-level fields</span> </div></a> <ul id="toc-Top-level_fields-sublist" class="vector-toc-list"> </ul></li> <li id="toc-Usage" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#Usage"> <div class="vector-toc-text"><span class="vector-toc-numb">4</span> <span>Usage</span> </div></a> <ul id="toc-Usage-sublist" class="vector-toc-list"> </ul></li> <li id="toc-Example" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#Example"> <div class="vector-toc-text"><span class="vector-toc-numb">5</span> <span>Example</span> </div></a> <ul id="toc-Example-sublist" class="vector-toc-list"> </ul></li> <li id="toc-Restrictions_and_gotchas" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#Restrictions_and_gotchas"> <div class="vector-toc-text"><span class="vector-toc-numb">6</span> <span>Restrictions and gotchas</span> </div></a> <ul id="toc-Restrictions_and_gotchas-sublist" class="vector-toc-list"> </ul></li> <li id="toc-Admin_notes" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#Admin_notes"> <div class="vector-toc-text"><span class="vector-toc-numb">7</span> <span>Admin notes</span> </div></a> <ul id="toc-Admin_notes-sublist" class="vector-toc-list"> </ul></li> <li id="toc-Converting_data_to_JSON" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#Converting_data_to_JSON"> <div class="vector-toc-text"><span class="vector-toc-numb">8</span> <span>Converting data to JSON</span> </div></a> <button aria-controls="toc-Converting_data_to_JSON-sublist" class="cdx-button cdx-button--weight-quiet cdx-button--icon-only vector-toc-toggle"> <span class="vector-icon mw-ui-icon-wikimedia-expand"></span> <span>Toggle Converting data to JSON subsection</span> </button> <ul id="toc-Converting_data_to_JSON-sublist" class="vector-toc-list"> <li id="toc-CSV_and_TSV" class="vector-toc-list-item vector-toc-level-2"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#CSV_and_TSV"> <div class="vector-toc-text"><span class="vector-toc-numb">8.1</span> <span>CSV and TSV</span> </div></a> <ul id="toc-CSV_and_TSV-sublist" class="vector-toc-list"> </ul></li> <li id="toc-XLS" class="vector-toc-list-item vector-toc-level-2"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#XLS"> <div class="vector-toc-text"><span class="vector-toc-numb">8.2</span> <span>XLS</span> </div></a> <ul id="toc-XLS-sublist" class="vector-toc-list"> </ul></li> </ul></li> <li id="toc-See_also" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"><a class="vector-toc-link" href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#See_also"> <div class="vector-toc-text"><span class="vector-toc-numb">9</span> <span>See also</span> </div></a> <ul id="toc-See_also-sublist" class="vector-toc-list"> </ul></li> </ul> </div> </div> </nav> </div> </div> <div class="mw-content-container"> <main id="content" class="mw-body"> <header class="mw-body-header vector-page-titlebar"> <nav aria-label="Contents" class="vector-toc-landmark"> <div id="vector-page-titlebar-toc" class="vector-dropdown vector-page-titlebar-toc vector-button-flush-left"><input type="checkbox" id="vector-page-titlebar-toc-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-titlebar-toc" class="vector-dropdown-checkbox " aria-label="Toggle the table of contents"> <label id="vector-page-titlebar-toc-label" for="vector-page-titlebar-toc-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true"><span class="vector-icon mw-ui-icon-listBullet mw-ui-icon-wikimedia-listBullet"></span> <span class="vector-dropdown-label-text">Toggle the table of contents</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-titlebar-toc-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-namespace">Help</span><span class="mw-page-title-separator">:</span><span class="mw-page-title-main">Tabular data</span></h1> <div class="mw-indicators"> </div> </header> <div class="vector-page-toolbar"> <div class="vector-page-toolbar-container"> <div id="left-navigation"> <nav aria-label="Namespaces"> <div id="p-associated-pages" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-associated-pages"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-help" class="selected vector-tab-noicon mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="View the help page [c]" accesskey="c"><span>Help</span></a></li> <li id="ca-talk" class="vector-tab-noicon mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Help_talk:Tabular_data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" rel="discussion" title="Discussion about the content page [t]" accesskey="t"><span>Discussion</span></a></li> </ul> </div> </div> <div id="vector-variants-dropdown" class="vector-dropdown emptyPortlet"><input type="checkbox" id="vector-variants-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-variants-dropdown" class="vector-dropdown-checkbox " aria-label="Change language variant"> <label id="vector-variants-dropdown-label" for="vector-variants-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true"><span class="vector-dropdown-label-text">English</span> </label> <div class="vector-dropdown-content"> <div id="p-variants" class="vector-menu mw-portlet mw-portlet-variants emptyPortlet"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> </div> </div> </nav> </div> <div id="right-navigation" class="vector-collapsible"> <nav aria-label="Views"> <div id="p-views" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-views"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected vector-tab-noicon mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Read</span></a></li> <li id="ca-edit" class="vector-tab-noicon mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit the source code of this page [e]" accesskey="e"><span>Edit</span></a></li> <li id="ca-history" class="vector-tab-noicon mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=history&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Past revisions of this page [h]" accesskey="h"><span>View history</span></a></li> </ul> </div> </div> </nav> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-dropdown" class="vector-dropdown vector-page-tools-dropdown"><input type="checkbox" id="vector-page-tools-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-tools-dropdown" class="vector-dropdown-checkbox " aria-label="Tools"> <label id="vector-page-tools-dropdown-label" for="vector-page-tools-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true"><span class="vector-dropdown-label-text">Tools</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-tools-unpinned-container" class="vector-unpinned-container"> <div id="vector-page-tools" class="vector-page-tools vector-pinnable-element"> <div class="vector-pinnable-header vector-page-tools-pinnable-header vector-pinnable-header-unpinned" data-feature-name="page-tools-pinned" data-pinnable-element-id="vector-page-tools" data-pinned-container-id="vector-page-tools-pinned-container" data-unpinned-container-id="vector-page-tools-unpinned-container"> <div class="vector-pinnable-header-label"> Tools </div><button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-page-tools.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-page-tools.unpin">hide</button> </div> <div id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-has-collapsible-items" title="More options"> <div class="vector-menu-heading"> Actions </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-more-view" class="selected vector-more-collapsible-item mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Read</span></a></li> <li id="ca-more-edit" class="vector-more-collapsible-item mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit the source code of this page [e]" accesskey="e"><span>Edit</span></a></li> <li id="ca-more-history" class="vector-more-collapsible-item mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=history&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>View history</span></a></li> </ul> </div> </div> <div id="p-tb" class="vector-menu mw-portlet mw-portlet-tb"> <div class="vector-menu-heading"> General </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:WhatLinksHere/Help:Tabular_data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="A list of all wiki pages that link here [j]" accesskey="j"><span>What links here</span></a></li> <li id="t-recentchangeslinked" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:RecentChangesLinked/Help:Tabular_data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></a></li> <li id="t-upload" class="mw-list-item"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://commons.wikimedia.org/wiki/Special:UploadWizard" title="Upload files [u]" accesskey="u"><span>Upload file</span></a></li> <li id="t-specialpages" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:SpecialPages?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="A list of all special pages [q]" accesskey="q"><span>Special pages</span></a></li> <li id="t-permalink" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&oldid=6849228&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li> <li id="t-info" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=info&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="More information about this page"><span>Page information</span></a></li> <li id="t-urlshortener" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Special:UrlShortener&url=https://www.mediawiki.org/wiki/Help:Tabular_data&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Get shortened URL</span></a></li> <li id="t-urlshortener-qrcode" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Special:QrCode&url=https://www.mediawiki.org/wiki/Help:Tabular_data&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Download QR code</span></a></li> </ul> </div> </div> <div id="p-coll-print_export" class="vector-menu mw-portlet mw-portlet-coll-print_export"> <div class="vector-menu-heading"> Print/export </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-create_a_book" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Special:Book&bookcmd=book_creator&referer=Help:Tabular+data&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Create a book</span></a></li> <li id="coll-download-as-rl" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Special:DownloadAsPdf&page=Help:Tabular_data&action=show-download-screen&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB"><span>Download as PDF</span></a></li> <li id="t-print" class="mw-list-item"><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&printable=yes&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></a></li> </ul> </div> </div> <div id="p-wikibase-otherprojects" class="vector-menu mw-portlet mw-portlet-wikibase-otherprojects"> <div class="vector-menu-heading"> In other projects </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="wb-otherproject-link wb-otherproject-commons mw-list-item"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://commons.wikimedia.org/wiki/Help:Tabular_Data" hreflang="en"><span>Wikimedia Commons</span></a></li> <li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://www.wikidata.org/wiki/Special:EntityPage/Q33981669" title="Link to connected data repository item [g]" accesskey="g"><span>Wikidata item</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> </div> </div> </div> <div class="vector-column-end"> <div class="vector-sticky-pinned-container"> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-pinned-container" class="vector-pinned-container"> </div> </nav> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-pinned-container" class="vector-pinned-container"> <div id="vector-appearance" class="vector-appearance vector-pinnable-element"> <div class="vector-pinnable-header vector-appearance-pinnable-header vector-pinnable-header-pinned" data-feature-name="appearance-pinned" data-pinnable-element-id="vector-appearance" data-pinned-container-id="vector-appearance-pinned-container" data-unpinned-container-id="vector-appearance-unpinned-container"> <div class="vector-pinnable-header-label"> Appearance </div><button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-appearance.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-appearance.unpin">hide</button> </div> </div> </div> </nav> </div> </div> <div id="bodyContent" class="vector-body" aria-labelledby="firstHeading" data-mw-ve-target-container> <div class="vector-body-before-content"> <div id="siteSub" class="noprint"> From mediawiki.org </div> </div> <div id="contentSub"> <div id="mw-content-subtitle"> <span class="mw-redirectedfrom">(Redirected from <a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_Data&redirect=no&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-redirect" title="Help:Tabular Data">Help:Tabular Data</a>)</span> </div> </div> <div id="mw-content-text" class="mw-body-content"> <div class="mw-pt-translate-header noprint nomobile" dir="ltr" lang="en"> <a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Special:Translate&group=page-Help:Tabular+data&action=page&filter&action_source=translate_page&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Special:Translate">Translate this page</a> </div> <div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr"> <div class="mw-pt-languages noprint navigation-not-searchable" lang="en" dir="ltr"> <div class="mw-pt-languages-label"> Languages: </div> <ul class="mw-pt-languages-list"> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/de?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--complete" title="Hilfe:Tabellarische Daten (100% translated)" lang="de" dir="ltr">Deutsch</a></li> <li><span class="mw-pt-languages-ui mw-pt-languages-selected mw-pt-progress mw-pt-progress--complete" lang="en" dir="ltr">English</span></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/ca?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--low" title="Ajuda:Dades tabulars (14% translated)" lang="ca" dir="ltr">català</a></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/es?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--med" title="Ayuda:Datos tabulados (19% translated)" lang="es" dir="ltr">español</a></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/fr?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--complete" title="Aide:Données tabulaires (100% translated)" lang="fr" dir="ltr">français</a></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/pl?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--low" title="Pomoc:Dane tabelaryczne (12% translated)" lang="pl" dir="ltr">polski</a></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/pt-br?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--low" title="Ajuda:Dados Tabulares (14% translated)" lang="pt-BR" dir="ltr">português do Brasil</a></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/sv?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--high" title="Hjälp:Tabelldata (99% translated)" lang="sv" dir="ltr">svenska</a></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/ru?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--low" title="Help:Tabular data/ru (1% translated)" lang="ru" dir="ltr">русский</a></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/zh?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--low" title="Help:Tabular data/zh (1% translated)" lang="zh" dir="ltr">中文</a></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Tabular_data/ja?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="mw-pt-progress mw-pt-progress--low" title="Help:Tabular data/ja (4% translated)" lang="ja" dir="ltr">日本語</a></li> </ul> </div> <div style="clear: right; margin-bottom: .5em; float: right; margin-left:2em; width: auto;"> <meta property="mw:PageProp/toc"> </div> <style data-mw-deduplicate="TemplateStyles:r6776268">.mw-parser-output .template-pd-help-page{color:var(--color-emphasized,#101418);border:solid 1px var(--border-color-base,#a2a9b1);padding:0.5em;margin:0.5em 0;background-color:var(--background-color-base,#ffffff);font-size:95%;vertical-align:middle;width:100%;box-sizing:border-box}.mw-parser-output .template-pd-help-page .icon-cell{padding:0 1em;width:30px}</style> <table class="template-pd-help-page"> <tbody> <tr> <td class="icon-cell"><span typeof="mw:File"><span><img alt="PD" src="//upload.wikimedia.org/wikipedia/commons/thumb/6/62/PD-icon.svg/30px-PD-icon.svg.png" decoding="async" width="30" height="30" class="mw-file-element" srcset="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://upload.wikimedia.org/wikipedia/commons/thumb/6/62/PD-icon.svg/45px-PD-icon.svg.png 1.5x,https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://upload.wikimedia.org/wikipedia/commons/thumb/6/62/PD-icon.svg/60px-PD-icon.svg.png 2x" data-file-width="196" data-file-height="196"></span></span></td> <td><b>Note:</b> When you edit this page, you agree to release your contribution under the <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/publicdomain/zero/1.0/">CC0</a>. See <a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Project:PD_help?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Special:MyLanguage/Project:PD help">Public Domain Help Pages</a> for more info.</td> <td class="icon-cell"><span typeof="mw:File"><span><img alt="PD" src="//upload.wikimedia.org/wikipedia/commons/thumb/6/62/PD-icon.svg/30px-PD-icon.svg.png" decoding="async" width="30" height="30" class="mw-file-element" srcset="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://upload.wikimedia.org/wikipedia/commons/thumb/6/62/PD-icon.svg/45px-PD-icon.svg.png 1.5x,https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://upload.wikimedia.org/wikipedia/commons/thumb/6/62/PD-icon.svg/60px-PD-icon.svg.png 2x" data-file-width="196" data-file-height="196"></span></span></td> </tr> </tbody> </table> <p>Tabular data allows users to create CSV-like tables of data, and use them from other wikis to create automatic tables, lists, and graphs.</p> <p>To create a new table, go to <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://commons.wikimedia.org/wiki/" class="extiw" title="commons:">Wikimedia Commons</a>, and create a new page in the <b>Data</b> namespace with a <b>.tab</b> suffix, such as <code>Data:Sandbox/Name/Example.tab</code>. Feel free to experiment by creating pages with the <b>Sandbox/<username>/</b> prefix. For now, page content can only be edited in the raw <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://en.wikipedia.org/wiki/JSON" class="extiw" title="w:JSON">JSON format</a> and with a basic table editor, but <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://commons.wikimedia.org/wiki/MediaWiki_talk:Gadget-TabularImportExport.js" class="extiw" title="commons:MediaWiki talk:Gadget-TabularImportExport.js">a gadget</a> allows import/export from/to CSV and Excel files. Eventually (written 21 November 2016), we hope there will be a spreadsheet-like editor to simplify data editing.</p> <p>The underlying data format largely matches the <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://specs.frictionlessdata.io/tabular-data-resource/">Frictionless Data standard for a tabular data resource</a>.</p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"> <h2 id="Data_licensing" data-mw-thread-id="h-Data_licensing"><span data-mw-comment-start="" id="h-Data_licensing"></span>Data licensing<span data-mw-comment-end="h-Data_licensing"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=1&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: Data licensing"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <p>All data in the <code>Data:</code> namespace must explicitly indicate the license of the data. The recommended license is Public Domain, licensed under <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/publicdomain/zero/1.0/">Creative Commons Zero (CC0)</a> license. To indicate this, every data page must have <code>"license": "CC0-1.0"</code>, which means the data can be used under the CC0 version 1.0, or (at your option) any later version. By editing the data, you <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://foundation.wikimedia.org/wiki/Terms_of_Use" class="extiw" title="foundation:Terms of Use">agree to the Terms of Use</a>, and you irrevocably agree to release your contribution to the public domain under CC0.</p> <p>If it isn't possible to release the data under CC0, the following licenses are also supported:</p> <ul> <li>CC-BY: <ul> <li>CC-BY-1.0: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by/1.0/">Creative Commons Attribution 1.0</a></li> <li>CC-BY-2.0: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by/2.0/">Creative Commons Attribution 2.0</a></li> <li>CC-BY-2.5: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by/2.5/">Creative Commons Attribution 2.5</a></li> <li>CC-BY-3.0: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by/3.0/">Creative Commons Attribution 3.0</a></li> <li>CC-BY-4.0: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by/4.0/">Creative Commons Attribution 4.0</a></li> <li>CC-BY-4.0+: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by/4.0/">Creative Commons Attribution 4.0 or later version</a></li> </ul></li> <li>CC-BY-SA <ul> <li>CC-BY-SA-1.0: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by-sa/1.0/">Creative Commons Attribution-Share Alike 1.0</a></li> <li>CC-BY-SA-2.0: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by-sa/2.0/">Creative Commons Attribution-Share Alike 2.0</a></li> <li>CC-BY-SA-2.5: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by-sa/2.5/">Creative Commons Attribution-Share Alike 2.5</a></li> <li>CC-BY-SA-3.0: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by-sa/3.0/">Creative Commons Attribution-Share Alike 3.0</a></li> <li>CC-BY-SA-4.0: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by-sa/4.0/">Creative Commons Attribution-Share Alike 4.0</a></li> <li>CC-BY-SA-4.0+: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by-sa/4.0/">Creative Commons Attribution-Share Alike 4.0 or later version</a></li> </ul></li> <li>ODbL-1.0 <ul> <li>ODbL-1.0: <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://opendatacommons.org/licenses/odbl/summary/">ODC Open Database License v1.0</a></li> </ul></li> </ul> <p>Any templates that pull data from non-CC0 licensed datasets need to comply with the relevant attribution terms, hence it is highly encouraged to prefer CC0 whenever possible.</p> <p>At some future time, the list of licenses supported by the Data namespace may be expanded.</p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"> <h2 id="Data_types" data-mw-thread-id="h-Data_types"><span data-mw-comment-start="" id="h-Data_types"></span>Data types<span data-mw-comment-end="h-Data_types"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=2&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: Data types"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <p>Tabular JSON data supports several basic value types. You may also use <code>null</code> instead of the value to mark it as missing.</p> <ul> <li><code>number</code> – A numeric value with an optional fractional part and may use exponential <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://en.wikipedia.org/wiki/E_notation" class="extiw" title="wikipedia:E notation">E notation</a>, but cannot include non-numbers like <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://en.wikipedia.org/wiki/NaN" class="extiw" title="wikipedia:NaN">NaN</a>.</li> <li><code>boolean</code> – only allows <code>true</code> and <code>false</code> values.</li> <li><code>string</code> – a text string no longer than 400 characters long. Special characters like new lines <code>\n</code> and tabs <code>\t</code> are not allowed.</li> <li><code>localized</code> – A multilingual string, represented as an object with keys being language codes (e.g. "en"), and values being a string with above limitations of 400 max chars. For example, <code>{"en":"string in English", "fr":"chaîne de texte en français", ...}</code> has string values for both English and French.</li> </ul> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"> <h2 id="Top-level_fields" data-mw-thread-id="h-Top-level_fields"><span data-mw-comment-start="" id="h-Top-level_fields"></span>Top-level fields<span data-mw-comment-end="h-Top-level_fields"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=3&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: Top-level fields"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <p>Tabular data has several required and optional top-level elements:</p> <ul> <li><code>license</code> – <b>required</b> field, must always be set to <code>"CC0-1.0"</code> string value. For now, tabular data only supports <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://en.wikipedia.org/wiki/Creative_Commons_license%23Zero_.2F_public_domain" class="extiw" title="en:Creative Commons license">CC0</a> (Public Domain dedication) license version 1.0 or later. More license support may be available in the future.</li> <li><code>schema: {"fields": [{...}, {...}, ...]}</code> – <b>required</b> field, must set to an object that contains a list. Each field describes a column of the tabular data. Each field must be an object with mandatory <code>"name"</code> and <code>"type"</code> values. <ul> <li><code>name</code> – <b>required</b> field, is the name of the column. The value must begin with a letter or an underscore <code>"_"</code>, and must only contain letters, underscores, or digits. This is done so that each header can be easily used from a coding environment like Lua or Vega graphs.</li> <li><code>type</code> – <b>required</b> field, must be set to one of these values: <code>"number"</code>, <code>"boolean"</code>, <code>"string"</code>, or <code>"localized"</code>.</li> <li><code>title</code> – <b>optional</b> field, is an optional translation for the column's header. If set, it must be a localized string object.</li> </ul></li> <li><code>data</code> – <b>required</b> field, must always be set to a list of lists. Each sub-list must have the same number of elements as headers, and must match the value types.</li> <li><code>description</code> – <b>optional</b> field, must be set to a localized string value - an object with at least one key-value, where the key is a language code (e.g. "en"), and the value is a description string.</li> <li><code>sources</code> – <b>optional</b> field, must be a Wiki markup string value that describes the source of the data.</li> </ul> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"> <h2 id="Usage" data-mw-thread-id="h-Usage"><span data-mw-comment-start="" id="h-Usage"></span>Usage<span data-mw-comment-end="h-Usage"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=4&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: Usage"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <p>There are two ways to use this data:</p> <ul> <li>A Lua script on any wiki can get this data by calling <code>mw.ext.data.get("Example.tab")</code>. The function returns tabular data in almost the same format as the original JSON, except that all localized strings will be converted to regular strings, and the license field will also include a localized license name. To get the data in another language, pass language code as the second parameter. To get the data in the original, unmodified form, use "_" as the language code.</li> <li>A Vega graph can get tabular data by using <code>"tabular:///Example.tab"</code> as the data source url.</li> </ul> <p>On Commons, transcluding a page from the Data namespace, i.e. <code>{{Data:Example.tab}}</code>, will render it as an HTML table. To access data directly on a wiki page, you can import (if you don't already have them) the <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://en.wikipedia.org/wiki/Module:Tabular_data" class="extiw" title="w:Module:Tabular data">tabular data module</a> (requires the <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://en.wikipedia.org/wiki/Module:Navbar" class="extiw" title="w:Module:Navbar">navbar module</a>) and optionally the <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://en.wikipedia.org/wiki/Template:Tabular_query" class="extiw" title="w:Template:Tabular query">tabular query</a> template (requires the before mentioned tabular data module). With these tools you can easily get the value of a single cell.</p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"> <h2 id="Example" data-mw-thread-id="h-Example"><span data-mw-comment-start="" id="h-Example"></span>Example<span data-mw-comment-end="h-Example"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=5&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: Example"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <div class="mw-highlight mw-highlight-lang-json mw-content-ltr" dir="ltr"> <pre><span></span><span class="p">{</span> <span class="w"> </span><span class="nt">"license"</span><span class="p">:</span><span class="w"> </span><span class="s2">"CC0-1.0"</span><span class="p">,</span> <span class="w"> </span><span class="nt">"description"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span> <span class="w"> </span><span class="nt">"en"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Some good fruits for you"</span><span class="p">,</span> <span class="w"> </span><span class="nt">"es"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Algunas buenas frutas para ti"</span> <span class="w"> </span><span class="p">},</span> <span class="w"> </span><span class="nt">"sources"</span><span class="p">:</span><span class="w"> </span><span class="s2">"http://example.com and [[Data]] page"</span><span class="p">,</span> <span class="w"> </span><span class="nt">"schema"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span> <span class="w"> </span><span class="nt">"fields"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span> <span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="nt">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"id"</span><span class="p">,</span><span class="w"> </span><span class="nt">"type"</span><span class="p">:</span><span class="w"> </span><span class="s2">"string"</span><span class="p">,</span><span class="w"> </span><span class="nt">"title"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="nt">"en"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Fruit ID"</span><span class="p">,</span><span class="w"> </span><span class="nt">"fr"</span><span class="p">:</span><span class="w"> </span><span class="s2">"ID de fruit"</span><span class="w"> </span><span class="p">}},</span> <span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="nt">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"count"</span><span class="p">,</span><span class="w"> </span><span class="nt">"type"</span><span class="p">:</span><span class="w"> </span><span class="s2">"number"</span><span class="p">,</span><span class="w"> </span><span class="nt">"title"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="nt">"en"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Count"</span><span class="p">,</span><span class="w"> </span><span class="nt">"fr"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Décompte"</span><span class="w"> </span><span class="p">}},</span> <span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="nt">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"liked"</span><span class="p">,</span><span class="w"> </span><span class="nt">"type"</span><span class="p">:</span><span class="w"> </span><span class="s2">"boolean"</span><span class="p">,</span><span class="w"> </span><span class="nt">"title"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="nt">"en"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Do I like it?"</span><span class="p">,</span><span class="w"> </span><span class="nt">"fr"</span><span class="p">:</span><span class="w"> </span><span class="s2">"L’aimes-tu ?"</span><span class="w"> </span><span class="p">}},</span> <span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="nt">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"description"</span><span class="p">,</span><span class="w"> </span><span class="nt">"type"</span><span class="p">:</span><span class="w"> </span><span class="s2">"localized"</span><span class="p">,</span><span class="w"> </span><span class="nt">"title"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="nt">"en"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Fruit name"</span><span class="p">,</span><span class="w"> </span><span class="nt">"fr"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Nom du fruit"</span><span class="w"> </span><span class="p">}}</span> <span class="w"> </span><span class="p">]</span> <span class="w"> </span><span class="p">},</span> <span class="w"> </span><span class="nt">"data"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span> <span class="w"> </span><span class="p">[</span> <span class="w"> </span><span class="s2">"peaches"</span><span class="p">,</span> <span class="w"> </span><span class="mi">100</span><span class="p">,</span> <span class="w"> </span><span class="kc">true</span><span class="p">,</span> <span class="w"> </span><span class="p">{</span> <span class="w"> </span><span class="nt">"en"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Magnificent but a bit artificial sweet peaches"</span><span class="p">,</span> <span class="w"> </span><span class="nt">"es"</span><span class="p">:</span><span class="w"> </span><span class="s2">"esto puede estar en español"</span><span class="p">,</span> <span class="w"> </span><span class="nt">"fr"</span><span class="p">:</span><span class="w"> </span><span class="s2">"Magnifiques mais ce sont des pêches un tantinet sucrées"</span> <span class="w"> </span><span class="p">}</span> <span class="w"> </span><span class="p">],</span> <span class="w"> </span><span class="err">⋮</span> <span class="w"> </span><span class="p">]</span> <span class="p">}</span> </pre> </div> <p>See <a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://commons.wikimedia.org/wiki/Data:COVID-19_cases_in_Santa_Clara_County,_California.tab" class="extiw" title="c:Data:COVID-19 cases in Santa Clara County, California.tab">c:Data:COVID-19 cases in Santa Clara County, California.tab</a> for an example of how the JSON data renders on Commons.</p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"> <h2 id="Restrictions_and_gotchas" data-mw-thread-id="h-Restrictions_and_gotchas"><span data-mw-comment-start="" id="h-Restrictions_and_gotchas"></span>Restrictions and gotchas<span data-mw-comment-end="h-Restrictions_and_gotchas"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=6&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: Restrictions and gotchas"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <ul> <li>Each string value except the <code>"sources"</code> must be no more than 400 symbols long. Special characters like new lines <code>\n</code> and tabs <code>\t</code> are not allowed.</li> <li>The overall size of the page may not exceed 2MB.</li> </ul> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"> <h2 id="Admin_notes" data-mw-thread-id="h-Admin_notes"><span data-mw-comment-start="" id="h-Admin_notes"></span>Admin notes<span data-mw-comment-end="h-Admin_notes"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=7&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: Admin notes"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <ul> <li>Site administrators may customize error messages, such as <code><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://commons.wikimedia.org/wiki/MediaWiki:Jsonconfig-err-license" class="extiw" title="commons:MediaWiki:Jsonconfig-err-license">jsonconfig-err-license</a></code> to make sure editors know about the CC0-only limitation.</li> </ul> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"> <h2 id="Converting_data_to_JSON" data-mw-thread-id="h-Converting_data_to_JSON"><span data-mw-comment-start="" id="h-Converting_data_to_JSON"></span>Converting data to JSON<span data-mw-comment-end="h-Converting_data_to_JSON"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=8&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: Converting data to JSON"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <p>There are several tools available for converting other formats to JSON</p> <div class="mw-heading mw-heading3"> <h3 id="CSV_and_TSV" data-mw-thread-id="h-CSV_and_TSV-Converting_data_to_JSON"><span data-mw-comment-start="" id="h-CSV_and_TSV-Converting_data_to_JSON"></span>CSV and TSV<span data-mw-comment-end="h-CSV_and_TSV-Converting_data_to_JSON"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=9&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: CSV and TSV"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <ul> <li><a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://www.convertcsv.com/csv-to-json.htm">convertcsv.com</a> – (select "CSV to JSON Array") Generate output as JSON Array, under 'output options' select option 'if to JSON Array, create array for column names with name'. You will still need to manually add <i>name:</i> and <i>type:</i> to each entry in <i>fields</i> (see example above for formatting)</li> </ul> <div class="mw-heading mw-heading3"> <h3 id="XLS" data-mw-thread-id="h-XLS-Converting_data_to_JSON"><span data-mw-comment-start="" id="h-XLS-Converting_data_to_JSON"></span>XLS<span data-mw-comment-end="h-XLS-Converting_data_to_JSON"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=10&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: XLS"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <ul> <li><a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://www.npmjs.com/package/xls-to-json">xls-to-json</a> – Convert xls files to JSON in NodeJS</li> </ul> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"> <h2 id="See_also" data-mw-thread-id="h-See_also"><span data-mw-comment-start="" id="h-See_also"></span>See also<span data-mw-comment-end="h-See_also"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&action=edit&section=11&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Edit section: See also"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span> </div> <ul> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Help:Map_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Special:MyLanguage/Help:Map Data">Help:Map Data</a><span style="display:none"><a href="https://www-mediawiki-org.translate.goog/wiki/Help:Map_Data?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Help:Map Data"> </a></span> – similarly structured map data in the <b>Data:</b> namespace on commons.</li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Extension:Scribunto/Lua_reference_manual?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#mw.loadData" title="Special:MyLanguage/Extension:Scribunto/Lua reference manual">Lua data modules</a><span style="display:none"><a href="https://www-mediawiki-org.translate.goog/wiki/Extension:Scribunto/Lua_reference_manual?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB#mw.loadData" title="Extension:Scribunto/Lua reference manual"> </a></span></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Extension:JsonConfig/Tabular?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Special:MyLanguage/Extension:JsonConfig/Tabular">Tabular data</a><span style="display:none"><a href="https://www-mediawiki-org.translate.goog/wiki/Extension:JsonConfig/Tabular?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Extension:JsonConfig/Tabular"> </a></span> – some implementation details</li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Category:Graph_Template_Collection?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Special:MyLanguage/Category:Graph Template Collection">Category:Graph Template Collection</a><span style="display:none"><a href="https://www-mediawiki-org.translate.goog/wiki/Category:Graph_Template_Collection?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Category:Graph Template Collection"> </a></span> – templates to do graphs with the Commons Datasets</li> <li><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://meta.wikimedia.org/wiki/DataNamespace" class="extiw" title="meta:DataNamespace">DataNamespace</a> – previous proposal</li> <li><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://commons.wikimedia.org/wiki/User:TheDJ/tabularImportExport.js" class="extiw" title="commons:User:TheDJ/tabularImportExport.js">TheDJ/tabularImportExport.js</a> – A script to import from and export to CSV and Excel files, by <a href="https://www-mediawiki-org.translate.goog/wiki/User:TheDJ?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="User:TheDJ">User:TheDJ</a>.</li> <li><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://phabricator.wikimedia.org/T154071" class="extiw" title="phab:T154071">phab:T154071</a> – Allow non-CC0 licensed data for datasets</li> </ul>   </div> <noscript> <img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?type=1x1" alt="" width="1" height="1" style="border: none; position: absolute;"> </noscript> <div class="printfooter" data-nosnippet=""> Retrieved from "<a dir="ltr" href="https://www-mediawiki-org.translate.goog/w/index.php?title=Help:Tabular_data&oldid=6849228&_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB">https://www.mediawiki.org/w/index.php?title=Help:Tabular_data&oldid=6849228</a>" </div> </div> <div id="catlinks" class="catlinks" data-mw="interface"> <div id="mw-normal-catlinks" class="mw-normal-catlinks"> <a href="https://www-mediawiki-org.translate.goog/wiki/Special:Categories?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Special:Categories">Categories</a>: <ul> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Category:Help?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Category:Help">Help</a></li> <li><a href="https://www-mediawiki-org.translate.goog/wiki/Category:Extension_help?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" title="Category:Extension help">Extension help</a></li> </ul> </div> </div> </div> </main> </div> <div class="mw-footer-container"> <footer id="footer" class="mw-footer"> <ul id="footer-info"> <li id="footer-info-lastmod">This page was last edited on 11 November 2024, at 07:35.</li> <li id="footer-info-copyright">Text is available under the <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-ShareAlike License</a>; additional terms may apply. Text in <a class="external text" href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Help:Contents?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB">the Help: namespace</a> is available under the <a rel="nofollow" class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://creativecommons.org/publicdomain/zero/1.0/">Creative Commons CC0 License</a>. By using this site, you agree to the <a class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use">Terms of Use</a> and <a class="external text" href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy Policy</a>.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy policy</a></li> <li id="footer-places-about"><a href="https://www-mediawiki-org.translate.goog/wiki/Project:About?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB">About mediawiki.org</a></li> <li id="footer-places-disclaimers"><a href="https://www-mediawiki-org.translate.goog/wiki/Project:General_disclaimer?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB">Disclaimers</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://www-mediawiki-org.translate.goog/wiki/Special:MyLanguage/Code_of_Conduct?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB">Code of Conduct</a></li> <li id="footer-places-developers"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://developer.wikimedia.org">Developers</a></li> <li id="footer-places-statslink"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://stats.wikimedia.org/%23/www.mediawiki.org">Statistics</a></li> <li id="footer-places-cookiestatement"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookie statement</a></li> <li id="footer-places-mobileview"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://m.mediawiki.org/w/index.php?title%3DHelp:Tabular_data%26mobileaction%3Dtoggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobile view</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://translate.google.com/website?sl=auto&tl=en&hl=en-GB&u=https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www-mediawiki-org.translate.goog/?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-GB" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> </div> </div> </div> <div class="vector-settings" id="p-dock-bottom"> <ul></ul> </div> <script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgHostname":"mw-web.codfw.main-865694c9b9-r77bz","wgBackendResponseTime":127,"wgDiscussionToolsPageThreads":[{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Data_licensing","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Data_types","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Top-level_fields","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Usage","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Example","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Restrictions_and_gotchas","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Admin_notes","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Converting_data_to_JSON","replies":[{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-CSV_and_TSV-Converting_data_to_JSON","replies":[]},{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-XLS-Converting_data_to_JSON","replies":[]}]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-See_also","replies":[]}],"wgPageParseReport":{"discussiontools":{"limitreport-timeusage":"0.021"},"limitreport":{"cputime":"0.238","walltime":"0.318","ppvisitednodes":{"value":706,"limit":1000000},"postexpandincludesize":{"value":4230,"limit":2097152},"templateargumentsize":{"value":1015,"limit":2097152},"expansiondepth":{"value":13,"limit":100},"expensivefunctioncount":{"value":7,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":9293,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 91.794 1 -total"," 46.01% 42.233 4 Template:Ll"," 39.85% 36.578 1 Template:PD_Help_Page"," 21.19% 19.450 8 Template:Translatable"," 12.29% 11.277 4 Template:Pagelang"," 10.18% 9.346 1 Template:Tocright"," 7.32% 6.720 1 Template:TNTN"," 5.77% 5.297 1 Translations:Help:Map_Data/Page_display_title/en"," 4.99% 4.577 1 Template:TOC"," 3.88% 3.558 14 Template:Cclang"]},"scribunto":{"limitreport-timeusage":{"value":"0.023","limit":"10.000"},"limitreport-memusage":{"value":1001728,"limit":52428800}},"cachereport":{"origin":"mw-web.codfw.main-568dbbbfd9-jzk9v","timestamp":"20241111080336","ttl":2592000,"transientcontent":false}}});});</script> <script>function gtElInit() {var lib = new google.translate.TranslateService();lib.translatePage('en', 'en', function () {});}</script> <script src="https://translate.google.com/translate_a/element.js?cb=gtElInit&hl=en-GB&client=wt" type="text/javascript"></script> </body> </html>