Problems Importing Contacts
I experienced problems very similar to those that others have described when trying to import my contacts list. I exported the list from my Thunderbird v. 1.5.0.7 address book, choosing .CSV format. Having noted the advice to eliminate the apostrophe (�), I opened the file first in notepad, and did a search and replace to replace the � with nothing. It also occurred to me to eliminate the quotation marks (�). I then saved the file, retaining its .csv extension, and tried to import it. I received the same error message that others have,
�Please check whether the file is proper .xls or .csv file.�
I then imported it into Excel, and added column headings (field names) in the first row (these were not included in the original Thunderbird Export). I did not leave any spaces in the column heading names. I carefully used Save As, and chose CSV format when I saved from Excel. I then closed the file in Excel. I then tried importing again into Zoho, but got the same error message quoted above.
I then tried saving as Excel 97-2002 format. That gave allowed me to get to the second step in the importing process where I matched up my column headings with the field names available in Zoho CRM. However there were still problems of Zoho misinterpreting some of my fields, and not placing data in the fields where it belonged. I suspect that this is because I had included commas in some of the fields in my directory, and this threw off the field positions when those commas were combined with the commas added when I exported in CSV format.
I highly recommend that you add Tab delimited text as a format option for importing. It is very common for people to add commas to certain fields of their phone directory listings (the names of law firms are often separated by commas for example). It would not be practical for someone to go through hundreds of records by hand and eliminate all of the commas. On the other hand tabs are rare to non-existent within the fields of people�s address book entries. Excel can easily find tabs and use them to delimit the fields, and Zoho could too.
I also suggest that you test this a lot more yourselves by taking real address book data used by employees of your organization and or those of friends and family, and try exporting them from all the most popular email packages (Outlook, Outlook Express, Netscape, Mozilla, etc), and work with your importing routines until you get the import function to work the first time. Most address book data is confidential, so you are probably finding that few public users want to forward their files to you for testing as you request.
Also I recommend that you spell out more details of what the user needs to do to prepare his/her file for importing, so the he/she is aware that they need to do this before starting the import process.
Until these things are done, I believe that most people will judge Zoho CRM to be an interesting concept, but one that is a work in process, not yet an efficient, reliable tool. It�s nice to have a long list of features that impress journalists, but users will not rate your software highly until it works reliably the first time and every time that they try to import data.
Once these things are done I will be glad to go to places on the Web where software of this type is rated, and post a favorable review. For now though, I will wait and hope that the importing feature is improved substantially soon.
Get Started. Write Away!
�Please check whether the file is proper .xls or .csv file.�
I then imported it into Excel, and added column headings (field names) in the first row (these were not included in the original Thunderbird Export). I did not leave any spaces in the column heading names. I carefully used Save As, and chose CSV format when I saved from Excel. I then closed the file in Excel. I then tried importing again into Zoho, but got the same error message quoted above.
I then tried saving as Excel 97-2002 format. That gave allowed me to get to the second step in the importing process where I matched up my column headings with the field names available in Zoho CRM. However there were still problems of Zoho misinterpreting some of my fields, and not placing data in the fields where it belonged. I suspect that this is because I had included commas in some of the fields in my directory, and this threw off the field positions when those commas were combined with the commas added when I exported in CSV format.
I highly recommend that you add Tab delimited text as a format option for importing. It is very common for people to add commas to certain fields of their phone directory listings (the names of law firms are often separated by commas for example). It would not be practical for someone to go through hundreds of records by hand and eliminate all of the commas. On the other hand tabs are rare to non-existent within the fields of people�s address book entries. Excel can easily find tabs and use them to delimit the fields, and Zoho could too.
I also suggest that you test this a lot more yourselves by taking real address book data used by employees of your organization and or those of friends and family, and try exporting them from all the most popular email packages (Outlook, Outlook Express, Netscape, Mozilla, etc), and work with your importing routines until you get the import function to work the first time. Most address book data is confidential, so you are probably finding that few public users want to forward their files to you for testing as you request.
Also I recommend that you spell out more details of what the user needs to do to prepare his/her file for importing, so the he/she is aware that they need to do this before starting the import process.
Until these things are done, I believe that most people will judge Zoho CRM to be an interesting concept, but one that is a work in process, not yet an efficient, reliable tool. It�s nice to have a long list of features that impress journalists, but users will not rate your software highly until it works reliably the first time and every time that they try to import data.
Once these things are done I will be glad to go to places on the Web where software of this type is rated, and post a favorable review. For now though, I will wait and hope that the importing feature is improved substantially soon.
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
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
New to Bigin?
Sticky Posts
Good news! Calendar in Zoho CRM gets a face lift
Dear Customers, We are delighted to unveil the revamped calendar UI in Zoho CRM. With a complete visual overhaul aligned with CRM for Everyone, the calendar now offers a more intuitive and flexible scheduling experience. What’s new? Distinguish activitiesPresenting ABM for Zoho CRM: Expand and retain your customers with precision
Picture this scenario: You're a growing SaaS company ready to launch a powerful business suite, and are looking to gain traction and momentum. But as a business with a tight budget, you know acquiring new customers is slow, expensive, and often deliversCreate and populate a record in an instant: Introducing zero-shot field prompting to Zia's ICR
A couple of months ago, we upgraded our in-house AI image detection and validation tool, Zia Vision, with intelligent character recognition (ICR). By training Zia with sample images, you could create and enrich CRM records with data extracted from standardIn-person ZUG Meetups for Real Estate Professionals - US Q1 2026
The Real Estate Zoho User Group is going on a multi-city, in-person meetup tour across the US, and we’d love to see you there! These meetups are a great opportunity to: Connect with fellow real estate professionals using Zoho Share challenges and discoverNimble enhancements to WhatsApp for Business integration in Zoho CRM: Enjoy context and clarity in business messaging
Dear Customers, We hope you're well! WhatsApp for business is a renowned business messaging platform that takes your business closer to your customers; it gives your business the power of personalized outreach. Using the WhatsApp for Business integration
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Need to set workflow or journey wait time (time delay) in minutes, not hours
Minimum wait time for both Campaigns workflows and Marketing Automation journeys is one hour. I need one or the other to be set to several minutes (fraction of the hour). I tried to solve this by entering a fraction but the wait time data type is an integerSuggestion: Associating Assets with Company in Zoho FSM
Hello Team, I would like to share an idea based on practical experience. Currently, all assets in the Zoho FSM Asset module are linked to a specific contact person. I would like to know if it is possible to associate assets with a company instead. ThisZoho Inventory / Finance Suite - Extend Visibility of File Names on Attachment Fields
Hi Inventory / Finance Suite team, I noticed recently that when you add an attachment field to a module in Inventory, only the first 8 characters of the file name are visible on the details view. 8 characters is not a useful amount and there is plentyMany Notes Becoming Unusable
Hello. The Notebook app is becoming unusable. I'm getting odd-looking results from my searches. Some of the notes, after clicking on them, show an update button that does absolutely nothing. Not sure what has happened, but it would be nice to get thisKaizen #218: Actions APIs - Field Updates
Hello all!! Welcome back to a fresh Kaizen week. In the previous weeks, we covered Workflow Rules APIs, Actions APIs - Email Notification APIs, and Tasks Update APIs. This week, we will continue with another Actions API - the Field Update API in ZohoHow Contract Types and Templates Form the Backbone of Zoho Contracts
Every contract in Zoho Contracts starts with two essential elements: Contract Type and Template. These are not just administrative steps. They define how every contract in your organization is created, governed, and managed over time. Let us look at theZoho Books Finance Modules Not Accessible in Zoho CRM Mobile App
We have integrated Zoho CRM with Zoho Books using the Zoho Finance Suite integration. In the CRM web version, we can see the Finance modules (Estimates/Quotes, Invoices, Sales Orders, Items, Payments) and are able to create invoices and quotes directlyCRM Related list table in Zoho analytics
In Zoho Analytics, where can I view the tables created from zoho crm related lists? For example, in my Zoho CRM setup, I have added the Product module as a related list in the Lead module, and also the Lead module as a related list in the Product module.Zoho learn Custom portal - networkurl & CustomPortalId
I want to get my individual account’s networkurl and customportalId to use in this API: https://learn.zoho.com/learn/api/v1/portal/<networkurl>/customportal/<customportalId>/manual How can I retrieve the networkurl and customportalId using the API? IConnecting zoho creator to zoho writer to send prefilled documents
i will paste the worflow below // Get user's submitted data from the form userSalary = input.Current_Salary; userCIBIL = input.CIBIL_Score; userEmail = input.Email; userName = input.Name; // You need to get the Document ID from the URL of your Zoho WriterZoho Creator to Zoho Writer for prefilled documents...
In response to the question about connecting Zoho Creator to Zoho Writer for prefilled documents, I wanted to share a working implementation that demonstrates how to use the record_id parameter with the Zoho Writer Merge API. This allows Writer to automaticallyIntroducing our latest privacy enhancement - Hiding email IDs in Zoho Cliq Networks
Hello everyone, Zoho Cliq Networks offers a powerful collaboration platform that allows businesses to create dedicated digital workspaces for external vendors, partners, or individuals you want to communicate with professionally without adding them tozoho performance
OVERALL CONFIGURATION OF ZOHO PERFORMANCE Quarterly performance review Self rating and scoring Manager rating and scoringWhen will it be possible to edit Subform records via either views or tabular reports?
Hey there, data maintenance often requires mass update of quite a lot of records. While this is a piece of cake via either List view or Zoho sheet view, the same cannot be carried out for subform records yet. When one of the two options will be made available?Onboarding
Hello Team, Im yuktha working as HR at Ossisto Technologies. We are currently utilizing zoho for onboarding candidate. right now facing issue with onboarding Attaching the screenshots for your referenceArchiving Contacts
How do I archive a list of contacts, or individual contacts?How do I change a form's name? Why isn't this more intuitive?
Can someone please let me know how to change a form's name?Control Over Zia Generative AI Reply Assistance Behavior
Hello, I would like to request an enhancement to the Zia Generative AI feature, specifically concerning the Reply Assistance within Zoho Desk. Current Issue: When replying to a ticket, the Ticket Properties section is automatically replaced by the ZiaZia now integrated with Open AI in Zoho Desk
The powerful integration of Zia with OpenAI, has empowered Zoho Desk reach a new level of efficiency and performance. With contextual self-service capabilities, Zia enables agents to boost their productivity and delivers superior customer experiences.Zoho Desk Partners with Microsoft's M365 Copilot for seamless customer service experiences
Hello Zoho Desk users, We are happy to announce that Zoho Desk has partnered with Microsoft's M365 to empower customer service teams with enhanced capabilities and seamless experiences for agents. Microsoft announced their partnership during their keynoteEmployee self-service portal: Onboarding and continuous learning platform for support reps
Hello everyone, In any organization, employees must go through multiple courses to learn about the product, their organization's standards, and how to respond to customer queries using the knowledge base articles available. This typically requires completing2024 Email Authentication Standards: Elevating Security with Google and Yahoo
In contemporary email communication, email authentication plays a pivotal role in mitigating email fraud, spam, and phishing attacks. Brace yourself for a new level of security. Starting February 2024, Gmail and Yahoo will be implementing robust emailContact custom field in layout
Good day, all, I have an "Extension" custom field in contacts, and would like to display the contact extension in the ticket layout, but I don't seem to be able to. What am I missing? Thanks RudyExact match in name when searching workdrive
Hello, I am wondering how to search workdrive files/folders with an exact match in the name. For example, when I search across folder with the url param search[name]=someName, I get multiple results such as "someName", "someNameAndMore", or "someNameaccount in a diferent bas currency
Is it possible to have an account in currency diferente from base currency?, lets say, the bas currency in japase yen but asset accut called cash dollars in dollars?Meeting impossible to use when sharing screen
he Meeting tool in Brazil is practically unusable when sharing anything, whether it’s a presentation or simple navigation. When accessed via Cliq, the situation gets even worse: even basic calls fail to work properly, constantly freezing. And as you areChanging the Default Search Criteria for Finding Duplicates
Hey everyone, is it possible to adjust the default search criteria for finding and merging duplicate records? Right now, CRM uses some (in my opinion nonsensical) fields as search criteria for duplicate records which do nothing except dilute the results.Is there a way to create a desktop shortcut for a website course portal?
Hello everyone, I recently got a laptop and bought an online course from a website, Skillwint.com, which I visit regularly. I open that site many times a day and want to create a desktop shortcut so I can open it directly instead of searching in the browserSalesIQ Tip for Admins: Your Safety Net for Data Recovery
Ever clicked 'Delete' in your SalesIQ and then realized it was the wrong item? Maybe it was a prospect's chat that held important context you needed to refer to later on. Or, maybe you deleted an elaborate Zobot that you were still testing or planningDepreciated mergeAndStore Function Help!
Hello, I have a function designed to create a PDF containing information from the fields in a Deals record. There is a Writer Mail Merge template in WorkDrive that is populated via Deluge code, and a copy of the resulting PDF is then attached to the record.Can I execute two 'functions' when completing a mail merge from CRM?
Hi, I have set up a mail merge from CRM Deals to a template. I want a copy of this to be saved in Workdrive, and then a copy also saved back into the deal record from which the merge occurred. I can do both independent of each other, and managed to getExternal Share > Edit: Cannot Create Zoho Files
Hi Zoho, When we create an external share link with Edit permission, our external users are unable to create a Zoho file (Zoho Writer, Zoho Sheet and Zoho Show). They can only upload files. They can edit the Zoho files if we create them internally andZoho Mail iOS app update - RTL languages support and access emails using permalink and universal link, image upload resolution
Hello everyone! In the most recent version of the Zoho Mail iOS app update, we have brought in support for RTL languages(Arabic and Urudu), providing a seamless reading experience with proper text alignment and layout throughout the app. We have alsoWhy are emails sending with @viazohocrm.com ?
I just sent out mass emails from CRM. They are sending from the email below and people cannot reply, and they are getting this message: Address not found Your message wasn't delivered to sales.XXXXXXXX.com.au@viazohocrm.com because the address couldn'tDuplicating and referencing datasets
I am moving from PowerBI to Zoho Analytics and while I find Zoho easier to use in many ways, there is one function that I use in PowerBI that I have not been able to find in Zoho. I have several data sets that I need to modify in different ways to getZoho Inventory Now Supports VeriFactu for Businesses in Spain
Starting from January 1, 2026, Spain requires real-time invoice reporting for all B2B transactions. From July 2026, this requirement will extend to B2C transactions as well. All reporting must be carried out through the VeriFactu to AEAT (Agencia EstatalEnhancements to Zoho Map integration tasks
Hello everyone, We're excited to announce enhancements to the Zoho Map integration tasks in Deluge, which will boost its performance. This post will walk you through the upcoming changes, explain why we're making them, and detail the steps you need toLet’s Talk Recruit: Meet Zia, your all-in-one AI assistant (Part-3)
Welcome back to the Let’s Talk Recruit series. In the part 2 post, we explored how Zia has evolved with smarter summaries and seamless AI-assisted content creation. This time, we’re diving into the latest upgrades that take productivity even further —Announcing Early Access to "Zoho CRM for Everyone" — A new and exciting update to Zoho CRM
Update : Zoho CRM For Everyone's Nextgen Interface gets an upgrade! Hello everyone, We’ve updated the Zoho CRM for Everyone Nextgen interface based on your feedback. The UI is now simpler with a unified sidebar, a more visible global search and featuresUnable to verify domain for Zoho People
I have added TXT records in my DNS (GoDaddy) [screenshot attached], but unable to verify even after 12 hours after adding. On checking the console, it shows some errors [screenshot attached]. It appears that the verification flow is broken - please provideNext Page