Problems with importing Account data

[Kerry]

I’ve got a csv file with just two fields. The account name and a custom value that we defined a custom field for in the accounts module.

I want to import this file to update the custom field without duplicating the account, but every time I try it re-adds a duplicate account name instead of updating the existing account.

I’m not sure what I’m doing wrong.

I’m using Version 7.14.4

[abuzarfaris]

You need to have the id field in the csv as well. when you have the id field during the first step of import

Select the 2nd Option “Create new records and update existing records”

[Kerry]

Thank you @ abuzarfaris That worked

[rsp]

Please mark answer as solution, so it will help others in the future,