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!

Make CRM Easier To Use With Fewer Clicks: Summer 2026 Release

Chicago, IL – [August 19th, 2026] – If you’ve ever gotten frustrated clicking through CRM just to finish a basic task, you're not alone. After 20+ years in CRM, we still see users lose time moving between screens just to log an activity, send an email, or find what...

Azamba Summer 2026 Release Notes

Enjoy A More Focused, Functional Workspace   Release Date: August 19th, 2026 - Tired of a cluttered CRM with too many clicks to get through your day? This release is built to fix exactly that, with powerful upgrades to some of our most-used Add-Ons. Plus, a brand-new...

Azamba Spring Release Notes

Enjoy More Freedom and Flexibility with Your CRM   Release Date: March 25th, 2026 - New updates are officially here, the CRM tools you know and love just got smarter. This Spring release focuses on giving you better visibility, easier task management, and a simpler...

Azamba Q4 2025 Release Notes

Smarter, Faster, and Easier Than Ever – CRM That Just Works   Release Date: October 29th, 2025 - Your favorite CRM tools just got a serious upgrade. This month’s updates to LaunchPad and the EZ Add-On Suite are focused on saving you time, reducing clicks, and making...

Azamba Q2 2025 Release Notes

Release Date: July 16, 2025 - At 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...

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...

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:

Make CRM Easier To Use With Fewer Clicks: Summer 2026 Release

Make CRM Easier To Use With Fewer Clicks: Summer 2026 Release

Chicago, IL – [August 19th, 2026] – If you’ve ever gotten frustrated clicking through CRM just to finish a basic task, you're not alone. After 20+ years in CRM, we still see users lose time moving between screens just to log an activity, send an email, or find what...

Azamba Summer 2026 Release Notes

Azamba Summer 2026 Release Notes

Enjoy A More Focused, Functional Workspace   Release Date: August 19th, 2026 - Tired of a cluttered CRM with too many clicks to get through your day? This release is built to fix exactly that, with powerful upgrades to some of our most-used Add-Ons. Plus, a brand-new...

Azamba Spring Release Notes

Azamba Spring Release Notes

Enjoy More Freedom and Flexibility with Your CRM   Release Date: March 25th, 2026 - New updates are officially here, the CRM tools you know and love just got smarter. This Spring release focuses on giving you better visibility, easier task management, and a simpler...