Importing users - Best practices

Importing users - Best practices

As we discussed in our earlier forum announcement, the easiest way to onboard a large number of users to Zoho One is by importing them from a user data file. Zoho One allows you to import users from all the common types of user data files—XLS, XLSX, CSV, and VCF. It also supports ten different encodings, allowing you to import data in almost any language.

To learn more about importing users from the Users tab, go through this step-by-step guide to importing users from our Knowledge Base. Meanwhile, here are some best practices to keep in mind when importing users:

  • If your user data file is in an unsupported format such as TSV (Tab Separated Values) or SXC (OpenOffice Spreadsheet), import the file to Zoho Sheet, then download it in a supported format.
  • Download and use the sample file in the Import Users page of the admin panel as a template. The sample file is designed specifically for you and will include all the custom fields you created, helping you ensure that you didn't miss any important fields when creating the user data file.
  • Purchase the required licenses before importing users as you will not be able to import more users than your available license limit. For example, if you have 50 available licenses and try to import 70 users, only the first 50 users in the file will be added to Zoho One.
  • Map as many fields as possible, even though they are not mandatory. This will allow you to use advanced filters and set up Conditional Assignment in the future.
  • Set a custom one-time password rather than mapping a Password field. This will make it easier for you to give users their credentials and allow users to set their own passwords during their first sign-in.
  • Remove all outdated entries from your user data file. If an outdated entry in the user data file has the same email address as an existing user, that user's information will be replaced with the outdated information present in the file.



