Got a 'How do I' question? Join our live 'Ask a Trainer' session happening 11 am to 4 pm EST for instant help and pro tips!

Unrecognized Fields

GatorBandAlumni
Rookie
0 Votes

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.

GatorBandAlumni_1-1737797852949.png

 

What is happening when I try to import the same file.

GatorBandAlumni_2-1737797930251.png

 

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.

 

0 REPLIES 0
  • Avatar

    Featured Article

    The Power of Direct Subscriber Feedback: Measuring Customer Satisfaction

    Today, understanding customer satisfaction is crucial. How can you know if customers are happy with your products or services?

    See Article
  • Avatar

    Featured Thread

    The Unintentional Humor of Spam Emails

    Have you ever wondered who or what is on the other side of a spam email? Take 10 minutes out of your day and watch this lighthearted video!

    View thread
  • Avatar

    Featured Thread

    How to Create Images of Multi-Page PDFs

    Discover the process of transforming PDFs with multiple pages into image files directly on Constant Contact.

    See Article
Updates
Just Getting Started?

We’re here to help you grow. With how-to tutorials, courses, getting-started guides, videos and step-by-step instructions to start and succeed with Constant Contact.

Start Here

73% of SMBs express doubt that their marketing strategy is effective. Does this sound familiar? Read our Small Business Now Report to learn how you can tweak your strategy to see better results.

Go read our article
Upcoming Webinars
JAN 30
Chart Your Course to Capture Leads and Own Your Contacts
2PM - 3PM EST