Dynamics PTS Team Blog

A blog managed by Dynamics Partner Technical Services team for Global English

Sample Data Generator Series – Part 1: Overview of Generating Sample Data for Dynamics CRM

Sivakumar Venkataraman - Click for blog homepageI have long been wondering if we can build a logic to generate some sample data for Dynamics CRM. The sample data which gets installed with Dynamics CRM is very little and this does not help much especially when you have a requirement to present dashboards in CRM (or) demonstrate Power BI capabilities in Dynamics CRM. These functionalities are better demonstrated with quite a bit of data which can be well represented on dashboards and KPIs.

I was researching a little to find out if there were any articles (or) blogs which shared some insight regarding this and I came across the CRM Pre-Sales “Top Tips” Part 1 – Demo Data blog article by Simon Hutson. I would like to thank Simon for his efforts on this template, which made my life easier and helped me come out with this series of articles.

In this blog, he provides excel templates which can be used to generate some sample data which can be readily imported into Dynamics CRM. I have tested it with Dynamics CRM 2013 and later and it worked pretty well. However, the data in the sample template was more related to UK locale.

Hence I decided to tweak it a little bit and come out with a Americas version of the same template which can be imported into any Dynamics CRM environment with a US locale.

I am going to be posting a series of articles which give insight into how to utilize this template to generate sample data and also tips and tricks on the sample data which you can manipulate for your business requirements.

  • Sample Data Generator Series – Part 1: Overview of Generating Sample Data for Dynamics CRM
  • Sample Data Generator Series – Part 2: Ready to Use Sample Data Files for Dynamics CRM & How to Use It
  • Sample Data Generator Series – Part 3: Understanding the Sample Data Generator Template
  • Sample Data Generator Series – Part 4: Predefined Data Map Files for the Sample Data Imports
  • Sample Data Generator Series – Part 5: Tips & Tricks To Be Kept In Mind During Sample Data Generation/Import

In this article I have provided information about the files which can be downloaded for this purpose. The following files can be downloaded from the link here.

  • The Data Generator Excel File
  • Data Maps which have the predefined mapping for these import zip files.
  • Zip Files which has predefined sample data (ready to use)


In the next article, I will provide some insight into the sample data generator template and how to tweak it for your requirements.

Please note that the data in the sample files and the ones generated by the generator template are random data for demonstration purposes. This file is not covered under Microsoft support. This is an opensource template which can be modified to suit your demonstration requirements.

Happy Importing!!!

Update History:

# 1: 2017/07/31 – The OneDrive file sharing link has been updated to a new link. The old link broke, as I had restructured the OneDrive folder.