{"id":346272,"date":"2021-09-29T18:00:12","date_gmt":"2021-09-29T15:00:12","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-your-own-data-type-in-microsoft-excel\/"},"modified":"2021-09-29T18:00:12","modified_gmt":"2021-09-29T15:00:12","slug":"how-to-create-your-own-data-type-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-your-own-data-type-in-microsoft-excel\/","title":{"rendered":"#How to Create Your Own Data Type 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-6a2e43af864ca\" 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-6a2e43af864ca\" 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-your-own-data-type-in-microsoft-excel\/#Import_the_Data\" >Import the Data<\/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-your-own-data-type-in-microsoft-excel\/#Choose_the_Data_Columns\" >Choose the Data Columns<\/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-your-own-data-type-in-microsoft-excel\/#Create_the_Data_Type\" >Create the Data Type<\/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-your-own-data-type-in-microsoft-excel\/#Use_Your_Data_Type\" >Use Your Data Type<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Create Your Own Data Type in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\"\/><\/p>\n<p>If you often take advantage Microsoft\u2019s Data Type feature when including data in your sheets, but you wish a specific category would come along, there\u2019s an easy solution. You can create your own data type in Microsoft Excel!<\/p>\n<p>When Microsoft introduced its Data Type feature, you only had a few options like geography and stocks. The options then grew to include things like food, cities, plants, and more. But maybe you have a particular data type you\u2019d like to see, and that\u2019s where custom data types come in.<\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> The data type creation feature is only available to Microsoft 365 subscribers.<\/p><\/blockquote>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Import_the_Data\"><\/span>Import the Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this tutorial, we\u2019ll show you how to create a data type by importing data from a web source. But you can also use data from a text or CSV file or a spreadsheet. For our example, we\u2019ll import something fun: a list of <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/en.wikipedia.org\/wiki\/Angry_Birds\">Angry Birds video games from Wikipedia<\/a>.<\/p>\n<p>Go to the Data tab and choose your import choice from the Get &amp; Transform Data section of the ribbon. In our case, we select \u201cFrom Web.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749534\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/DataFromWeb-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Data tab, select From Web\" width=\"634\" height=\"158\"\/><\/p>\n<p>Enter the URL for the website, click \u201cOK\u201d and wait a moment for Excel to connect. You may be asked to select the level for the URL you enter. If so, make your choice and click \u201cConnect.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749532\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/EnterURL-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the URL for your data source\" width=\"500\" height=\"145\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Choose_the_Data_Columns\"><\/span>Choose the Data Columns<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When the Navigator window opens, you\u2019ll see the list of options found from your source on the left. You can click to view each one in the Table View tab on the right. If you would like to use more than one, click the Select Multiple Items checkbox at the top of the list. After selecting the data, click \u201cTransform Data.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749537\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/NavigatorPickData-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose a data table and click Transform Data\" width=\"629\" height=\"500\"\/><\/p>\n<p>Next, the Power Query Editor window <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>ears. This is where you\u2019ll choose the columns of data you want to use for the data type. You can choose multiple columns by holding Ctrl as you click each one.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749539\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/PowerQueryEditor-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select columns in the Power Query Editor\" width=\"650\" height=\"433\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_the_Data_Type\"><\/span>Create the Data Type<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you finish choosing the columns, go to the Transform tab and click the Structured Column drop-down arrow on the right side of the ribbon. Pick \u201cCreate Data Type.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749543\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/StructuredColumnCreateDataType-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Transform tab, click Structured Column, Create Data Type\" width=\"650\" height=\"145\"\/><\/p>\n<p>Now you can choose how you want the data to display. Enter the Data Type Name you want to use. In the \u201cDisplay Column\u201d drop-down menu, choose which column should display in your sheet for the data type.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-749548 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/CreateDataTypeWindow-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose a name and column\" width=\"650\" height=\"277\"\/><\/p>\n<p>If you want to remove columns you selected or arrange them differently, click \u201cAdvanced.\u201d Move columns you don\u2019t want from Selected Columns to Available Columns using the Remove button. To rearrange the order, use the Move Up and Move Down arrows on the right.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-749541 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/CreateDataTypeEdit-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Arrange the columns using the up and down arrows and the Remove button\" width=\"650\" height=\"514\"\/><\/p>\n<p>When you finish, click \u201cOK.\u201d The Power Query Editor displays once more with your data in a single column. The other columns you selected are condensed into this one column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749549\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/PowerQueryEditorCreatedDataType-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Power Query Editor with created data type\" width=\"650\" height=\"433\"\/><\/p>\n<p>Next, you\u2019ll load the data type into an Excel table. Go to the Home tab and click \u201cClose &amp; Load\u201d on the left side of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749552\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/HomeCloseLoad-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Home tab, click Close and Load\" width=\"498\" height=\"143\"\/><\/p>\n<p>You\u2019ll then see the data type column you selected in your Excel sheet. For our example, it\u2019s the <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/game\/\" data-internallinksmanager029f6b8e52c=\"7\" title=\"Game\" target=\"_blank\" rel=\"noopener\">Game<\/a> column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-749551 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/DataTypeLoaded-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data type loaded in Excel sheet\" width=\"388\" height=\"500\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_Your_Data_Type\"><\/span>Use Your Data Type<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You\u2019ll notice the data type icons next to each item in the list and you can insert other pieces of data the same way as Excel\u2019s built-in data types. Click the Add Column icon and choose the piece of data to insert. It automatically displays in a column to the right.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749556\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/AddData-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Add Column and pick the data\" width=\"650\" height=\"468\"\/><\/p>\n<p>Continue clicking the icon and selecting more data to insert as you wish.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-749555 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/AddedData-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data type data added\" width=\"650\" height=\"461\"\/><\/p>\n<p>To display the data card, click the icon next to one of the items. You\u2019ll then see the data card for that item pop open.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749554\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ShowDataCard-ExcelCreateDataType.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"476\"\/><\/p>\n<p>Using data types, you have a convenient way to insert data into your spreadsheet. And if you want to take that data to the next level, check out how to use data type templates.<\/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\/749529\/how-to-create-your-own-data-type-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Create Your Own Data Type in Microsoft Excel&#8221; If you often take advantage Microsoft\u2019s Data Type feature when including data in your sheets, but you wish a specific category would come along, there\u2019s an easy solution. You can create your own data type in Microsoft Excel! When Microsoft introduced its Data Type feature,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":346273,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-346272","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\/346272","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=346272"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/346272\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/346273"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=346272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=346272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=346272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}