{"id":125187,"date":"2020-12-02T13:24:58","date_gmt":"2020-12-02T10:24:58","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-random-fake-datasets-in-microsoft-excel\/"},"modified":"2020-12-02T13:24:58","modified_gmt":"2020-12-02T10:24:58","slug":"how-to-create-random-fake-datasets-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-random-fake-datasets-in-microsoft-excel\/","title":{"rendered":"#How to Create Random (Fake) Datasets in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 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-6a295e159699f\" 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-6a295e159699f\" 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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-random-fake-datasets-in-microsoft-excel\/#Use_the_Formula_Bar\" >Use the Formula Bar<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-random-fake-datasets-in-microsoft-excel\/#Adding_Random_Numbers\" >Adding Random Numbers<\/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-create-random-fake-datasets-in-microsoft-excel\/#Adding_Dates\" >Adding Dates<\/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-create-random-fake-datasets-in-microsoft-excel\/#Adding_Item_Data\" >Adding Item Data<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Create Random (Fake) Datasets in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-435491 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/xstock-lede-microsoft-office_excel-1.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.Bi7kk-HHRf.png\" alt=\"The Microsoft Excel logo on a gray background\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Creating random data to fill an Excel workbook is as simple as adding a few little-known formulas. These formulas come in handy when honing your Microsoft Excel skills, as they give you fake data to practice with before you risk mistakes with the real thing.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_Formula_Bar\"><\/span>Use the Formula Bar<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To start, we\u2019ll enter one of a few formulas in the Formula bar. This is the window below the ribbon, found here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693423\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xformula-bar.png,Mce_.8yZx-vULvh-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.Jj8Yy156-g.png\" alt=\"Excel formula bar\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>From there, it\u2019s about adding the data you want and then doing a little cleanup.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Adding_Random_Numbers\"><\/span>Adding Random Numbers<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To add an integer at random, we\u2019ll use the \u201cRANDBETWEEN\u201d function. Here, we can specify a range of random numerals, in this case, a number from one to 1,000, then copy it to each cell in the column below it.<\/p>\n<p>Click to select the first cell where you\u2019d like to add your random number.<\/p>\n<p>Copy the following formula and paste it into Excel\u2019s Formula bar. You can change the number inside the parenthesis to fit your needs. This formula picks a random number between one and 1,000.<\/p>\n<p><code>=RANDBETWEEN(1,1000)<\/code><\/p>\n<p>Press \u201cEnter\u201d on the keyboard or click the \u201cGreen\u201d arrow to <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ly the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693422\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xrandom-number-formula-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.t0qvkaFp-7.jpg\" alt=\"Excel random number formula\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the lower-right corner, hover over the cell until the \u201c+\u201d icon appears. Click and drag it to the last cell in the column where you want to apply the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693421\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xplus-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.idfWnCVHGh.png\" alt=\"Excel copy data plus\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can use the same formula for monetary values with a simple tweak. By default, RANDBETWEEN only returns whole numbers, but we can change that by using a slightly modified formula. Just change the dates in parenthesis to meet your needs. In this case, we\u2019re choosing a random number between $1 and $1,000.<\/p>\n<p><code>=RANDBETWEEN(1,1000)\/100<\/code><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693420\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xrandom-number-formula-copy-1.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.PN183dPt-m.jpg\" alt=\"Excel random number formula\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once done, you\u2019ll need to clean up the data just a little. Start by right-clicking inside the cell, and selecting \u201cFormat Cells.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693419\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xformat-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.qyqC8oIwNF.png\" alt=\"Excel format cells\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, choose \u201cCurrency\u201d under the \u201cCategory\u201d menu and then select the second option under the \u201cNegative Numbers\u201d option. Press \u201cEnter\u201d on the keyboard to finish.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693418\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xformat-currency-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.hgl3-aQwts.png\" alt=\"Excel format currency\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Adding_Dates\"><\/span>Adding Dates<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel\u2019s built-in calendar treats each date as a number, with the number one being January 1, 1900. Finding the number for the date you need isn\u2019t so straightforward, but we\u2019ve got you covered.<\/p>\n<p>Select your starting cell and then copy and paste the following formula into Excel\u2019s Formula bar. You can change anything in parenthesis to fit your needs. Our sample is set to pick a random date in 2020.<code\/><\/p>\n<pre>\u00a0<code>=RANDBETWEEN(DATE(2020,1,1),DATE(2020,12,31))<\/code><\/pre>\n<p>Press \u201cEnter\u201d on the keyboard or click the \u201cGreen\u201d arrow to the left of the Formula bar to apply the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693417\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xdate-formula-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.348ZdvGWP1.png\" alt=\"Excel date formula\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll notice that this doesn\u2019t look anything like a date yet. That\u2019s okay. Just like in the previous section, we\u2019re going to click the \u201c+\u201d sign at the bottom right of the cell and drag it down as far as needed to add additional randomized data.<\/p>\n<p>Once done, highlight all of the data in the column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693416\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xdate-highlight-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.86-90Ra2W4.png\" alt=\"Excel highlight column\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Right-click and select \u201cFormat Cells\u201d from the menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693415\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xformat-3.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.qyqC8oIwNF.png\" alt=\"Excel format cells\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>From here, choose the \u201cDate\u201d option and then choose the format you prefer from the available list. Press \u201cOK\u201d once you\u2019re done (or \u201cEnter\u201d on the keyboard). Now, all of your random numbers should look like dates.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693414\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xdate-format-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.ITGr4g635y.png\" alt=\"Excel data format\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Adding_Item_Data\"><\/span>Adding Item Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Randomized data in Excel isn\u2019t limited to just numbers or dates. Using the \u201cVLOOKUP\u201d feature, we can create a list of products, name it, then pull from it to create a randomized list in another column.<\/p>\n<p>To start, we\u2019ll need to create a list of random things. In this example, we\u2019ll add pets from an imaginary pet store starting at cell B2 and ending at B11. You\u2019ll need to number each product in the first column, starting at A2 and ending at A11, coinciding with the product to the right. Hamsters, for example, have the product number 10. The headings in cells A1 and B1 aren\u2019t necessary, though the product numbers and names below them are.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693413\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xpet-store-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.OtDzG6o7at.png\" alt=\"Excel columns and rows\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, we\u2019ll highlight the entire column, right-click it, and select the \u201cDefine Name\u201d option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693412\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xdefine-name-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.BjvDDj5YWY.png\" alt=\"Excel define name\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Under \u201cEnter a name for the date range,\u201d we\u2019ll add a name and then click the \u201cOK\u201d button. We\u2019ve now created our list from which to pull random data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693411\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xadd-name-pets-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.9uzm0gk_Ju.png\" alt=\"Excel define name\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Choose a starting cell and click to highlight it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693410\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xhighlight-cell-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.FmNIstNGZe.png\" alt=\"Excel highlight cell\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Copy and paste the formula into the Formula bar and then press \u201cEnter\u201d on the keyboard or click the \u201cGreen\u201d arrow to apply it.\u00a0You can change the values (1,10) and the name (\u201cproducts\u201d) to fit your needs:<\/p>\n<pre>\u00a0<code>=VLOOKUP(RANDBETWEEN(1,10),products,2)<\/code><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693409\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xpets-formula-2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.-BN3EuY9SM.png\" alt=\"Excel formula\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click and drag the \u201c+\u201d sign at the bottom right of the cell to copy the data into additional cells below (or to the side).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693408\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/more-pets-2.png\" alt=\"Excel copy data\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<hr\/>\n<p>Whether learning pivot tables, experimenting with formatting, or learning how to create a chart for your next presentation, this dummy data could prove to be just what you need to get the job done.<\/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 noreferrer\">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 noreferrer\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/692658\/how-to-create-random-fake-datasets-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Create Random (Fake) Datasets in Microsoft Excel&#8221; Creating random data to fill an Excel workbook is as simple as adding a few little-known formulas. These formulas come in handy when honing your Microsoft Excel skills, as they give you fake data to practice with before you risk mistakes with the real thing. Use&#8230;<\/p>\n","protected":false},"author":1,"featured_media":125188,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/thumbcache\/2\/200\/2144ab7a8e4ef0c005417526e2a219c4\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-125187","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\/125187","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=125187"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/125187\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/125188"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=125187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=125187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=125187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}