How to import data into ZC5 Address field?

How to import data into ZC5 Address field?

Hi,

I have a list of employees, with their addresses, to import into Zoho Creator 5 (the list was made on Excel). The addresses are scattered across 5 columns (address, city, province, postal code, country) and my Creator address field is configured to show these same 5 subfields. 

My problem is, when I try to import the data, Zoho doesn't let me match the 5 subfields with my 5 Excel columns. It only shows the main address field. I tried to concatenate the 5 columns into 1 and to match it with the address field, but it doesn't work either (everything ends into the first subfield).

My question is, how do I have to format my addresses so that they are correctly imported in ZC 5?

Thanks!


      • 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. ____________________________________________________________________________________________________________