We hope this was useful. Our next announcement will be about automatically syncing user information from LDAP servers such as Active Directory, OpenLDAP, and ApacheDS. Meanwhile, share your feedback in the comments, and let us know what else you'd like to learn from us!

    Access your files securely from anywhere







                            Zoho Developer Community




                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts



                                                            • Sticky Posts

                                                            • How to Add Users to your Organization in ZohoMail?

                                                              A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk)  In this topic, We will be discussing on how to Add and Invite users only.  The Import options are self explanatory. ____________________________________________________________________________________________________________


                                                            Manage your brands on social media



                                                                  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

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner









                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources

                                                                                              Zoho Writer

                                                                                              Get Started. Write Away!

                                                                                              Writer is a powerful online word processor, designed for collaborative work.

                                                                                                Zoho CRM コンテンツ



                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                              • Recent Topics

                                                                                                              • Why is Zoho Meeting quality so poor?

                                                                                                                I've just moved from Office 365 to Zoho Workplace and have been generally really positive about the new platform -- nicely integrated, nice GUI, good and easy-to-understand control and customisation, and at a reasonable price. However, what is going on
                                                                                                              • Items Below Reorder Point Report?

                                                                                                                Is there a way to run a report of Items that are below the Reorder Point? I don't see this as a specific report, nor can I figure out how to customize any of the other stock reports to give me this information. Please tell me I'm missing something s
                                                                                                              • Calendar week view: Today + 6

                                                                                                                Is there anyway to have the calendar change dynamically based on the date? Due to the amount of events, we only display a week at a time, but towards the end of the week, we can no longer see ahead to next week (without changing it manually every time).
                                                                                                              • How to restrict user/portal user change canvas view

                                                                                                                Hi , I would like to restrict user / portal user change their canvas view because I hide some sensitive field for them. I dont want my user switch the canvas view that do not belong to them But seems Zoho do not provide this setting?
                                                                                                              • How to add to Subforms via Zapier with Zoho Writer?

                                                                                                                I have the following layout for a Zoho Writer Document. As you can see there is a repeating subform taking in "Items". I am trying to make a Zapier integration with it, and I can see there is 1 field saying: "Items", but it does not specify how I'm supposed
                                                                                                              • Contrôles administratifs granulaires : un atout pour la sécurité des e-mails

                                                                                                                La moindre erreur dans votre système de messagerie peut coûter très cher à votre entreprise, tant en argent qu’en conformité et en image de marque. Pour beaucoup d’organisations, ce risque est bien réel. Les e-mails véhiculent quotidiennement des informations
                                                                                                              • Collections Management: #6 Realign Customers who gets back In-Term

                                                                                                                Arun stared at the subscription list on his dashboard. Another account had just been moved to Cancelled status after completing the whole dunning process. Nothing unusual, just that payment failures happen, retries fail, and cancellation is the expected
                                                                                                              • Zoho Mail IP Blacklist

                                                                                                                I need problems with send mails: Error: junk mail rejected - sender4-op-o10.zoho.com 136.143.188.10, is in RBL. Spamcop. Please remove FQDN for blacklist. Regards.
                                                                                                              • I can receive but not send emails

                                                                                                                Hello, I've been not able to send emails for almost a year now. I been using alternate email to do this. I want to know how to fix this so I can use my zoho account normally again.
                                                                                                              • The challenge of 24/7 connectivity: Being present and meeting customer expectations

                                                                                                                Before television entered our homes, radio was our window to the world. We had to tune carefully to catch voices from distant places. When television arrived, the world began to grow smaller. We can watch rocket launches, see the goal that wins our favorite
                                                                                                              • How to download all attachments from inbox, send, other folders in one go

                                                                                                                Hi All, Appreciate if anyone could help me with steps for below requirement. How to download all attachments from inbox, send, other folders in one go. Even mapping to new folder will help me. Thanks in advance.
                                                                                                              • Cannot connect mail accounts to Thunderbird

                                                                                                                Hi Support - I'm attempting to add my mail accounts to Thunderbird but I'm getting an unable to login to server error. I tried to use the password associated with my account I received the unable to login error. So I went into Zoho Accounts and generate
                                                                                                              • Alias Email Id already exists

                                                                                                                Hi, I just verified my domain sesque (dot) com and now I am trying to create the admin account using admin (at) sesque (dot) com, but I am getting an error saying "Alias Email Id already exists". I used to have another Zoho account with this email address,
                                                                                                              • Unable to connect to smtp server, connection timed out

                                                                                                                Hi Team, I am facing below issue, while sending out emails from thunderbird client. It used to work, facing this issue from morning. Error: Sending of the message failed. The message could not be sent because the connection to Outgoing server (SMTP) smtp.zoho.com
                                                                                                              • javax.mail.authenticationfailedexception 535 authentication failed

                                                                                                                Hi, I am facing 535 authentication failed error when trying to send email from zoho desktop as well as in webmail. Can you suggest to fix this issue,. Regards, Rekha
                                                                                                              • DKIM Verification Failed (Namecheap)

                                                                                                                Hi! I have already set up the TXT records in Namecheap but I keep getting the "Verification Failed" pop up. Was wondering if I'm the only one who has this problem and can anyone help me with this? Thanks!
                                                                                                              • Emails stuck in Queue

                                                                                                                Hi there, Since yesterday I have a few out going emails stuck in a queue. It say it will auto retry sending however nothing is happening. It seems to be affecting roughly 50% of my outgoing emails. Please help Thanks
                                                                                                              • Soft Bounce from transational emails from BREVO (Sendinblue)

                                                                                                                I manage the website of a client who uses your EMAIL service for the domain floranativadobrasil.com. And I use the BREVO email service, previously called SendinBlue, to send transactional emails about events specific to the website. All emails sent to
                                                                                                              • Ability to Edit YouTube Video Title, Description & Thumbnail After Publishing

                                                                                                                Hi Zoho Social Team, How are you? We would like to request an enhancement to Zoho Social that enables users to edit YouTube video details after the video has already been published. Your team confirmed that while Zoho Social currently allows editing the
                                                                                                              • Getting an error Address not found Your message wasn't delivered

                                                                                                                Hey, I'm trying to configure zoho mail for my website https://businessentity.org/ The email is meredith.karter@businessentity.org I'm able to successfully send the mails but when someone sends an email to above mail, this error shoots up: Address not
                                                                                                              • Support Uploading YouTube Videos Longer Than 60 Minutes

                                                                                                                Hi Zoho Social Team, How are you? We would like to request support for uploading YouTube videos longer than 60 minutes directly through Zoho Social. Your support team informed us that Zoho Social currently cannot upload videos over 60 minutes due to “API
                                                                                                              • Need Faster Help? Try Live Chat Support

                                                                                                                Hello there, We understand that sometimes, whether you’re facing an issue, exploring a feature, or need quick clarification, sending an email and waiting for a response just doesn’t cut it. You need answers, and you need them now. That’s exactly why we
                                                                                                              • Can't deactivate Spell Check

                                                                                                                Hi Community, right now I'm using the Zoho Mail Desktop-Software. So far, so good.. many possibilities. Overall very nice. What is extremely annoying right now, is that we are not able to deactivate the Spell Check feature. And we are barely able to focus
                                                                                                              • Zoho Toolkit Email Signature Generator

                                                                                                                I'm having real issues with the email signature generator with no matter where I host the photo, Zoho doesn't seem to show the photo on the link provided?
                                                                                                              • Company Policy Upload - Request All EE to review and sign

                                                                                                                How can I upload policies into Zoho People and have the employees review them and sign off saying they agree, etc.? Also, if I make a revision to a policy, I would like that changed or updated policy to be distributed or have the employees notified that
                                                                                                              • Zoho Sign Global Settings vs. Template and Document

                                                                                                                Hello, We are running into an issue on a current use case. We already use Zoho Sign. Now that KBA is available, we want to begin using it in our tax delivery process, by allowing clients to sign electronically, but also download a copy of their return
                                                                                                              • Zoho Mail Desktop Crashes on Linux - Ubuntu 24 LTS

                                                                                                                Hi, I have been trying to run the desktop app on Ubuntu for the past few day with no luck. I have tried both the .deb package and the appImage. When I attempt to open the app. It just crashes immediately. The crash error dialog appeared once and I cant
                                                                                                              • Can't login to Zoho mail

                                                                                                                I'm logged into Zoho but when I try to go in zoho mail I get: Invalid request! The input passed is invalid or the URL is invoked without valid parameters. Please check your input and try again. I just set up my mx records and stuff with namecheap a few
                                                                                                              • Zoho IP blocked by SpamCop

                                                                                                                Hi, Many of my emails are blocked and I receive this:  INVALID_ADDRESS, ERROR_CODE :550, ERROR_CODE :spamcop.mimecast.org Blocked - see https://www.spamcop.net/bl.shtml?136.143.188.51. - https://community.mimecast.com/docs/DOC-1369#550 [DGwIYPPSOfWI
                                                                                                              • Differences between Zoho Books and Zoho Billing

                                                                                                                Without a long drawn out process to compare these. If you were looking at these Books and Billing, what made you opt for one and not the other. Thanks
                                                                                                              • Server error when trying to Data > Sort > Custom Sort

                                                                                                                Been using Data > Sort > Custom Sort for a while, now it has suddenly stopped working. When selecting the same data range and trying to execute, I get "Sorry! There was a problem saving your last edit. Please try again."
                                                                                                              • To Assign a genrated pdf to a file upload field using delug

                                                                                                                content = "<html><body>HTML Content on page One <div style='page-break-after:always'></div> HTML Content on page Two </body></html>"; file = zoho.file.convertToPDF(content); file.setFileName("Name of the file"); <variableName> = <FormLinkName>[ID == input.ID];
                                                                                                              • TArgets To Accounts (Modules)

                                                                                                                How can i set sale target to Customers (Accounts Module)
                                                                                                              • Breaking barriers with multilingual WhatsApp templates in IM

                                                                                                                Ever wondered what it feels like to be greeted in your own language by a brand you love? A “Welcome!” feels nice, but a “¡Bienvenido!” or “स्वागत है!” feels personal. In today’s global world, conversations often need to cross both time zones and cross
                                                                                                              • How to share private Opportunities with whole org at an account level

                                                                                                                Opportunities are currently set to private, so our sales team only sees their own opportunities, along with their manager and upper leadership. The need is the ability for the rest of the Org to see the opportunities at an account level, not within the
                                                                                                              • New in Smart Prompt: Record Assistant for contextual assistance, and support for new AI models

                                                                                                                Smart Prompt helps teams stay informed and move faster by providing relevant suggestions where work happens in CRM. With this update, Smart Prompt becomes more adaptable to your organization’s AI preferences. You can now choose which Large Language Model
                                                                                                              • Problema Verificacion con proveedor NIC.AR

                                                                                                                No puedo realizar la verificación del correo, he seguido los pasos indicados y configurado los MX. Y no puedo verificar el correo. He leido en el foro que otros han tenido el mismo problema. Alguno pudo solucionarlo?
                                                                                                              • How to remove some users in zoho accounts

                                                                                                                How to remove some users in Zoho accounts.
                                                                                                              • Unified Inbox for all, including fetched mails

                                                                                                                I fetch mails from different third-parties mailboxes. But I need to switch mailbox too see fetched mails. It's strange. All mailboxes have one shared disk space for own mail and fetched mail, but why do we need to switch mailbox (on the left bottom) to
                                                                                                              • Whatsapp Limitation Questions

                                                                                                                Good day, I would like to find out about the functionality or possibility of all the below points within the Zoho/WhatsApp integration. Will WhatsApp buttons ever be possible in the future? Will WhatsApp Re-directs to different users be possible based
                                                                                                              • Next Page