- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Labels:
-
Contact Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @GatorBandAlumni. We took some time to review the exported files from your account and why the contact fields are not showing in the account when you attempt to import. Our advanced support team is going to look into this more. They'll reach out through the email on your account.
Caitlin M.
Community Manager
