How to import opportunities?

How to import opportunities?

Hi all,

I set up a couple of opportunities in the CRM itself, then exported them so that i had the correct field's etc for my larger import.

I have created the spreedsheet to import and i think i have set up everything ok, except for two issues.

1) i am told that zoho cannot find the parent account with the account id that i have supplied (even though i have checked and they all like up to the correct account id)

2) i am told that zoho cannot create the opportunity with a blank opportunity id... but i do not know the opportunity id as it hasnt been created yet!

Any help would be greatly appreciated.

Link to the csv file i am trying to upload is. https://kalibazar-my.sharepoint.com/personal/ned_lack_kalibazar_co_uk/_layouts/15/guestaccess.aspx?docid=0b9b50c8a9f2845968b887a3c82dfc884&authkey=AXBPs-hwxSd5Sy-NUydF0RQ