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!