By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Enhanced New Microsoft Excel Work Experience With MS CRM
Share
Notification Show More
Latest News
big data mac performance
Data-Driven Tips to Optimize the Speed of Macs
News
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
Artificial Intelligence
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Business Intelligence > CRM > Enhanced New Microsoft Excel Work Experience With MS CRM
CRMExclusiveNews

Enhanced New Microsoft Excel Work Experience With MS CRM

James Warner
Last updated: 2017/12/08 at 1:32 PM
James Warner
8 Min Read
Big Data & the Sharing Economy
Licensed Image from Shutterstock - By Kaspars Grinvalds
SHARE

Today we are discussing about the excel collaboration with CRM, we know that Excel has a lot of capabilities to manipulate, calculate and filter the data. Here, I am going to explain how to implement all these things with CRM.

Contents
In the latest version of CRM you can create 2 types of templates Excel and wordFollow the below steps- Login into CRM with your credential, click on Advanced find button for creating query.

In its initial release, CRM has Export to excel feature. In the latest version Microsoft Dynamics CRM has provided some of the predefined templates or we can say that, you can create your own template. This template gives you the base structure of your record, using such template you can quickly understand and analyze your data. In CRM 2015 and 2016 versions allows users to import and export sheet in excel format and it allows user to work with data from the downloaded template or Excel online.

This feature is also available for CRM mobile application, you can import and export Excel directly from your device i e, mobile & tablet.

In the latest version of CRM you can create 2 types of templates Excel and word

If you have records in CRM and you want to use the same at some other place. This is one of the best method to transfer the data using Excel.

More Read

CRM

CRM’s Have a Big Data Technical Debt Problem: Here’s How to Fix It

Top 10 Big Data CRM Tools To Increase Business Sales
Big Data Enabled CRM – Is It The Future Of CRM Software?
Big Data Leads To Startling Advances In Mortgage CRM Software
Call Center Analytics Move The Industry Into The 21st Century

First, I would like to show you how to export your CRM data in Excel Format.

Follow the below steps for more understanding-

1) Here in my CRM, I have a Account entity and I need to export my active account to different organization, For such requirements, We need to create a query. In this query, we need to find out my active accounts.

Follow the below steps-
Login into CRM with your credential, click on Advanced find button for creating query.

CRM

When you click on the “advanced find button” a popup is displayed here, you need to create your query for your account.

Refer the below image-

CRM

According to this image, we need to select entity name “Account” from Look for field and in lower dropdown we need to select field Status which is equal to “Active”.-

Refer the below image

CRM

2) After this, We need to click on “…” button label which shows the type of status of Account entity
Refer the below image-

CRM

When you click on “…” button, a popup will appear. We need to select status as Active and click on “>>” button.
Refer the below image-

CRM

Click on “Ok” button. Now your query will look like this-
Refer the below image-

CRM

After this,we need to run this query using Run “!” button which, I have highlighted this in the previous image.
When you run this query the output will look like this-

Refer the below image-

CRM

Now, you have 26 Record which has status Active.

3) After executing this query, we need to export this record in Excel format.
Refer the below image-

For exporting records, click on highlighted “Export Account” Button.

CRM

And export your records result as a dynamic worksheet.
See the below image-

CRM

When you click on this option, a popup will appear.
See the below image-

CRM

Here, if you wish you can add columns according to your requirement. Then, click on Export button.
Records will export to your system location.

See the below image-

CRM

4) After these steps, we have account data which has status active .

See the below image after export your account records is look like this-

CRM

If you want, you can create new records using this sheet.

Refer the below image for creating new records-

CRM

In this sheet, I am creating an account record namely Ridaana, after creating record, you need to save and close the sheet. Then import this sheet in CRM.

For importing data in CRM, you need to follow these steps-

Go to setting Data Management
Refer the below image-

CRM

When you click on Data Management, a new window with list of icon is displayed, here you need to select “Imports” icon

CRM

When you click import, a new window will open, Here you need to click on Import button from the ribbon-
In this window, you need to click on “IMPORT DATA” button for importing sheet.

CRM

Then, another popup is displayed here. You need to select the file which you want to import in CRM.

Refer the below image-

CRM

Then, click on next button. Another window will appear. Here, if you want you can allow duplicates. By default, No option is selected.
Refer the below image-

CRM

Click on the submit button.

CRM

Now the data import is finished.

You can check your import data status in System job-
Refer the below image for this-

CRM

This image shows that, we had imported a record in CRM account entity.

Let see the Account entity view-

CRM

5) This method was used earlier, but now in CRM, new enhancements have been done. We have Excel online feature which we can use easily,
Here, I am going to show, How to use Excel online feature?

Using this feature we are going to add a record in CRM.

For this, we need to go the account entity view where all the accounts are displayed.
From the ribbon we need to click “Export To Excel” button. When you select this button more than one option are being displayed. For our requirement, we need to choose “Open in Excel online” option.

Refer the below image-

CRM

When you select Open in Excel online your window will look like this :-
Refer the below image-

CRM

Here, you can create new record or update existing record. In the previous image, I had created a new record “Mariya”.
When your record creation is completed, click on “Save changes to Dynamics” Button.
When you click on this button a popup is displayed.

CRM

click on “close” button after that

It will appear in normal view-

See the below image-

CRM

See the below image-

Now we have created two records for account entity using two different methods.
Now I am going to show you the import data view-

CRM

Here, I am concluding my topic enhance Excel in 2016 version as I have shown you in example you can create update delete records from CRM using Excel online feature. It is very easy to understand. No need to export and import data every time. Ultimately the Microsoft dynamics AX development is a direly required solution for modern businesses that are dynamic, quick and efficient. Businesses can no longer afford hiccups, slow and malfunctioning processes.

TAGGED: crm, MS excel
James Warner December 8, 2017
Share this Article
Facebook Twitter Pinterest LinkedIn
Share
By James Warner
Follow:
James Warner is an highly skilled and experienced software and mobile application system development manager at Nex Software. He has wide experience in IT industries to develop creative business system based on Java, .Net, Python, Microsoft Dynamics AX Development, iOS, Magento and Android.

Follow us on Facebook

Latest News

big data mac performance
Data-Driven Tips to Optimize the Speed of Macs
News
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
Artificial Intelligence
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

CRM

CRM’s Have a Big Data Technical Debt Problem: Here’s How to Fix It

8 Min Read
Big Data

Top 10 Big Data CRM Tools To Increase Business Sales

9 Min Read
CRM and big data
Software

Big Data Enabled CRM – Is It The Future Of CRM Software?

7 Min Read
mortgage CRM software
Big DataCRMExclusive

Big Data Leads To Startling Advances In Mortgage CRM Software

7 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?