After following the steps mentioned in our previous blogpost<\/a>, you\u2019d have downloaded the Excel that can be used to edit data in Dynamics 365 CRM. Now, let us see how to design it as per the requirement.<\/p>\n At first, you will be presented with the below options. (which means Design option is not visible by default.)<\/p>\n Also, all the columns (attributes) of an entity are shown in the Excel worksheet. However, seeing all the columns is not an ideal solution for data entry. In that case, the option of designing the Excel worksheet comes into the picture.<\/p>\n Let us see how to enable Design option.<\/p>\n Step 1: Click on the gear icon beside the username<\/p>\n Step 2: Scroll down and expand Data Connector<\/p>\n Step 3: Check the checkbox before Enable design and then click on OK.<\/p>\n Step 4: You must see the Design option. (the other four options are explained here<\/a>)<\/p>\n Since we have the design option let us see how to modify the Excel worksheet.<\/p>\n Step 1: Click on Design<\/p>\n Step 2: Edit the Data Source by clicking the pencil (In the next blog we will learn about Add table, Add fields and Labels)<\/p>\n Step 3: Below is the screen you will be presented with.<\/p>\n Let me explain each of the section in brief,<\/p>\n If this checkbox is enabled, after every publish you do, the data in the excel will be refreshed. Publish is a mandatory step to upload\/sync the data with Dynamics 365 CRM.<\/p>\n This will list down all the fields that are currently not there on the Excel worksheet.<\/p>\n This will list down all the fields that are there on the Excel worksheet.<\/p>\n Let us look at each of the options available in detail,<\/p>\n Once you select a field in the Available fields<\/strong> section, the Add<\/strong> button will be enabled and the user can add a field form the Available fields<\/strong> to Selected fields<\/strong>.<\/p>\n It adds the calculated field to the list. You can perform various math equations like Concatenate, Sum, etc. on the columns that we get from Dynamics 365 CRM.<\/p>\n Note:<\/em><\/strong> You can use Excel Formulas.<\/em><\/p>\n If you want to remove any field from the Selected fields<\/strong>, you need to select the corresponding field and hit Remove<\/strong>. It will move that field to the Available fields<\/strong> section.<\/p>\n These two buttons allow the sorting of the fields, and the columns in the Excel worksheet will be sorted accordingly.<\/p>\n The selected column would be a read only meaning the user will not be able to add value to it.<\/p>\n The selected column would be read only till the time data is not published.<\/p>\n Step 4: Once the necessary changes are done click on Update<\/strong> and then on the next screen at Done<\/strong>.<\/p>\n Step 5: You have the modified Excel worksheet ready to be used.<\/p>\n Note: <\/em><\/p>\n You can now make sure the columns available in the Excel worksheet to create\/update data are tailored as per the organization\u2019s need. Introduction In our previous blog, we explained a New way for creating and updating records in Dynamics 365 CRM. This blog post will be dedicated towards making sure the columns available in the Excel worksheet to create\/update data are tailored as per the organization\u2019s need. After following the steps mentioned in our previous blogpost, you\u2019d\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,18,19,24],"tags":[545,592],"class_list":["post-25973","post","type-post","status-publish","format-standard","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-dynamics-crm-2016","tag-dynamics-365-crm","tag-dynamics-crm"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/25973","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=25973"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/25973\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=25973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=25973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=25973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-1.png\")
<\/a><\/p>\n![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-2.png\")
<\/a><\/p>\n![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-3.png\")
<\/a><\/p>\n![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-4.png\")
<\/a><\/p>\n![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-5.png\")
<\/a><\/p>\n![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-6.png\")
<\/a><\/p>\n![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-7.png\")
<\/a><\/p>\n\n
\n
\n
![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-8.png\")
<\/a><\/p>\n\n
\n
\n
\n
\n
\n
\n
![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-9.png\")
<\/a><\/li>\n
\n![\"Design](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/Design-Mode-Edit-Data-in-Excel-10.png\")
<\/a><\/li>\n<\/ul>\nConclusion<\/h2>\n
\n
\n<\/a>![\"\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/12\/inolink.jpg\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"