{"id":971,"date":"2019-04-24T23:49:07","date_gmt":"2019-04-25T03:49:07","guid":{"rendered":"http:\/\/sudlatnid.com\/wp\/?p=971"},"modified":"2019-04-24T23:49:07","modified_gmt":"2019-04-25T03:49:07","slug":"27-incredibly-useful-things-you-didnt-know-google-sheets-could-do","status":"publish","type":"post","link":"https:\/\/www.sudlatnid.com\/?p=971","title":{"rendered":"27 incredibly useful things you didn\u2019t know Google Sheets could do"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">There\u2019s much more to Google Sheets than meets the eye. Unlock these advanced options\u2013and watch your productivity soar.\n<\/h4>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/images.fastcompany.net\/image\/upload\/w_937,ar_16:9,c_fill,g_auto,f_auto,q_auto,fl_lossy\/wp-cms\/uploads\/2019\/04\/p-1-google-sheets.jpg\" alt=\"27 incredibly useful things you didn\u2019t know Google Sheets could do\"\/><\/figure>\n\n\n\n<p><a href=\"https:\/\/www.fastcompany.com\/user\/jrraphael\"> By JR Raphael<\/a><\/p>\n\n\n\n<p>I\u2019ll\n admit it: For the majority of my adult life, spreadsheets have remained\n shrouded in mystery. I\u2019ve used them plenty, of course\u2013to track income, \ncompare statistics, even maintain databases for various types of \nwork-related info\u2013but I\u2019ve always felt like I\u2019ve barely been scratching \nthe surface of what they\u2019re able to do.<\/p>\n\n\n\n<p>And that\u2019s a \nshame. With Google Sheets in particular, sticking only to spreadsheet \nbasics seems akin to sitting on a mountain of untapped potential. The \nservice has a profusion of advanced functions, options, and shortcuts, \nbut until you identify and internalize them, you\u2019re getting only a \nfraction of the value it can provide.<\/p>\n\n\n\n<p>So after all these years, I \ndecided to take action. I dug deep into Sheets\u2019 darkest nooks and \ncrannies to uncover some of its most useful and easily overlooked \nfeatures. Whether you\u2019re a casual spreadsheet explorer or a more \nambitious data-crunching pro, I\u2019d be willing to wager there are plenty \nof worthwhile possibilities just waiting for you to discover, too.<\/p>\n\n\n\n<p>Read on, and get ready to take your Google Sheets experience to a whole new level.<\/p>\n\n\n\n<p>(While\n some of these items will also work in the Sheets\u2019 mobile apps, the \ninstructions below are all for the service\u2019s web version.)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Save time with shortcuts<\/h2>\n\n\n\n<p>1.\n The next time you need to create a new spreadsheet, save yourself the \ntrouble of opening up the main Google Sheets site and clicking through \nthe commands there. Instead, just type \u201csheet.new\u201d directly into your \nbrowser\u2019s address bar. As long as you\u2019re already signed into your Google\n account, that\u2019ll <strong>start a new spreadsheet for you, no matter where you are on the web.<\/strong> (You can also type \u201csheets.new\u201d or \u201cspreadsheet.new,\u201d if you prefer.)<\/p>\n\n\n\n<p>2. Sheets has plenty of <a href=\"https:\/\/support.google.com\/docs\/?p=spreadsheets_shortcuts\">keyboard shortcuts<\/a>, but one series that\u2019s especially worth noting is the collection of commands that quickly<strong> insert the current date and\/or time wherever you want<\/strong>:\n Hit Ctrl or Cmd and the semicolon key to add the date, Ctrl or Cmd \nalong with Shift and the semicolon key to add the time, and Ctrl or Cmd \nalong with Alt <em>and <\/em>Shift and the semicolon key to add the date and time together.<\/p>\n\n\n\n<p>3. Google Sheets\u2019 fast-formatting shortcuts are also worth remembering. With the right combination of keys, you can <strong>format any cell or selection of cells however you want, without having to dig around in menus<\/strong>. Commit these to memory:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Ctrl-Shift-1: Format as decimal<\/li><li>Ctrl-Shift-2: Format as time<\/li><li>Ctrl-Shift-3: Format as date<\/li><li>Ctrl-Shift-4: Format as currency<\/li><li>Ctrl-Shift-5: Format as percentage<\/li><li>Ctrl-Shift-6: Format as exponent<\/li><\/ul>\n\n\n\n<p>4. You can even create your own personalized shortcut within Sheets to <strong>perform a complex series of custom actions with a single command.<\/strong>\n Open the Tools menu, select \u201cMacros,\u201d and then select \u201cRecord macro.\u201d \nIf you want the shortcut to always be performed on the same specific \ncells, select \u201cUse absolute references\u201d; otherwise, select \u201cUse relative\n references.\u201d Then perform whatever actions you want to record.<\/p>\n\n\n\n<p>You\n could do something like set a specific sort of formatting for a cell\u2019s \ncontents (bolded white text with the Open Sans font and a dark-gray \nbackground, for instance) or you could manipulate data in a more \ninvolved manner, like copying a cell\u2019s contents and then erasing that \ncell and pasting the contents one cell over to the left. When you\u2019re \nfinished, click the \u201cSave\u201d button in the macro-recording panel, and \nyou\u2019ll be able to give your new shortcut a name and assign it to any \navailable key combination for future activation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Grab some data<\/h2>\n\n\n\n<p>5. Need to <strong>show some live data from one spreadsheet inside another<\/strong>?\n Copy the full URL of the sheet with the data and paste it into Sheets\u2019 \nIMPORTRANGE function, using the following format (with your own URL, \nsheet number, and cell range in place):<\/p>\n\n\n\n<p>=IMPORTRANGE (\u201chttps:\/\/docs.google.com\/spreadsheets\/d\/1aBcDEfgHiJKLMnOPQRSTuVWXZ\u201d, \u201cSheet1!D1:D15\u201d)<\/p>\n\n\n\n<p>Then\n just paste that function into the sheet where you want the data to \nappear. You\u2019ll have to hover over the cell and click a button to allow \nthe two sheets to be connected, and then\u2013hocus-pocus!\u2013all of the data \nfrom your other sheet will magically appear and remain current whenever \nany changes are made.<\/p>\n\n\n\n<p>6. Sheets can <strong>pull in data from any publicly available web page<\/strong>,\n too, as long as the page has a properly formatted table. The secret \nlies within the IMPORTHTML command; use it with whatever URL you need \nand the number indicating which table on the page you want to import \n(\u201c1\u201d for the first table, \u201c2\u201d for the second, and so on):<\/p>\n\n\n\n<p>=IMPORTHTML(\u201chttps:\/\/en.wikipedia.org\/wiki\/List_of_sandwiches\u201d,\u201dtable\u201d,1)<\/p>\n\n\n\n<p>And just like that, all of the info will appear within your spreadsheet.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/images.fastcompany.net\/image\/upload\/w_596,c_limit,q_auto:best,f_auto\/wp-cms\/uploads\/2019\/04\/2019-04-15-11.56.03.jpg\" alt=\"\" class=\"wp-image-90337834\"\/><figcaption>Sheets\u2019 IMPORTHTML command imports live data from any public web page with a table.<\/figcaption><\/figure>\n\n\n\n<p>7. A similar kind of command can let you <strong>import recent entries from a website\u2019s RSS feed into any spreadsheet<\/strong>.\n All you need to do is enter the IMPORTFEED command along with the URL \nof the feed you want\u2014so, for instance, if you wanted to see all of my <em>Fast Company<\/em> stories in Google Sheets, you could enter:<\/p>\n\n\n\n<p>=IMPORTFEED(\u201chttps:\/\/fastcompany.com\/user\/jrraphael\/rss\u201d)<\/p>\n\n\n\n<p>If\n you wanted only the titles of the stories\u2014and wanted only, say, the \nmost recent five entries\u2014you could add in the following parameters:<\/p>\n\n\n\n<p>=IMPORTFEED(\u201chttps:\/\/fastcompany.com\/user\/jrraphael\/rss\u201d,\u201ditems title\u201d,false,5)<\/p>\n\n\n\n<p>And then if you wanted to place the links to each story in a separate column alongside that, you could use this:<\/p>\n\n\n\n<p>=IMPORTFEED(\u201chttps:\/\/fastcompany.com\/user\/jrraphael\/rss\u201d,\u201ditems URL\u201d,false,5)<\/p>\n\n\n\n<p>8. Google Sheets has an easily overlooked cousin called Google Forms that lets you <strong>collect data in a survey-style form on the web and then compile the results in a spreadsheet<\/strong>.\n You can create a form by looking for the \u201cForms\u201d option within Sheets\u2019 \nInsert menu, and then using the site that comes up to create any set of \nquestions and parameters you want. When your form is ready, click the \n\u201cSend\u201d button in the upper-right corner of the page to email it to \nanyone, embed it in a web page, or get a manual link for sharing it \nhowever you like. As responses come in, they\u2019ll automatically appear in \nyour spreadsheet as their own individual rows.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Clean it up<\/h2>\n\n\n\n<p>9.\n If you spot some extra spaces before or after data in your spreadsheet \n(whether you\u2019re looking at numbers or text), don\u2019t forget the Google \nSheets function TRIM. You can type it in for whatever cell you \nwant\u2013=TRIM(A1), for instance\u2013and it\u2019ll <strong>take away any leading or trailing spaces<\/strong> and give you a cleaner version of the cell\u2019s value.<\/p>\n\n\n\n<p>If you want to perform the function for multiple cells at once, use this format for whatever range you need:<\/p>\n\n\n\n<p>=ArrayFormula(TRIM(A2:A50))<\/p>\n\n\n\n<p>10. Looking at lots of data with RanDoM or ImPropeR CaPitaLiZaTion? Sheets can <strong>standardize case formatting for you<\/strong>\n with a few simple functions: UPPER(A1) will make all of the text \nuppercase for whatever cell you mention; LOWER(A1) will do the same with\n lowercase; and PROPER(A1) will capitalize the first letter of each word\n for a title-case effect.<\/p>\n\n\n\n<p>11. Maybe you have a database of user-submitted email addresses. Well, tell Sheets to <strong>look through the addresses and determine if they\u2019re all properly formatted:<\/strong>\n Use the function ISEMAIL(A1) with whatever cell you need\u2013or if you want\n to perform the function for a range of cells, use this format instead:<\/p>\n\n\n\n<p>=ArrayFormula(ISEMAIL(A2:A50))<\/p>\n\n\n\n<p>Sheets will give you a \u201cTRUE\u201d or \u201cFALSE\u201d answer for every email address you feed it.<\/p>\n\n\n\n<p>12. You can<strong> validate URLs in a spreadsheet<\/strong>,\n too, to make sure you don\u2019t have any improper items in your list: \nFollow the same procedure outlined in the previous tip but use the \nfunction ISURL instead.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Analyze and visualize<\/h2>\n\n\n\n<p>13. <strong>Perform fast calculations in any number-oriented spreadsheet <\/strong>by\n highlighting a bunch of cells and then looking in the lower-right \ncorner of the screen. By default, Sheets will show you the sum of the \nnumbers you\u2019ve selected. You can then click the box with that info and \ntell it to show the average, the minimum or maximum, or the total count \nof numbers involved\u2013and once you make that change, your selection will \nstick and remain the new default for any future calculations you \nperform.<\/p>\n\n\n\n<p>14. <strong>Create a tiny chart within a single cell <\/strong>using\n Sheets\u2019 nifty Sparkline feature. Just type the command =SPARKLINE \nfollowed by the cells you want to include, the word \u201ccharttype,\u201d and \nthen the type of chart you want to create\u2013such as line, bar, or \ncolumn\u2013formatted like this:<\/p>\n\n\n\n<p>=SPARKLINE(E12:E23,{\u201ccharttype\u201d,\u201dcolumn\u201d})<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/images.fastcompany.net\/image\/upload\/w_596,c_limit,q_auto:best,f_auto\/wp-cms\/uploads\/2019\/04\/2019-04-15-11.55.48.jpg\" alt=\"\" class=\"wp-image-90337842\"\/><figcaption>The Sparkline feature puts tiny charts of data into single cells within your spreadsheets.<\/figcaption><\/figure>\n\n\n\n<p>If you really want to get wild, you can even include a variety of <a href=\"https:\/\/support.google.com\/docs\/answer\/3093289\">customization commands<\/a> that\u2019ll control the colors used in different parts of your chart along with other visual factors.<\/p>\n\n\n\n<p>15. Tap into Google\u2019s artificial intelligence and let Sheets <strong>perform different types of data analysis and create complex charts for you<\/strong>.\n Hover your mouse over the starburst-shaped icon in the lower-right \ncorner of the screen, and you\u2019ll see the word \u201cExplore\u201d appear. Click \nthat button, and Sheets will pop up a panel of info related to your \ndata. You can highlight specific rows in your spreadsheet to change its \nfocus, and you can hover over any item it presents to find options for \nadjusting it or inserting it directly into your sheet.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/images.fastcompany.net\/image\/upload\/w_596,c_limit,q_auto:best,f_auto\/wp-cms\/uploads\/2019\/04\/2019-04-15-11.55.38.jpg\" alt=\"\" class=\"wp-image-90337841\"\/><figcaption>Sheets\u2019 Explore feature uses A.I. to give you all sorts of useful charts and info.<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Format like a pro<\/h2>\n\n\n\n<p>16. Sheets allows you to <strong>hide any row<\/strong>.\n Click its number in the gray column at the far left of the screen and \nselect \u201cHide row\u201d from the menu that appears. When you want to show the \nrow again, click the black arrows that appeared in its place within that\n same left-of-screen column.<\/p>\n\n\n\n<p>17. Want a quick and easy \nway to make your spreadsheet pop? Look for the \u201cAlternating colors\u201d \noption in Sheets\u2019 Format menu. It\u2019ll give you a simple set of options \nthat\u2019ll <strong>apply a sharp-looking color pattern to your rows<\/strong>\u2013no thought or effort required.<\/p>\n\n\n\n<p>18. While you\u2019re jazzing up your spreadsheet\u2019s appearance, think about letting Sheets<strong> rotate the text in your header row<\/strong>.\n Highlight the row, then click on the icon that shows an angled \u201cA\u201d with\n an up-pointing arrow beneath it (directly to the left of the \nlink-inserting tool). You can then pick from several eye-catching \neffects that\u2019ll set your header text apart and give your spreadsheet a \nsnazzy, polished look.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/images.fastcompany.net\/image\/upload\/w_596,c_limit,q_auto:best,f_auto\/wp-cms\/uploads\/2019\/04\/2019-04-15-11.55.26.jpg\" alt=\"\" class=\"wp-image-90337838\"\/><figcaption>Rotating header row text and adding alternating colors are easy ways to give your spreadsheet some pizzazz.<\/figcaption><\/figure>\n\n\n\n<p>19. Sheets can <strong>copy a cell\u2019s complete set of formatting and apply it to another cell <\/strong>with\n a few fast clicks. First, click the cell with the formatting you want \nto copy. Then, click the paint roller icon\u2013directly to the right of the \nprint command, toward the left side of the toolbar\u2013and click the cell to\n which you want the formatting to apply. Everything from the font size \nand color to the cell shading and numerical style will carry over.<\/p>\n\n\n\n<p>20. <strong> Give yourself or your team a functional checklist<\/strong>\n right within a spreadsheet: Select a series of blank cells, open the \nInsert menu, and select \u201cCheckbox.\u201d You can then put your to-do items in\n the next column over and get the satisfaction of checking items off as \nyou complete them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Share and collaborate<\/h2>\n\n\n\n<p>21. Once you\u2019ve <a href=\"https:\/\/support.google.com\/docs\/answer\/2494822?hl=en&amp;ref_topic=4671185\">shared a spreadsheet<\/a>\u2013either publicly or with specific people\u2013you can create a custom link that\u2019ll <strong>let anyone with access quickly copy your spreadsheet into their own Google account<\/strong>,\n where they can use it as a template or modify it however they want \nwithout affecting your original version. Just copy the URL in your \nbrowser\u2019s address bar while you\u2019re viewing the spreadsheet and replace \nthe word \u201cedit\u201d at the end with \u201ccopy\u201d\u2014leaving you with something like \nthis:<\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/docs.google.com\/spreadsheets\/d\/1aBcDEfgHiJKLMnOPQRSTuVWXZ\/copy\n<\/div><\/figure>\n\n\n\n<p>When\n anyone with access to the spreadsheet opens that link, they\u2019ll \nimmediately be prompted to make a copy with a single click right then \nand there.<\/p>\n\n\n\n\n\n<p>22.\n Sheets makes it easy to export a spreadsheet in a variety of formats \nvia the \u201cDownload as\u201d option in the File menu, but if you\u2019d rather <strong>give people a direct link to download your data as a PDF<\/strong>,\n there\u2019s a hidden command for doing just that: Copy your spreadsheet\u2019s \nURL, just like in the previous item, but this time, replace the word \n\u201cedit\u201d at the end with \u201cexport?format=pdf\u201d\u2013leaving you with a link that \nlooks something like:<\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/docs.google.com\/spreadsheets\/d\/1aBcDEfgHiJKLMnOPQRSTuVWXZ\/export?format=pdf\n<\/div><\/figure>\n\n\n\n<p>People with access to the spreadsheet will instantly be presented with a PDF export as soon as they open the link.<\/p>\n\n\n\n<p>23. When you\u2019re sharing a spreadsheet or using a form to accept survey-like responses, you can ask Sheets to<strong> notify you whenever an edit or addition occurs<\/strong>\u2013either\n immediately or as a once-daily email digest. Look for the \u201cNotification\n rules\u201d option in the Tools menu to set your preferences for any \nparticular spreadsheet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Try an advanced feature or two<\/h2>\n\n\n\n<p>24. Sheets has the capability to <strong>create QR codes<\/strong>\n that\u2019ll pull up whatever URLs you want when they\u2019re scanned. Type your \nURL into a cell (with \u201chttp:\/\/\u201d or \u201chttps:\/\/\u201d in front of it), then use \nthe following function with your own cell number in place of \u201cA2\u201d:<\/p>\n\n\n\n<p>=image(\u201chttps:\/\/chart.googleapis.com\/chart?chs=150\u00d7150&amp;cht=qr&amp;chl=\u201d&amp;A2)<\/p>\n\n\n\n<p>The QR code will instantly appear and be available to copy, share, or manipulate in any way your heart desires.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/images.fastcompany.net\/image\/upload\/w_596,c_limit,q_auto:best,f_auto\/wp-cms\/uploads\/2019\/04\/2019-04-15-11.55.14.jpg\" alt=\"\" class=\"wp-image-90337836\"\/><figcaption>Creating QR codes is one of Google Sheets\u2019 many hidden powers.<\/figcaption><\/figure>\n\n\n\n<p>25. Here\u2019s a handy little Sheets function for tracking trends across numerical data: <strong>Create a heat map<\/strong>\n to highlight highs and lows and make it easy to see things like sales \nor web-traffic success patterns. Select whatever range of data you want,\n then look for the \u201cConditional formatting\u201d option within the Format \nmenu. Click the \u201cColor scale\u201d tab at the top and assign a color to both \n\u201cMin value\u201d and \u201cMax value.\u201d The effect will work best if you use a \nlight version of a color for the former and a dark version of the same \ncolor for the latter.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/images.fastcompany.net\/image\/upload\/w_596,c_limit,q_auto:best,f_auto\/wp-cms\/uploads\/2019\/04\/2019-04-15-11.55.10.jpg\" alt=\"\" class=\"wp-image-90337835\"\/><figcaption>A heat map enhances any set of numerical data to help you spot patterns and trends.<\/figcaption><\/figure>\n\n\n\n<p>26. Sheets has the power of Google Finance (which\u2013who knew?\u2013is <a href=\"https:\/\/www.google.com\/finance\">still a thing<\/a>) baked right in for your stock-knowledge needs. The system is able to <strong>give you real-time or historical stock prices along with all sorts of other market-related data <\/strong>for\n any publicly traded company. Simply use the function GOOGLEFINANCE \nfollowed by the info you desire, using the variables and formats \ndescribed on <a href=\"https:\/\/support.google.com\/docs\/answer\/3093281\">this page<\/a>.<\/p>\n\n\n\n<p>27. Ever find yourself scrolling through a list of responses in different languages? Sheets can <strong>identify any language used in a spreadsheet and even translate it <\/strong>into\n your own native tongue on the spot. To detect a language, use the \nfollowing function (with the appropriate cell number in place of \u201cA1\u201d):<\/p>\n\n\n\n<p>=DETECTLANGUAGE(A1)<\/p>\n\n\n\n<p>You can also enter in a word in place of a cell number, if you want:<\/p>\n\n\n\n<p>=DETECTLANGUAGE(\u201cqueso\u201d)<\/p>\n\n\n\n<p>Google\n will give you a two-letter code telling you the language that was used.\n To translate, meanwhile, use the following command\u2013with your own word \nor cell number in place of \u201cA1\u2033 and the code for whatever language you \nwant to translate into (if it\u2019s anything other than English, as \nreferenced below):<\/p>\n\n\n\n<p>=GOOGLETRANSLATE(A1,\u201dauto\u201d,\u201den\u201d)<\/p>\n\n\n\n<p><em>Assez facile, non?<\/em><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">About the author<\/h4>\n\n\n\n<p><a href=\"http:\/\/www.jrstart.com\">JR Raphael<\/a> is obsessed with productivity and finding clever ways to make the most of modern technology. Join him <a href=\"https:\/\/twitter.com\/jrraphael\">on Twitter<\/a> or sign up for <a href=\"https:\/\/www.androidintel.net\">his weekly newsletter<\/a> to get fresh tips in your inbox every Friday.<\/p>\n\n\n\n<p> <a href=\"https:\/\/www.fastcompany.com\/user\/jrraphael\">More<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There\u2019s much more to Google Sheets than meets the eye. Unlock these advanced options\u2013and watch your productivity soar. By JR Raphael I\u2019ll admit it: For the majority of my adult life, spreadsheets have remained shrouded&hellip;<\/p>\n<p><a class=\"excerpt-readmore\" href=\"https:\/\/www.sudlatnid.com\/?p=971\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,16],"tags":[],"class_list":["post-971","post","type-post","status-publish","format-standard","hentry","category-interesting","category-tech-related","odd"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sudlatnid.com\/index.php?rest_route=\/wp\/v2\/posts\/971","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sudlatnid.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sudlatnid.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sudlatnid.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sudlatnid.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=971"}],"version-history":[{"count":0,"href":"https:\/\/www.sudlatnid.com\/index.php?rest_route=\/wp\/v2\/posts\/971\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sudlatnid.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sudlatnid.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sudlatnid.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}