Updating contacts physical address via a file, unable to select correct address field

Marketing Legend
0 Votes


Would like some help or advice. 

I am trying to upload contacts via an excel file, and when the system gives me the option to match the fields, I am struggling to match the physical address of our contacts to CC.

In the actual contact files, there are home, work and other fields for us to input their physical address.

But when you want to upload a file, it only states Address (Street address line and so on).

The question is if I select street address and so on, on the drop-down option when matching fields, where will that data go? Home, Work or other?

I don't want to do it individually as I have over 500 of them to update.

Any advice/ideas would be great 


Match field names optionsMatch field names optionsfrom contact detailsfrom contact details

0 Votes

Hello @OACP ,


At this time, the imported address lines will default to the "home address" section as it appears on individual contact windows. I've marked your account as interested in development of a way to differentiate between address types during the import process. If and when there's an update to this feature request, our engineers will notify you directly.

William A
Community & Social Media Support
0 Votes

I second this request. It is frustrating that within the individual contact windows there are three separate physical address types, Home, Work, and Other, but when uploading bulk contacts from a spreadsheet it will not allow you to select any specific address type. It defaults to putting any address data in the standard Home address field. Even if you name your heading exactly how the field is labeled within the individual contacts (e.g. Work Address Line 1), it will only put it in the standard Home address field! The suggested workaround of using Custom Fields is ridiculous because the field already exists, so why should you have to create a redundant one? Nonetheless, even if you do create a Custom Field, it puts the address data in the standard Home address field AND the Custom Field you created! This is simply unacceptable.

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
How confident are you about the effectiveness of your current marketing strategy?

Top Choice: Not confident at all (70%)

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
Jun 05
Constant Contact Community Walkthrough and Demo
2PM - 3:00 PM EST