What are a few points to avoid for a smooth import of contacts from csv files?
Points to avoid in csv file while importing contacts are:
- Missing “@” symbol – For example, "jane.doegmail.com" is missing the “@” symbol.
- Missing "." – For example, "Patrick@yahoocom" is missing the period.
- Spacing in File – This could be due to the extra space present at the beginning of your list. The best way to prevent this error is to make use of the TRIM function to remove all spaces from the text.
- Email address with more than 6 characters after the last dot — For example, jane.doe@zylker.incostica
- Non-English characters
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Import Contacts
Adding each contact manually would not only be a time consuming process but also a tedious one. That is where the ability to import your contacts using a spreadsheet file will come in handy. Zoho Marketing Automation allows you to import contacts you ...What are a few important tips to remember while importing contacts from excel files?
Tips to remember while importing the excel files: Column headers should not exceed 255 characters. File size should not exceed 30 MB. Avoid using hyperlinks in email addresses. Add email addresses under the appropriate column headers only. When ...How to update subscription type of existing contacts via import?
You may know that you can import contacts into your Zoho Marketing Automation account by either uploading a csv file from your computer or choosing the file from a cloud service. During this import process, you can also change the subscription type ...Why are some of my contacts ignored?
There are a few reasons why you may see some contacts excluded from your list: Issue Type Reason Troubleshooting Bounced Mail was undeliverable to the contacts or the email address doesn't exist. Only hard bounced contacts will get ignored. If its a ...How to avoid complaints
As a growing business, you are bound to receive complaints from time to time. This guide will help you address any feedback you may receive and avoid situations that can be detrimental to your organization. Complaint life cycle Complaints are either ...
New to Zoho LandingPage?
Zoho LandingPage Resources