{"id":235154,"date":"2020-10-29T06:00:00","date_gmt":"2020-10-29T13:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/?p=235154"},"modified":"2022-06-28T12:14:01","modified_gmt":"2022-06-28T19:14:01","slug":"connect-to-your-own-data-with-more-new-data-types-in-excel","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/","title":{"rendered":"Connect to your own data with more new data types in Excel"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">The evolution of Excel<\/h2>\n\n\n\n<p>Excel is the ultimate decision-making tool. We\u2019re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base types of data you can work with: text and numbers. We\u2019ve been on a multi-year journey to up-level the types of data you can work within Excel, and you may have seen two examples of this already. The first was the introduction of dynamic arrays and array formulas, where a single formula could return an array of values. The second came with the introduction of the Stocks and Geography \u201cdata types,\u201d powered by Bing. These connected data types meant for the first time, a single cell in the grid could contain a live, connected, and rich set of information about objects like stocks, currencies, cities, and countries. That single cell would be intelligent in how it worked with features like formulas, filters, and charts.<\/p>\n\n\n\n<p>Today, we are taking the next step in that journey, and allowing customers to work with their own data as a data type. If, for example, you have a system for tracking your customers, and you want to bring that customer data into Excel for analysis, now you can import as a richly structured \u201ccustomer\u201d data type structured in the way you or your company have defined \u201ccustomer.\u201d If you are a Power BI customer, Excel will automatically connect to Power BI, and any data you\u2019ve published will be easily discoverable and flow into Excel as a structured data type. If you have data you\u2019d like to work with as a data type in Excel, just publish it into Power BI, and the rest is taken care of for you and anyone else with access. If you don\u2019t have Power BI, you can still leverage the Power Query technology in Excel to manually connect to dozens of different types of data sources, and specify that you want the data to be structured as a data type.<\/p>\n\n\n\n<p>We also continue to expand the number of public data types for you to work with expanding on the Stocks and Geography data types. We formed a partnership with Wolfram to allow hundreds of new data types to flow into Excel. Complement your analysis with connected data types like chemistry, nutrition, zip codes, historical events, even genetics. Join the <a href=\"https:\/\/insider.office.com\/en-us\/\" target=\"_blank\" rel=\"noreferrer noopener\">Insider\u2019s Beta program<\/a> to get a sneak peek of these capabilities and give us your feedback.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The evolution of data types<\/h2>\n\n\n\n<p>Before we get into more details on the new types of data you can connect to, I want to provide a bit more context on why the data types platform is so important and how it will improve the way you work with Excel going forward. Up to this point, the Excel grid has been flat: it\u2019s two dimensional. You can lay out numbers, text, and formulas across the flexible grid, and people have built amazing things with those capabilities. Not all data is flat though, and forcing data into that 2D structure has its limits. With Data Types we\u2019ve added a third dimension to what you can build with Excel. Any cell can now contain a rich set of structured data in just a single cell.<\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Video Player\" src=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE4Hy77\" class=\"c-video\" frameborder=\"0\" width=\"960\" height=\"540\" allowfullscreen=\"true\"><\/iframe><\/p>\n\n\n<p>Data types are rich, going well beyond numbers and strings\u2014just one cell value can contain a deep collection of hierarchical data, references to other data types, images, and intelligent actions. They are also connected and can point to live services providing data that can be refreshed at any time. This means data types offer you two key advantages over the old way of working with data, flexibility, and confidence.<\/p>\n\n\n\n<p>The advantage Excel has over any other data\/analytical tool is its flexibility. People are constantly evolving their spreadsheets to map the changing needs of their business processes. Until now, to get a value in a cell you either wrote a formula or typed the value directly into a cell. One cell, one value. If you wanted another value, you repeated the process; filling up the grid with a mix of disconnected data and helper cells. With data types, that all changes. Now a cell can contain a vibrant data type; one cell, a world of possibilities. Data types allow you to bring the data you care about into the grid, in its most natural form and unleash the power of Excel to gain critical insights. With data types, a single cell value can have a live connected set of information you can quickly pull into your decision-making process, without needing to constantly go back to the original source to find more information. Leverage the card view to see more information on that data type, and navigate through to related information. That additional information can be used in the formulas you write, charts you create, it can even be used to change how you sort and filter. This will allow you to build more vibrant spreadsheets, faster, with robust attributed data, and have less chance of error.<\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Video Player\" src=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE4HtgJ\" class=\"c-video\" frameborder=\"0\" width=\"960\" height=\"540\" allowfullscreen=\"true\"><\/iframe><\/p>\n\n\n<p>In addition to the flexibility, data types also give you more confidence in the data you are viewing. Avoid the risks of copy and paste errors. Import the data type for Seattle, and you can now use a formula to reference the population =A1.population. If the data type updates, the results of the formula will update too. And rather than just seeing the static number 729,601, you also can see the formula and you now know exactly where that number came from.<\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Video Player\" src=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE4Hong\" class=\"c-video\" frameborder=\"0\" width=\"960\" height=\"540\" allowfullscreen=\"true\"><\/iframe><\/p>\n\n\n<h2 class=\"wp-block-heading\">Data discovery and trust with Power BI<\/h2>\n\n\n\n<p>Since introducing Stocks and Geography last year, we heard it clearly that you want the ability to work with your own business data as data types. We worked closely with the Power BI team to provide rich, connected <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/introducing-excel-organization-data-types-from-power-bi\/ba-p\/1800153\" target=\"_blank\" rel=\"noreferrer noopener\">Power BI data in Excel as data types<\/a>. Power BI is the ideal source, with its best-in-class service that allows for shared, controlled, and secure access to data from all kinds of corporate sources. Data Types, connected to Power BI, give you that flexibility and confidence when you work with your business data in Excel.<\/p>\n\n\n\n<p>Just like Stocks and Geography, you&#8217;ll now be able to discover Power BI tables available to you through the data types gallery. You can then convert your cells into data types. Once cells have been converted into linked data types, you can then extract additional information to work within your spreadsheets. For example, if you enter a product code or name, you\u2019ll see additional information like a description, price, and available inventory all within the card view. <\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Video Player\" src=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE4HtgH\" class=\"c-video\" frameborder=\"0\" width=\"960\" height=\"540\" allowfullscreen=\"true\"><\/iframe><\/p>\n\n\n<p>Use those additional properties to do deeper analysis. Build invoices in Excel with connected and trusted data coming directly from Power BI.<\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Video Player\" src=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE4HkXh\" class=\"c-video\" frameborder=\"0\" width=\"960\" height=\"540\" allowfullscreen=\"true\"><\/iframe><\/p>\n\n\n<p>Additionally, because data types remain connected to the underlying source in Power BI, you are able to pull data from Power BI without needing to flatten it or lose all the information about the source of truth for that data. Power BI provides some of the most advanced governance controls over datasets, including over 140+ data sources on-premises and in the cloud, permissions-based access, row-level security, full application life cycle management, the ability for any user to apply <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/admin\/service-security-sensitivity-label-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Information Protection<\/a> labels, and for IT to certify. So, you can trust you are getting the right data every time.<\/p>\n\n\n\n<p>And of course, since Power BI data types are connected to live data sources, you can update your workbook by simply clicking <strong>Refresh Data<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create data types from your own data<\/h2>\n\n\n\n<p>While publishing your data into Power BI gives you and your team an easy way to discover and import data types into Excel, you can also create your own data types connecting directly to almost any data source you want. Excel has always supported a large set of data sources for direct import into the spreadsheet, and thanks to Power Query, you can also build powerful queries and transforms to get the exact shape of data you\u2019re looking for.<\/p>\n\n\n\n<p>Now, when you import data into your spreadsheet, you\u2019ll have the option to transform that data into a data type. In Power Query, you can <a rel=\"noreferrer noopener\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/announcing-power-query-data-types\/ba-p\/1782903\" target=\"_blank\">create your very own custom data types<\/a> using any source of organization data available within the <strong>Get Data<\/strong> menu\u2014files, databases, online services, other sources\u2014the list is long. From here, you can pull in, clean up and curate, and transform that data into custom data types according to your needs and preferences. These data types live within the workbook you\u2019re building, allowing you to simplify large volumes of data and make it easier for others in the organization to consume. But the additional data is connected and available whenever it\u2019s needed.<\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Video Player\" src=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE4HtgI\" class=\"c-video\" frameborder=\"0\" width=\"960\" height=\"540\" allowfullscreen=\"true\"><\/iframe><\/p>\n\n\n<p>Power Query data types provide the ultimate flexibility in building out custom solutions in Excel. And, you guessed it, Power Query data types will automatically update from the connected data sources with a simple click of <strong>Refresh Data<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Wolfram Alpha data types\u2014hundreds of additional data types coming to Excel<\/h2>\n\n\n\n<p>If you\u2019re a <a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/03\/30\/introducing-new-microsoft-365-personal-family-subscriptions\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft 365 Personal or Family subscriber<\/a> in the Office Insiders program, you may have noticed that the Stocks and Geography data types have a few new neighbors in the ribbon. We are currently previewing the first several of over 100 new data types that will pull rich information from Wolfram Alpha\u2019s online service into Excel.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/72670_Excel-Wolfram-Screenshot-In-Device-1024x611.png\" alt=\"\" class=\"wp-image-235235\" width=\"1024\" height=\"611\" srcset=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/72670_Excel-Wolfram-Screenshot-In-Device-1024x611.png 1024w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/72670_Excel-Wolfram-Screenshot-In-Device-300x179.png 300w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/72670_Excel-Wolfram-Screenshot-In-Device-768x458.png 768w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/72670_Excel-Wolfram-Screenshot-In-Device-1536x917.png 1536w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/72670_Excel-Wolfram-Screenshot-In-Device-1810x1080.png 1810w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/72670_Excel-Wolfram-Screenshot-In-Device.png 2014w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>To complement these data types, we are also building a new set of smart templates. The new smart templates will enable people to quickly get started with data types, and do things like track their nutritional information, research potential colleges, monitor stocks, learn chemistry, and much more.<\/p>\n\n\n\n<p>We\u2019ll be sharing more information about Wolfram Alpha data types as we get closer to general availability. In the interim, we hope you\u2019ll join the Office Insiders program and give us your feedback!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Availability<\/h2>\n\n\n\n<p>Power BI data types are available in Excel for Windows (current channel) for all Microsoft 365\/Office 365 subscribers that have a Power BI Pro service plan.<\/p>\n\n\n\n<p>Power Query data types are currently rolling out and will be available in the coming weeks for all Microsoft 365\/Office 365 subscribers, for use with all data sources supported in your SKU.<\/p>\n\n\n\n<p>Wolfram Alpha data types are available for preview to Office Insiders.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Next steps<\/h2>\n\n\n\n<p>We hope you\u2019ll bring all your questions and join us today for our <a href=\"https:\/\/aka.ms\/ExcelDataTypesEvent\" target=\"_blank\" rel=\"noreferrer noopener\">data types event<\/a>, where we will show you more examples and demos of the new things you can do in Excel with data types.<\/p>\n\n\n\n<p>To learn more, also check out our Excel blog for a deeper dive on <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/introducing-excel-organization-data-types-from-power-bi\/ba-p\/1800153\" target=\"_blank\" rel=\"noreferrer noopener\">Power BI data types<\/a> and <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/announcing-power-query-data-types\/ba-p\/1782903\" target=\"_blank\" rel=\"noreferrer noopener\">Power Query data types<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The evolution of Excel Excel is the ultimate decision-making tool. We\u2019re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base<\/p>\n","protected":false},"author":3368823,"featured_media":235158,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036,4062],"audience":[4101,4102],"tags":[],"coauthors":[4376],"class_list":["post-235154","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","product-power-bi","audience-personal-and-family","audience-small-business"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Connect to your own data with more new data types in Excel | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connect to your own data with more new data types in Excel | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"The evolution of Excel Excel is the ultimate decision-making tool. We\u2019re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-29T13:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-28T19:14:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"8256\" \/>\n\t<meta property=\"og:image:height\" content=\"6192\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Brian Jones\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/72670_Excel-Wolfram-Screenshot-In-Device.png\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brian Jones\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/brian-jones\/\",\"@type\":\"Person\",\"@name\":\"Brian Jones\"}],\"headline\":\"Connect to your own data with more new data types in Excel\",\"datePublished\":\"2020-10-29T13:00:00+00:00\",\"dateModified\":\"2022-06-28T19:14:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/\"},\"wordCount\":1866,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/\",\"name\":\"Connect to your own data with more new data types in Excel | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg\",\"datePublished\":\"2020-10-29T13:00:00+00:00\",\"dateModified\":\"2022-06-28T19:14:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg\",\"width\":8256,\"height\":6192,\"caption\":\"Surface Pro X and Surface Arc Mouse inside on desk with Excel and search on screen.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connect to your own data with more new data types in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connect to your own data with more new data types in Excel | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Connect to your own data with more new data types in Excel | Microsoft 365 Blog","og_description":"The evolution of Excel Excel is the ultimate decision-making tool. We\u2019re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2020-10-29T13:00:00+00:00","article_modified_time":"2022-06-28T19:14:01+00:00","og_image":[{"width":8256,"height":6192,"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg","type":"image\/jpeg"}],"author":"Brian Jones","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/72670_Excel-Wolfram-Screenshot-In-Device.png","twitter_misc":{"Written by":"Brian Jones","Est. reading time":"7 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/brian-jones\/","@type":"Person","@name":"Brian Jones"}],"headline":"Connect to your own data with more new data types in Excel","datePublished":"2020-10-29T13:00:00+00:00","dateModified":"2022-06-28T19:14:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/"},"wordCount":1866,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/","name":"Connect to your own data with more new data types in Excel | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg","datePublished":"2020-10-29T13:00:00+00:00","dateModified":"2022-06-28T19:14:01+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/10\/SUR21_ProX_Contextual_1456_RGB-1.jpg","width":8256,"height":6192,"caption":"Surface Pro X and Surface Arc Mouse inside on desk with Excel and search on screen."},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/10\/29\/connect-to-your-own-data-with-more-new-data-types-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Connect to your own data with more new data types in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/235154"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=235154"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/235154\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media\/235158"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=235154"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=235154"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=235154"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=235154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=235154"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=235154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}