In effort to clean up our contact list, I exported an Excel sheet inclusive of the custom fields we created. Upon opening the file, I saw that we had multiple home numbers, multiple home addresses, etc for several contacts. These are NOT any of our custom fields. I did not change the names of the fields but I did try to consolidate them. For example: First Name: Jane Last Name: Doe Phone - home 1: 555-555-5555 Phone - home 2: blank (NOT A CUSTOM FIELD) Phone - home 3: 333-333-3333 (NOT A CUSTOM FIELD) I cleaned it up to be: First Name: Jane Last Name: Doe Phone - home 1: 555-555-5555 Phone - home 2: 333-333-3333 (NOT A CUSTOM FIELD) Phone - home 3: DELETED COLUMN Even though 'Phone - home 2' was in the Excel sheet I exported, when I try to import the cleaned up version of the file, it won't recognize 'Phone - home 2' as an existing field. And even if I wanted to create custom fields to collect the second phone number, I cannot delete the existing 'Phone - home 2'. What I exported is below. The yellow fields are not custom fields. What is happening when I try to import the same file. I don't want to lose any of the data we've collected, but I also don't want to be stuck having the same address show up under a contact 2+ times. Please help.
... View more
