How to Import Leads into Microsoft Dynamics 365 for Sales CRM

by | Microsoft Dynamics 365

How to Import Leads into Microsoft Dynamics 365 for Sales CRM

by | Apr 12, 2018 | Microsoft Dynamics 365

Import leads easily with templates

This week in Microsoft Dynamics SupportI am going to show you how to import leads into Microsoft Dynamics 365 for Sales CRM.

See below for video and instructions:

How to import leads with a template

1.) Go to Settings > Data Management > Imports.

2.) Click on Import Data > Browse.

3.) Choose the file you’d like to upload, then click Next.

In this example, I used LeadUpload1.xls.

NOTE: If you used a template for the lead upload, your data will automatically be mapped. If not, see below for how to get a template for the upload.

4.) Set the owner on the Review Settings and Import Data screen, then click Submit.

Once submitted, your lead will show up on the My Imports leads screen. When the upload is completed, the status will show as “Completed.”

 

How to download a template for data import

1.) Go to Settings > Data Management > Templates for Data Import.

2.) Select the entity that you want to import the data for from the drop down list, then click Download.

You can use a text file, a compressed zip file, an Excel spreadsheet, or Excel workbook to do the data import.

 

Looking for a helping hand with Dynamics 365?

Our OnTrack CRM Success System helps you get the most from your CRM investment with support services including:

  • unlimited diagnostic support
  • unlimited answers to “How do I …?” questions
  • annual system audits
  • regular progress calls from a dedicated account manager
  • + additional valuable services!

We offer OnTrack in both month-to-month or annual subscriptions, and because we stand behind what we do, we offer a 100% money-back guarantee and you can cancel your plan at any time!

Azamba Q2 2025 Release Notes

Release Date: July 16, 2025At Azamba, we believe your CRM should make work easier, not add unnecessary complexity.Every update in this release is designed to help your team save time, reduce admin, and get more value from Dynamics 365, so you can focus on what matters...

Azamba Q2 2025 Add-On Update: Everything You Need Now in One Place

Chicago, IL – [July 16th, 2025] – If you’ve ever wished Dynamics 365 could just work the way your team does, you’re not alone. This summer, we’re making it easier than ever to get the most out of your CRM with a single solution, a cleaner workspace, and smarter tools...

Azamba releases EZ Buttons 3.0!

Chicago, IL – [November 20th] - We are thrilled to bring you EZ Buttons 3.0, a game-changing update packed with powerful tools to streamline your sales process and help you get more done, faster.  With EZ Buttons, turn time-consuming, multi-step tasks into quick,...

Why MSP’s Should Add CRM to Their Solution Portfolios

We’re entering a new era in CRM   All the old reasons for customers buying CRM are still valid but the advent of AI is making the case for renewed interest in CRM. To modify an adage, “If it’s interesting to my customers, then it is fascinating to me!”.  AI is...

Boost Your MSP Earnings with Strategic Partnerships

Time is money, we’ve been told since childhood  The idea is that people should focus their attention on the things that bring value to them and avoid the things that don’t. Since time is a precious resource, it makes sense to try and maximize its utility as it’s the...

CRM Launch in 5 Weeks – Get Results Fast!

New to CRM? Get it Right from Day One CRM is no longer a luxury. It’s an essential tool for businesses that want to stay competitive, responsive, and move fast. But for a lot of businesses, CRM quickly turns into a nightmare. Imagine this: You spend thousands of...

Ibrar Taki is a Microsoft Dynamics and Sage CRM technical consultant at Azamba. As the Azamba installation expert, Ibrar installs and configures systems, software, and servers. He also provides support and consulting services for Microsoft and Sage users.

Ibrar works hard to ensure your system generates maximum value for you and your team.

Related articles:

Azamba Q2 2025 Release Notes

Azamba Q2 2025 Release Notes

Release Date: July 16, 2025At Azamba, we believe your CRM should make work easier, not add unnecessary complexity.Every update in this release is designed to help your team save time, reduce admin, and get more value from Dynamics 365, so you can focus on what matters...

Azamba Q2 2025 Add-On Update: Everything You Need Now in One Place

Azamba Q2 2025 Add-On Update: Everything You Need Now in One Place

Chicago, IL – [July 16th, 2025] – If you’ve ever wished Dynamics 365 could just work the way your team does, you’re not alone. This summer, we’re making it easier than ever to get the most out of your CRM with a single solution, a cleaner workspace, and smarter tools...