Why aren't all of my contacts loading into Emma when I imported my spreadsheet?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
  • (Edited)
Did anyone ever have an issue where they had a certain amount of contacts but when they went to upload not all of the contacts showed up in the imports?
Photo of UChicago UEI Advancement

UChicago UEI Advancement

  • 1 Post
  • 0 Reply Likes

Posted 3 years ago

  • 0
  • 1
Photo of Grey Stepp

Grey Stepp, Support Team Manager

  • 1700 Posts
  • 135 Reply Likes
Official Response
Hi there!  

Thanks for reaching out!  There are a number of reasons that the numbers you're expecting to see on import aren't matching up.  

1. One thing that can throw folks off is the number they see under "Contacts Added".  This number is only showing you NEW contacts, and not anyone who was already in your audience.  

2. You'll want to make sure your spreadsheet is not broken up into pages.  Emma's import engine can only read single-page sheets, and if you have any on the second sheet, they won't be brought in. 

3. Emma will also not bring in any contacts on a spreadsheet that do not have an email address associated with it.  As Email addresses are the unique identifiers in Emma, every contact is required to have at least that. These show as the "SKIPPED ROWS" on the import screen.

4. Emma will also not bring in duplicate addresses. Again going back to the fact that the email address is the unique identifier for each contact in Emma, there can only be one contact record per email address.  This will show as "DUPLICATED ROWS".  Also note, the duplicated row will only count once.  For example, if you have 5 rows all with the same email address, this is recorded as 1 contact 1 duplicated row.  

5. Email addresses need to be only listed on a single column in the spreadsheet.  If you have addresses in a secondary column, they will not be imported unless you import the sheet a 2nd time and map that column to the email field.  

If none of these explanations fit the bill and you feel like you're still missing some addresses, upload your spreadsheet to the document library in your account (on the Campaigns page) and let me know.  I'll be happy to download it and take a look!

- G