Listed below are the most common reasons why your CSV import didn't upload all of your contacts, along with recommended actions you can take to avoid these situations in the future.
- Your CSV file has to be UTF-8 encoded. If your file is not UTF-8 encoded, then none of your contacts will be added to your account. This can happen if you are saving an XLS file as a CSV file. What you can do to ensure your file is UTF-8 encoded is to use Google Sheets to create the file and then export that as a CSV.
- Your file is too large or has too many custom fields. Especially large files or having several extra custom fields can cause the importer to fail. We recommend breaking the file down into smaller, multiple files and removing any fields that you don't need.
- Your contact(s) doesn't have an email address. Valid email addresses are required for all contacts. If you do not list an email address, or if you have included an email address that is not properly formatted, the contact will get skipped by the importer.
- Your contact(s) is on the exclusion list. If your contact is on the exclusion list, then the importer will skip them. You can read more about exclusion lists here.
- Your contact has bounced in the past, is unsubscribed, or you have duplicates of the same contact in your file. If you have any contacts in your file who have bounced in the past, is unsubscribed, or if you have duplicate contacts in your file, the importer will skip them.
- Your file contains special characters. Special characters include but are not limited to apostrophes (') and backslashes (\). If you have any characters in your file, you will want to make sure to enclose that particular field with double quotes. For example, if a contact in your file has the last name of O'Conner, you will want to make sure that it appears as “O'Conner” in your file.
- Your CSV file has more contacts than your plan allows. If you wish to increase the number of contacts that your plan allows, then you will need to upgrade your account on the Billing & Upgrade page.