Using a .csv file to import record to Zoho CRM giving me a problem
Hi.
I need to import some contacts from Salesforce into an account in Zoho CRM. In order to do this I need a .csv file.
As we all know, the "Account ID" field of the import is mandatory.
But basically this is what happens: the account id is:1754161000007234032, but Excel changes it 1.75416E+18 and therefore Zoho does not recognize it as a valid Account ID.
I have searched with Microsoft and Excel and it doesn't matter that I change the field in the .csv file to text, general, etc. after I save the file it goes back to 1.75416E+18.
My questions to you are:
1) Are you going to allow for a different type of file to do the import, such as .xls? and if so, how soon?
2) In the meantime, how do I go about completing the import without having to add 150 records one by one, if I still have to use a .csv file?
Thanks for your prompt response.
Dora