{"id":84,"date":"2018-06-05T04:30:18","date_gmt":"2018-06-05T11:30:18","guid":{"rendered":""},"modified":"2025-06-11T08:08:25","modified_gmt":"2025-06-11T15:08:25","slug":"cds-for-apps-excel-importexport","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/cds-for-apps-excel-importexport\/","title":{"rendered":"Working with data in the Common Data Service for Apps using the Excel Add-in!"},"content":{"rendered":"<p>\u00a0<\/p>\n<p>Getting data in and out of the Common Data Service for Apps is a fundamental task when building apps and flows, we&#8217;re happy to say the Import, Export and Open in Excel features are now available for the latest update of the Common Data Service for Apps. These features have been released in addition to the PowerQuery functionality already available in environments today. Working with data can take may forms, hence why we have multiple methods for importing, exporting and manipulating data within CDS for Apps. This blog will focus on the importing and exporting data from Excel and CSV files, and interacting with data using the Excel Add-in.<\/p>\n<p>Before we do, if you&#8217;d more information on the existing tools:<\/p>\n<ul style=\"margin-left: 40px;\">\n<li>PowerQuery is used to get data and transform it from a number of cloud services, and create entities as part of a single step while importing data. Find more information <a href=\"https:\/\/docs.microsoft.com\/powerapps\/maker\/common-data-service\/data-platform-cds-newentity-pq\">here<\/a>.<\/li>\n<li>Data Integrator is used setup reoccurring\u00a0data integrations between systems, typically managed by an admin to integrate data from other systems of records intoout of the Common Data Service for Apps.<\/li>\n<\/ul>\n<h3>Excel Add-in<\/h3>\n<p>The PowerApps add-in for Microsoft Excel allows you to open an entity in an Excel worksheet to view and edit your data. The Excel add-in allows you to refresh your data, create new records, delete and edit existing records all from within Excel. You can read more about the Excel add-in <a href=\"https:\/\/docs.microsoft.com\/powerapps\/maker\/common-data-service\/data-platform-excel-addin\">here<\/a>.<\/p>\n<p>To get started, go to web.powerapps.com and select the environment you&#8217;d like to use (If you don&#8217;t already have an environment, follow the steps <a href=\"https:\/\/powerapps.microsoft.com\/blog\/create-a-database-with-the-latest-version-of-common-data-service\/\">here<\/a>. You can open the Excel Add-in by first opening your list of entities (Data &gt; Entities) and selecting an entity from the list, from there you&#8217;ll see the <strong>Open in Excel <\/strong>appear on the command bar.<\/p>\n<p>Clicking this will generate a new Excel file and prompt you to download it, you can download the file onto your local drive, or OneDrive. Once you&#8217;ve downloaded and opened the file you&#8217;ll be prompted to enable add-ins, don&#8217;t worry at this point if the file contains no data &#8211; it needs to connect to your environment to refresh the data first.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.png\" style=\"width: 700px; height: 544px;\"\/><\/p>\n<p>Once the workbook has loaded, you&#8217;re now connected to your CDS for Apps environment and ready to start making updates. You can find a detailed guide <a href=\"https:\/\/docs.microsoft.com\/powerapps\/maker\/common-data-service\/data-platform-excel-addin\">here<\/a><strong style=\"font-size: 13.008px;\">.<\/strong>\u00a0Here are some quick tips to keep in mind:<\/p>\n<ul style=\"margin-left: 40px;\">\n<li>The Excel add-in connects to CDS using your credentials, the same permissions that would apply if you were using an app or flow, would apply here. If you don&#8217;t have permissions to access an entity, you&#8217;ll need to get access from your admin before using the add-in.<\/li>\n<li>You need to click &#8220;Publish&#8221; to have your changes published back to CDS, if you don&#8217;t click publish, they will not be reflected in other apps.<\/li>\n<li>Lookups are presented in the Excel workbook as two columns &#8211; the Display name, which is the friendly field you typically use to enter the name or primary identifier and the GUID, which is the system generated unique ID. The Excel add-in helps you update your data by presenting you a list of lookup values whenever you select a lookup field (either the Display or the GUID) but keep in mind &#8211; that as the Display isn&#8217;t always unique, you should avoid copy and pasting into this field as we won&#8217;t be able to match it against the record you&#8217;re trying to enter. If you need to copy and paste multiple lookup values, you should use the GUID field.<\/li>\n<li>The workbook will refresh by default when you open it &#8211; so make sure you publish your changes regularly, and before closing the workbook.<\/li>\n<\/ul>\n<p>For more information on the Excel Add-in, you can find a detailed guide\u00a0<a href=\"https:\/\/docs.microsoft.com\/powerapps\/maker\/common-data-service\/data-platform-excel-addin\" style=\"font-weight: 400; font-style: normal; font-size: 13.008px; font-family: Tahoma, 'Helvetica Neue', Arial, Helvetica, sans-serif;\">here<\/a><strong style=\"font-style: normal; font-size: 13.008px; font-family: Tahoma, 'Helvetica Neue', Arial, Helvetica, sans-serif;\">.<\/strong><\/p>\n<h3>Importing and Exporting Excel and CSV files<\/h3>\n<p>We are also reintroducing the ability to bulk-import and export data from Excel or CSV files by using the Get Data from Excel file and Export Data features for updated Common Data Service (CDS) for Apps environments.\u00a0With this feature, you can move data into single or multiple entities from Excel or CSV files. Alternatively, you can export data to a CSV file from single or multiple entities. Import and Export from Excel is accessible from the command bar by going to\u00a0<strong>Get Data &gt; Get Data from Excel,\u00a0<\/strong>or\u00a0<strong>Export &gt; Data<\/strong>.<\/p>\n<p>The import and export from Excel is a great option for importing and exporting data when:<\/p>\n<ul style=\"margin-left: 40px;\">\n<li>You&#8217;re working with a file on your local desktop, not on OneDrive for Business or other cloud location.<\/li>\n<li>You need to import or export multiple files at the same time.<\/li>\n<li>Your entities contain relationships to other entities and you want to use GUID or your primary keys to set the lookup (foreign key) on import.<\/li>\n<li>You need to export your data to Excel or CSV files and don&#8217;t require a live connection back to your data.<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/GetDatafromExcel.png\" style=\"width: 701px; height: 399px;\"\/><\/p>\n<p>You can find a detailed guide of how to import and export data <a href=\"https:\/\/docs.microsoft.com\/powerapps\/maker\/common-data-service\/data-platform-import-export\">here.<\/a><\/p>\n<h3>Helpful resources<\/h3>\n<ul style=\"margin-left: 40px; font-weight: 400; font-style: normal; font-size: 13.008px; font-family: Tahoma, 'Helvetica Neue', Arial, Helvetica, sans-serif;\">\n<li style=\"font-size: 13.008px;\"><a href=\"https:\/\/docs.microsoft.com\/powerapps\/maker\/common-data-service\/data-platform-excel-addin\">Open Entity data in Excel<\/a><\/li>\n<li style=\"font-size: 13.008px;\"><a href=\"https:\/\/docs.microsoft.com\/powerapps\/maker\/common-data-service\/data-platform-import-export\">Import and Export data from CDS for Apps<\/a><\/li>\n<li style=\"font-size: 13.008px;\"><a href=\"https:\/\/powerapps.microsoft.com\/blog\/create-a-database-with-the-latest-version-of-common-data-service\/\" style=\"font-size: 13.008px;\">Create a new environment for the Common Data Service for Apps<\/a><\/li>\n<li style=\"font-size: 13.008px;\"><a href=\"https:\/\/docs.microsoft.com\/powerapps\/maker\/common-data-service\/data-platform-intro\" style=\"font-size: 13.008px;\">Common Data Service for Apps Overview<\/a><\/li>\n<\/ul>\n<p>As always, if you have any feedback please reach out on our <a href=\"https:\/\/powerusers.microsoft.com\/t5\/Common-Data-Service-for-Apps\/bd-p\/CDS_Apps\">forums<\/a>.<\/p>\n<p>Thanks,<\/p>\n<p>Clay.<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Working with data in the Common Data Service for Apps (Import, Export and the Excel Add-in)<\/p>\n","protected":false},"author":114,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[],"job-role":[],"product":[3473],"property":[],"topic":[3421,3422],"coauthors":[2326],"class_list":["post-84","post","type-post","status-publish","format-standard","hentry","audience-it-professional","product-power-apps","topic-application-modernization","topic-hyperautomation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Working with data in the Common Data Service for Apps using the Excel Add-in! - Microsoft Power Platform 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\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Working with data in the Common Data Service for Apps using the Excel Add-in! - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Working with data in the Common Data Service for Apps (Import, Export and the Excel Add-in)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/cds-for-apps-excel-importexport\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-05T11:30:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:08:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.png\" \/>\n<meta name=\"author\" content=\"Clay Wesener\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clay Wesener\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/clay-wesener\/\",\"@type\":\"Person\",\"@name\":\"Clay Wesener\"}],\"headline\":\"Working with data in the Common Data Service for Apps using the Excel Add-in!\",\"datePublished\":\"2018-06-05T11:30:18+00:00\",\"dateModified\":\"2025-06-11T15:08:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/\"},\"wordCount\":911,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.png\",\"keywords\":[\"Dataverse\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/\",\"name\":\"Working with data in the Common Data Service for Apps using the Excel Add-in! - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.png\",\"datePublished\":\"2018-06-05T11:30:18+00:00\",\"dateModified\":\"2025-06-11T15:08:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.webp\",\"width\":700,\"height\":544,\"caption\":\"graphical user interface, table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Working with data in the Common Data Service for Apps using the Excel Add-in!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/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\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/cd7e2104194ffe93cfab1235d42f1ab4\",\"name\":\"Clay Wesener\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/CLWESENE-BW-96x96.jpgd7c7c5c6b20a907c86d2eb2b62dbc707\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/CLWESENE-BW-96x96.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/CLWESENE-BW-96x96.jpg\",\"caption\":\"Clay Wesener\"},\"description\":\"Clay leads the Power Apps Studio product team, enabling the next generation of developers and app makers on the Microsoft Power Platform with AI assisted development. This spans across our Power Apps maker tools, Copilot for Power Apps makers, Pro Dev tooling, Dataverse experiences, and Power Fx.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/claywesener\/\"],\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/clwesene\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Working with data in the Common Data Service for Apps using the Excel Add-in! - Microsoft Power Platform 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\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/","og_locale":"en_US","og_type":"article","og_title":"Working with data in the Common Data Service for Apps using the Excel Add-in! - Microsoft Power Platform Blog","og_description":"Working with data in the Common Data Service for Apps (Import, Export and the Excel Add-in)","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/cds-for-apps-excel-importexport\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2018-06-05T11:30:18+00:00","article_modified_time":"2025-06-11T15:08:25+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.png","type":"","width":"","height":""}],"author":"Clay Wesener","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Clay Wesener","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/clay-wesener\/","@type":"Person","@name":"Clay Wesener"}],"headline":"Working with data in the Common Data Service for Apps using the Excel Add-in!","datePublished":"2018-06-05T11:30:18+00:00","dateModified":"2025-06-11T15:08:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/"},"wordCount":911,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.png","keywords":["Dataverse"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/","name":"Working with data in the Common Data Service for Apps using the Excel Add-in! - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.png","datePublished":"2018-06-05T11:30:18+00:00","dateModified":"2025-06-11T15:08:25+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2018\/06\/ExcelAddin.webp","width":700,"height":544,"caption":"graphical user interface, table"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/06\/05\/cds-for-apps-excel-importexport\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Working with data in the Common Data Service for Apps using the Excel Add-in!"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/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\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/cd7e2104194ffe93cfab1235d42f1ab4","name":"Clay Wesener","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/CLWESENE-BW-96x96.jpgd7c7c5c6b20a907c86d2eb2b62dbc707","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/CLWESENE-BW-96x96.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/CLWESENE-BW-96x96.jpg","caption":"Clay Wesener"},"description":"Clay leads the Power Apps Studio product team, enabling the next generation of developers and app makers on the Microsoft Power Platform with AI assisted development. This spans across our Power Apps maker tools, Copilot for Power Apps makers, Pro Dev tooling, Dataverse experiences, and Power Fx.","sameAs":["https:\/\/www.linkedin.com\/in\/claywesener\/"],"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/clwesene\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/114"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":3,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"predecessor-version":[{"id":124620,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/84\/revisions\/124620"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=84"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=84"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=84"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=84"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=84"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=84"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}