{"id":248472,"date":"2021-05-11T17:24:10","date_gmt":"2021-05-11T14:24:10","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-the-automatic-data-type-tool-in-microsoft-excel\/"},"modified":"2021-05-11T17:24:10","modified_gmt":"2021-05-11T14:24:10","slug":"how-to-use-the-automatic-data-type-tool-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-automatic-data-type-tool-in-microsoft-excel\/","title":{"rendered":"#How to Use the Automatic Data Type Tool in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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-6a3cc607edb5e\" 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-6a3cc607edb5e\" 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-use-the-automatic-data-type-tool-in-microsoft-excel\/#About_Data_Types_in_Excel\" >About Data Types in Excel<\/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-use-the-automatic-data-type-tool-in-microsoft-excel\/#Access_the_Data_Types\" >Access the Data Types<\/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-use-the-automatic-data-type-tool-in-microsoft-excel\/#Apply_the_Automatic_Data_Type\" >Apply the Automatic Data Type<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-automatic-data-type-tool-in-microsoft-excel\/#Add_Data_Details\" >Add Data Details<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-automatic-data-type-tool-in-microsoft-excel\/#Refresh_the_Data_Details\" >Refresh the Data Details<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Use the Automatic Data Type Tool in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-725718\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?width=1200&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Add details to your Microsoft Excel spreadsheets for cities, foods, music, plants, and more. With the data type tool, there\u2019s no need to open your web browser. Just type in a keyword and go!<\/p>\n<p>When Microsoft implemented its data type tool in Excel, we showed you just how easy it is to use. You could gather geographical data or add stock details to your sheets without scouring the internet. But the tool goes beyond its early stages of a few data types to over a dozen now, including an automatic data detector.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"About_Data_Types_in_Excel\"><\/span>About Data Types in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once you add data to your Microsoft Excel spreadsheet, you can turn words or phrases into data types. Those data types provide you with details from the web that you can also add to your sheet.<\/p>\n<p>For example, you can type the word \u201cbacon\u201d in your spreadsheet and turn that word into a food data type. Then, with a click, you can insert nutritional details for bacon in the cells next to it.<\/p>\n<p>You can also use the automatic data type. This all-encompassing option detects the data type and <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>lies it automatically. This is ideal if your spreadsheet covers a variety of different types. In this tutorial, we\u2019ll go into detail about how to use the automatic data type.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Access_the_Data_Types\"><\/span>Access the Data Types<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019re a Microsoft 365 subscriber, you should have the data type feature in Excel. Head to the Data tab and look for the Data Types section in the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724182\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/DataTabDataTypes-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data Types in the Excel ribbon\" width=\"505\" height=\"156\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Use the two top arrows to move through the data types a couple at a time or the bottom arrow to see them all in one spot.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724183\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/AllDataTypes-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"All Data Types in Excel\" width=\"515\" height=\"446\" 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=\"Apply_the_Automatic_Data_Type\"><\/span>Apply the Automatic Data Type<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>With any data type, you must have data in your sheet first. Since we\u2019re using the automatic data type, we\u2019ll use different words and phrases that will cover a variety of data types. This is really the best use of the automatic tool as well as the ideal way to show its power.<\/p>\n<p>Select the cells containing the data that you want to turn into data types. Go to the Data Types section of the ribbon as described above and choose \u201cAutomatic.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724185\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/AutomaticDataType-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Automatic for the data type\" width=\"650\" height=\"424\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Within a few seconds, you\u2019ll see data types apply to your cells as denoted by icons. For instance, the animal data type will display a paw-print icon and the food data type will display an apple icon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724186\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/ApplyAutomaticDataType-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Automatic data type applied\" width=\"172\" height=\"153\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If the tool displays a question mark next to the data (like in the screenshot above), that means it\u2019s not sure which data type to use. Normally, that\u2019s because it fits into more than one. For instance, did you know that \u201cbacon\u201d is not only food but also the name of a city?<\/p>\n<p>Select the cell in question and the Data Selector sidebar will open on the right. You can then simply review the list of options and click \u201cSelect\u201d for the one you want. If you don\u2019t see what you\u2019re looking for, you can also use the search box in the sidebar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724187\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/SelectDataType-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the correct data in the sidebar\" width=\"650\" height=\"447\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The correct data type will then be applied to the cell. You can do this for any data cells with question marks.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Add_Data_Details\"><\/span>Add Data Details<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Once you have data types applied to the cells you want, it\u2019s time to put them to work. Click a cell to get started, and a small icon will appear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724188\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/InsertDataIcon-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the Insert Data icon\" width=\"329\" height=\"184\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click the Insert Data icon, and you\u2019ll see a scrollable list of information. You can then choose items from the list, and the details will populate the cells to the right. You can include as much or as little information as you like.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724189\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/PickDataDetails-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pick the data details from the list\" width=\"650\" height=\"465\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll find a plethora of details. Find a species for the animal data type, a body location for the anatomy data type, a production budget for the <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">movies<\/a> data type, and so much more!<\/p>\n<p>The details that you insert do not include references such as labels or headers. And if you have a lot of data and data types, your sheet can fill up quickly. Simply click the cell containing the information that you added, and you\u2019ll see the details in the formula bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724190\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/FormulaBarDataDetails-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data details in the formula bar\" width=\"645\" height=\"234\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Just make sure that you\u2019re connected to the internet when you apply or refresh the data.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Refresh_the_Data_Details\"><\/span>Refresh the Data Details<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>As previously mentioned, the data type tool in Excel gets its information from the internet. And many details change over time, sometimes even within the same day. To make sure that you always have the most current information, you can refresh it.<\/p>\n<p>Go to the Data tab and click \u201cRefresh All\u201d in the Queries &amp; Connections section of the ribbon. You\u2019ll see your cells containing data types display a refresh symbol briefly as the data updates.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724192\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/RefreshAllDataTypes-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Refresh All\" width=\"636\" height=\"397\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you only want to refresh one item, select the cell and click the arrow below \u201cRefresh All\u201d instead. Choose \u201cRefresh.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724191\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/RefreshDataType-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Refresh for one item\" width=\"500\" height=\"394\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The next time that you need to obtain data details for items in your Microsoft Excel spreadsheet, try out the data type tool. You can save time from manual research and refresh the data as much as you like!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use the Built-In Geography Feature in Microsoft Excel<\/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\/724177\/how-to-use-the-automatic-data-type-tool-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Use the Automatic Data Type Tool in Microsoft Excel&#8221; Add details to your Microsoft Excel spreadsheets for cities, foods, music, plants, and more. With the data type tool, there\u2019s no need to open your web browser. Just type in a keyword and go! When Microsoft implemented its data type tool in Excel, we&#8230;<\/p>\n","protected":false},"author":1,"featured_media":248473,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-248472","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\/248472","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=248472"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/248472\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/248473"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=248472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=248472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=248472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}