{"id":494903,"date":"2022-09-21T22:00:12","date_gmt":"2022-09-21T19:00:12","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-import-data-with-google-sheets-functions\/"},"modified":"2022-09-21T22:00:12","modified_gmt":"2022-09-21T19:00:12","slug":"how-to-import-data-with-google-sheets-functions","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-import-data-with-google-sheets-functions\/","title":{"rendered":"#How to Import Data With Google Sheets Functions"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6aefdd1f90624\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6aefdd1f90624\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-import-data-with-google-sheets-functions\/#%E2%80%9CHow_to_Import_Data_With_Google_Sheets_Functions%E2%80%9D\" >&#8220;How to Import Data With Google Sheets Functions&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-import-data-with-google-sheets-functions\/#IMPORTDATA_for_a_CSV_or_TSV_File\" >IMPORTDATA for a CSV or TSV File<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-import-data-with-google-sheets-functions\/#IMPORTFEED_for_an_RSS_or_ATOM_Feed\" >IMPORTFEED for an RSS or ATOM Feed<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-import-data-with-google-sheets-functions\/#IMPORTHTML_for_a_Table_or_List_on_a_Web_Page\" >IMPORTHTML for a Table or List on a Web Page<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-import-data-with-google-sheets-functions\/#IMPORTRANGE_for_a_Cell_Range_in_a_Spreadsheet\" >IMPORTRANGE for a Cell Range in a Spreadsheet<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Import_Data_With_Google_Sheets_Functions%E2%80%9D\"><\/span>&#8220;How to Import Data With Google Sheets Functions&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\"\/><\/p>\n<p>You may want to work with data in your spreadsheet that resides elsewhere. Using a set of Google Sheets functions, you can import data from a CSV file, RSS feed, web page, or another spreadsheet.<\/p>\n<p>With the functions we\u2019ll describe here, you can pull data into your sheet from external sources. Then, analyze, manipulate, format, and do what you please with your new data.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"IMPORTDATA_for_a_CSV_or_TSV_File\"><\/span>IMPORTDATA for a CSV or TSV File<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you see a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/348960\/what-is-a-csv-file-and-how-do-i-open-it\/\">CSV or TSV file on a website you\u2019d like to import, you can use the IMPORTDATA function.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>What Is a CSV File, and How Do I Open It?<\/em><\/strong><\/p>\n<p>The syntax for the function is <code>IMPORTDATA(reference, delimiter, locale)<\/code> where only the first argument is required as the URL or a cell reference. If you want to use a different delimiter than the default file type, use the <code>delimiter<\/code> argument. And if you need to change the language, use the <code>locale<\/code> argument with the region\u2019s code.<\/p>\n<p>Here, we\u2019ll import a CSV file using the URL with this formula:<\/p>\n<pre>=IMPORTDATA(\"https:\/\/www.bls.gov\/cew\/classifications\/aggregation\/agg-level-titles-csv.csv\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-825923 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTDATA-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTDATA function in Google Sheets\" width=\"650\" height=\"337\"\/><\/p>\n<p>In this example, we add the <code>delimiter<\/code> argument rather than using the default (comma) for the CSV file:<\/p>\n<pre>=IMPORTDATA(\"https:\/\/www.bls.gov\/cew\/classifications\/aggregation\/agg-level-titles-csv.csv\",\".\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825924\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTDATAdelimiter-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTDATA function with the delimiter argument\" width=\"650\" height=\"329\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"IMPORTFEED_for_an_RSS_or_ATOM_Feed\"><\/span>IMPORTFEED for an RSS or ATOM Feed<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe there\u2019s an <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/115317\/htg-explains-what-is-rss-and-how-can-i-benefit-from-using-it\/\">RSS or ATOM feed that you want to pull data from to manipulate it in your sheet. You\u2019ll use the IMPORTFEED function.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>What Is RSS, and How Can I Benefit From Using It?<\/em><\/strong><\/p>\n<p>The syntax for the function is <code>IMPORTDATFEED(reference, query, headers, number_items)<\/code> where only the first argument is required, and you can use the URL or a cell reference.<\/p>\n<ul>\n<li><b>Query<\/b>: Enter the default \u201citems\u201d or use \u201cfeed\u201d for a single row of data, \u201cfeed [type]\u201d for a certain feed element, or \u201citems [type]\u201d for a certain item element.<\/li>\n<li><b>Headers<\/b>: The default is FALSE, but you can use TRUE to include a header row.<\/li>\n<li><b>Number_items<\/b>: The default is all items in the feed, but you can enter a specific number of items.<\/li>\n<\/ul>\n<p>To import our How-To Geek feed with five items, you can use this formula:<\/p>\n<pre>=IMPORTFEED(\"https:\/\/www.howtogeek.com\/feed\",\"items\",,5)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825927\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTFEED-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTFEED function for a number of items\" width=\"650\" height=\"225\"\/><\/p>\n<p>Using this next formula, you can import five items from the same feed and include the header row:<\/p>\n<pre>=IMPORTFEED(\"https:\/\/www.howtogeek.com\/feed\",\"items\",TRUE,5)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825926\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTFEEDheaders-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTFEED function with headers\" width=\"650\" height=\"249\"\/><\/p>\n<p>For one more example, using the same feed, we\u2019ll import just the titles for five items using this formula:<\/p>\n<pre>=IMPORTFEED(\"https:\/\/www.howtogeek.com\/feed\",\"items title\",,5)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825925\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTFEEDtitles-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTFEED with titles only\" width=\"602\" height=\"270\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"IMPORTHTML_for_a_Table_or_List_on_a_Web_Page\"><\/span>IMPORTHTML for a Table or List on a Web Page<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tables and lists from a web page (<a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/752587\/what-is-html\/\">HTML) are easy to import into Google Sheets with the IMPORTHTML function.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>What Is HTML?<\/em><\/strong><\/p>\n<p>The syntax for the function is <code>IMPORTHTML(reference, query, index)<\/code> where you may want to use all three arguments depending on the page. Enter a URL or cell for the <code>reference<\/code>, \u201ctable\u201d or \u201clist\u201d for the <code>query<\/code>, and a number for the <code>index<\/code>. The index is the identifier in the page\u2019s HTML for the table or list if there\u2019s more than one.<\/p>\n<p>As an example, we\u2019ll import the first table on a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/en.wikipedia.org\/wiki\/List_of_Star_Wars_films\">Wikipedia page for Star Wars films<\/a> using this formula:<\/p>\n<pre>=IMPORTHTML(\"https:\/\/en.wikipedia.org\/wiki\/List_of_Star_Wars_films\",\"table\",1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825931\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTHTMLtable1-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTHTML for the first table on a page\" width=\"650\" height=\"364\"\/><\/p>\n<p>When you view the web page, you can see this first table is the one on the top right.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825932\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTHTMLpagetable1-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"First table on a page\" width=\"650\" height=\"403\"\/><\/p>\n<p>Because it\u2019s the next table on that page we really want, we\u2019ll include the next index number instead with this formula:<\/p>\n<pre>=IMPORTHTML(\"https:\/\/en.wikipedia.org\/wiki\/List_of_Star_Wars_films\",\"table\",2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825930\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTHTMLtable2-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTHTML for the second table on a page\" width=\"650\" height=\"204\"\/><\/p>\n<p>Now we have the table shown below in our Google Sheet instead.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825929\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTHTMLpagetable2-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Second table on a page\" width=\"650\" height=\"278\"\/><\/p>\n<p>For one more example, we\u2019ll import a list from that same page. This is the third list identified on the page which is the contents of the article. Here\u2019s the formula:<\/p>\n<pre>=IMPORTHTML(\"https:\/\/en.wikipedia.org\/wiki\/List_of_Star_Wars_films\",\"list\",3)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825928\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTHTMLlist-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTHTML for the third list on a page\" width=\"650\" height=\"351\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"IMPORTRANGE_for_a_Cell_Range_in_a_Spreadsheet\"><\/span>IMPORTRANGE for a Cell Range in a Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One more handy import function is for bringing in data from another spreadsheet. Although it\u2019s easy enough to pull data <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/442246\/how-to-import-data-from-another-google-sheet\/\">from a sheet in the same workbook, you might want data from a different workbook. For this, you can use the IMPORTRANGE function.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Import Data from Another Google Sheet<\/em><\/strong><\/p>\n<p>The syntax for the function is <code>IMPORTRANGE(reference, sheet_range)<\/code> where you\u2019ll need both arguments. Enter the URL for the sheet in quotes or use a cell reference. Then, include the sheet name and cell range as a string or a cell reference, both should be in quotation marks.<\/p>\n<p>When you first enter a formula for the IMPORTRANGE function, you\u2019ll likely see an error like the one below. This is simply to alert you that you need to allow access to the sheet you want to import. Select \u201cAllow Access\u201d to continue.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825933\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTRANGEerror-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTRANGE access message\" width=\"423\" height=\"112\"\/><\/p>\n<p>In this example, we\u2019ll import the range A1 through E7 from another workbook. This workbook only has one sheet, so the import is successful without the sheet name. Here\u2019s the formula:<\/p>\n<pre>=IMPORTRANGE(\"https:\/\/docs.google.com\/spreadsheets\/d\/mysheet\/edit\",\"A1:E7\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825935\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTRANGE-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTRANGE function in Google Sheets\" width=\"650\" height=\"146\"\/><\/p>\n<p>For the next example, we\u2019re importing from another workbook that has multiple sheets. So, you\u2019d include the sheet name and cell range as a single string: <code>Sales!D1:F13<\/code><\/p>\n<pre>=IMPORTRANGE(\"https:\/\/docs.google.com\/spreadsheets\/d\/mysheet\/edit#gid=111525310\",\"Sales!D1:F13\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-825934\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/IMPORTRANGEsheet-GoogleSheetsImportFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMPORTRANGE function with the sheet name\" width=\"650\" height=\"204\"\/><\/p>\n<p>These Google Sheets import functions can come in super handy when you need external data like the types mentioned here. Keep in mind that if you want to import a specific type of file from your computer, such as a Microsoft Excel workbook, you can do that with the Google Sheets menu.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Import an Excel Document into Google Sheets<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/825918\/how-to-import-data-with-google-sheets-functions\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Import Data With Google Sheets Functions&#8221; You may want to work with data in your spreadsheet that resides elsewhere. Using a set of Google Sheets functions, you can import data from a CSV file, RSS feed, web page, or another spreadsheet. With the functions we\u2019ll describe here, you can pull data into your&#8230;<\/p>\n","protected":false},"author":1,"featured_media":494904,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-494903","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/494903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=494903"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/494903\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/494904"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=494903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=494903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=494903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}