How to import trade show leads into Dynamics 365 (step by step)

To import trade show leads into Dynamics 365 Sales, download the Excel template for leads, paste your list into it, open Leads and choose Import from Excel. Every row needs a Topic and a Last Name. Map Lead Source to Trade Show, review the mapping and finish the import, then check My Imports for failed rows.

This guide is for sales teams that use Dynamics 365 Sales and come back from a show with a badge export, a spreadsheet or a pile of business cards. Every fact about Dynamics 365 links to Microsoft's own documentation.

Prepare the file for a Dynamics 365 lead import

The import wizard takes Excel workbooks (.xlsx), CSV files and XML Spreadsheet 2003 files. A file can be up to 8 MB, or up to 32 MB as a .zip file, and you import one file per run of the wizard (Microsoft Learn: import data). A list from one show is far smaller than that, so the real work is clean columns.

Microsoft suggests you start from the template your app gives you. Open Leads, select Excel Templates, then Download Template. Do not add or change columns in it, or the import can fail (Microsoft Learn).

How to import trade show leads into Dynamics 365, step by step

The steps below follow Microsoft's guide to importing data in model-driven apps, which Dynamics 365 Sales uses.

1. 1

   Step 1: Open Leads

   In the Sales Hub app, select Leads in the left menu.

2. 2

   Step 2: Start the import

   On the command bar, select Import from Excel, or Import from CSV if your file is a CSV.

3. 3

   Step 3: Upload the file

   Select Choose File, pick your file, select Open and then Next.

4. 4

   Step 4: Decide on duplicates

   Choose whether to allow duplicates. For a CSV file you also pick the delimiters here.

5. 5

   Step 5: Review the mapping

   Select Review Mapping. Columns with a green check mark are mapped. A red exclamation mark means you map the column by hand or choose Ignore.

6. 6

   Step 6: Map the choice lists

   Use the Option Set button to map the values in your Source column to Lead Source, for example to Trade Show. Values you do not map are not created in the app.

7. 7

   Step 7: Link the campaign

   If you track the show as a campaign, use Lookup Reference to link each lead to it in the Source Campaign column.

8. 8

   Step 8: Finish and track

   Select Finish Import, then Track Progress. Give the data map a name if you want to reuse it after your next show.

Duplicate leads: what Dynamics 365 checks during import

• Default rules cover accounts and contacts, not leads. Dynamics 365 has default duplicate detection rules for accounts and contacts, but not for other types of records. An admin can add a rule, for example one that compares Email in contacts with Email in leads (Microsoft Learn: duplicate detection rules).
• There is a limit on rules. You can publish only five rules for the same record type at a time, so agree with your admin which ones matter (Microsoft Learn).
• Sales has its own lead check. Dynamics 365 Sales can flag likely duplicate leads with the same email, the same phone number, a similar name and company, or a similar name and the same email domain. An admin turns it on in App Settings, Data improvement, Duplicate detection (Microsoft Learn: duplicate lead detection).
• The new merge screen is not for imports. Microsoft says the new way to detect and merge duplicates works when people enter data in the app, not during import (Microsoft Learn). Clean the file first: remove rows whose email already belongs to a customer.

After the import: check, fix and undo

• Watch the status. In My Imports, the status moves from Submitted to Parsing, Transforming, Importing and Completed. The Success, Failures and Partial Failures columns show how many rows worked (Microsoft Learn).
• Fix the failed rows. On the Failures tab, select Export Error Rows, fix the errors in the file and import only those rows again.
• Undo a wrong import. Select the import file and choose Delete imported records. Delete All also removes the source file.
• Know the limit. An Excel import updates only columns of the main table and ignores columns from related tables (Microsoft Learn).

Qualify only the good trade show leads

Most people you meet at a booth are leads, not deals yet. When you qualify a lead in Dynamics 365, you confirm it is a real sales opportunity, link an account and a contact, and create an opportunity to track the deal. Leads that do not fit can be disqualified, and the record stays for the audit trail. You can also qualify many leads at once (Microsoft Learn: qualify a lead).

A simple rule for the team: qualify a lead only when the booth note shows a real next step, such as a demo, a price or a meeting. Then send the first email while they still remember you. Our trade show follow-up email guide has timing and templates. With leads, opportunities and costs in one place, you can also work out your trade show ROI per show.

Common mistakes with event leads in Dynamics 365

• Free text for the show name. “ISE”, “ISE 2027” and “ise barcelona” split one show into three in your views. Pick one pattern for Topic, or use a campaign.
• Lead Source left empty. If you skip the Option Set step, your Trade Show values are not created and the column stays blank.
• No duplicate rule for leads. Without one, customers who stopped by the booth get a second record.
• Extra columns in the template. Adding or changing columns in the template is a common reason for a failed import.
• Typing business cards into a spreadsheet. It takes hours after a long show and adds typos to the email column, the one you need to find duplicates.

Before you email anyone, check that you have a lawful basis. Our guide on GDPR for trade show leads explains consent, legitimate interest and how long to keep event data. If part of your team works in another CRM, read how to import trade show leads into HubSpot, into Zoho CRM, or how to track them in Salesforce with campaigns.

From badge to Dynamics 365 without a spreadsheet

With Swopi there is no template to fill and no import to check. You connect Microsoft Dynamics 365 once in the Swopi dashboard with your organization URL and Microsoft sign in. Your team scans badges, business cards and QR codes on their own phones, and each lead appears in Dynamics 365 in seconds, in standard columns, with the event name. Swopi AI adds the missing email and company data from 20+ data providers and drafts the follow-up email from your booth note. Leads without typing. See pricing, or read how to scan event badges into your CRM.