Troubleshooting Contact Imports

Generic selectors
Exact matches only
Search in title
Search in content
Filter by Categories
Account Management Help
add photos, video and audio
Add-on features and social media
Advanced
Advanced campaign settings
All about analytics
All about images
Basic steps
Calendar
Configure the Web Application Firewall (WAF)
Connect my Calendar and Online Storage to Workspace
contact support
copy files to my site
Create my email address
Customize campaign
Discover domains
discover linux hosting with cPanel
Discover Microsoft 365
Discover Online Storage
Discover Workspace Email
edit content
Email Marketing demo
expand your site with sections and pages
Explore email add-ons
Explore my account
Find server and port settings (IMAP/POP)
fine tune my website
get social
Get started with SSL certificates
Get the most out of Microsoft 365
help my site get found and monitor my metrics
Hosting & Servers
keep my account secure
Keep my email secure
know your privacy rights
Legacy
Manage your SSL certificate
Managed WordPress
Manual email configuration
Migrate and export my emails
My email account isn’t working (troubleshooting)
nameservers and DNS
online store
organize
parking, forwarding and monetizing
privacy and protection
publish my site
Quick Shopping Cart
Renew my products and services
renewals
Security
Set up a campaign
Set up email on my devices
set up my payment methods
Set up my Workspace Email account
start with the basics
Stay productive anywhere with Office apps
Streamline email tasks to help my business
transfer between accounts
transfer between registrars
Troubleshoot email and email setup
Troubleshooting
troubleshooting
Uncategorized
Upgrade and renewal options for email
Web & Classic Hosting
Website backups
Website Builder 7
Website Builder version 6
Website Security and Backups
Websites
work with databases
work with delegates
working with blogs

First of all, if you’re having trouble importing contacts into your subscribers area, don’t panic! We promise, everything will be ok. There are a few common reasons that your upload isn’t going as planned, and we’ll walk through them, here.

  1. Your file really needs to be in one of the following file formats for best outcomes:
    • .csv
    • .txt
    • .xls or .xlsx
    • .vcf (vCard)If your file is anything else, please re-save the file as one of those, and try it again. Saving your spreadsheet as a CSV is the best way to troubleshoot file format issues.
  2. Make sure you have headers in your file. The first row of your spreadsheet, or the first line of your text MUST be a header row. For example, your very first row or line should look something like this:
    Example layout for spreadsheet to import contacts.or this:Email, Name, Company
    molly@barkandwine.com, Molly Malloy, Molly’s Bark and Wineor like this:Email, First Name, Last Name, Company
    molly@barkandwine.com, Molly, Malloy, Molly’s Bark and Wine
  3. When using CSV or TXT files, the spacing of the headers must match the spacing of the data. If you used a single tab space between your data, there should be a single tab space between your headers. Likewise, if you have no space between your header items, then there should be no space between your data items.
  4. Make sure your headers are appropriately named. You have a lot of flexibility in the actual title you put in the header row, since ELITE WEB Co. Email Marketing is good at interpreting your intentions. But if you’re having trouble with an import, change your column headers to match any of the following exactly, and try it again:
    • email
    • name
    • firstname
    • lastname
  5. Your headers should all be a single word, if you’re having any trouble importing your contacts. Use an underscore between words, if you have to, but avoid spaces in your headers.
  6. Don’t use odd characters in your headers. No slashes, or dashes, or hashes, etc.
  7. Look for odd characters in the emails, or any email addresses that are not formatted correctly, like this: —@—.—
    Any email not formatted with an @ and a period will not import into your subscribers.
  8. Scan your file for any hard returns, or blank rows. Those can create problems and partial imports, if present.
  9. Lastly, make sure your file is fully uploaded! You can check the progress of your imports, using the Import history button in your subscribers area. Scroll down the page to the bottom of your lists, on the left. You’ll see the Import History button there, underneath all your subscriber lists. When the file has finished uploading successfully, it will show a green dot and Succeeded. If the dot is grey, and it says Processing, just give it a little bit of time to finish.

More info