Skip to main content
A
Anonymous
March 15, 2013
Question

Importing List Problem - Not all names importing in

  • March 15, 2013
  • 7 replies
  • 2651 views
I previously imported an excel list into Markeot that I pushed out an email blast to. However, as i look back at that imported list i realize it did not include everyone that was in the excel spreadsheet. Why were some leads not imported into the list?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

7 replies

A
Anonymous
March 15, 2013
Does this list include new leads? If so, be sure to check the options you select during your upload. For instance the list import mode "Normal" will include new leads, but "Skip New Leads.." will not upload any new names.

Double check your excel list as well to make sure all formatting is correct for list uploads.

Great support article to make sure all is well: https://community.marketo.com/MarketoArticle?id=kA050000000KzWVCA0

A
Anonymous
March 15, 2013
Tim,

I always import with 'Normal' mode and use the CSV format, so i feel like i am using the right options when importing
A
Anonymous
March 15, 2013
Did you check your list for dupe email addys?  If there are any, subsequent leads w/same addys attached to them will overwrite the previous lead's info on that addy, and will leave you with a shorter list in the end.
A
Anonymous
November 23, 2015

Thank you for this tip. I had the same question. I had Excel check for duplicates and, Voila, the exact number that didn't import were duplicates. Thanks for your help.

A
Anonymous
March 15, 2013
Sometimes, I've noticed that I too have missing information when I upload a CSV list from an Excel worksheet. I then realize that when I saved to CSV I need to choose CSV (Comma Delimited). In my Excel I have 3 CSV "save as" options:

CSV (Comma Delimited)
CSV (MS-DOS)
CSV (Macintosh)

I've noticed that if I don't save as Comma Delimited, that there are funky things that happen to the upload.
A
Anonymous
March 15, 2013
Hmm I tend to always use the CSV (Comma Delimited), but maybe I didn't this time?

I'll check on the dupe email address as well - that's a good idea

Thank you for the feedback everyone!
A
Anonymous
March 15, 2013
When it comes to importing a list for an email blast, should I always remove all leads that have NO email address? What do most people find makese sense?
A
Anonymous
March 15, 2013
Yes.  No point in importing anything without an email addy, as that is the unique identifier in the lead database.
Terms & ConditionsAccessibility statement

Loading footer...