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 saving an Excel file, the format should be saved as MS Excel 95 or later.
- When importing an Excel file, make sure to keep contacts on one sheet.
- Unexpected errors may occur if an XLS file contains any special controls, combo filters, or images embedded within it.
- Checkbox field value should be true or false.
- Date values must be in mm/dd/yyyy format. Dates in any other format will be ignored.
- DateTime values must be in mm/dd/yyyy hh:mm:ss format. Date Time values in any other format will be ignored.
- By default, character encoding is UTF-8 (Unicode). Make sure you provide the correct character encoding if your import file requires a different character code.
- We recommend that you test your import with a sample file before you import the actual data.
- Though we support Excel files, there is a possibility that it may not work due to other unknown errors. If this happens, we suggest converting your Excel file to a .csv file and trying the import again.
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 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?
Zoho DataPrep Resources
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 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 ...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. This can be a soft or hard bounce. If its a soft ...Why are the imported contacts marked as skipped?
Zoho Marketing Automation uses a Zero-bounce validation mechanism to evaluate the legitimacy of the Contacts. This mechanism checks if the email ID of the Contacts is active and has a valid inbox. If these criteria do not meet, those leads will be ...
New to Zoho LandingPage?
Zoho LandingPage Resources