Community Home
Resources
Events & Webinars
Learn
Groups
Product Ideas
cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Followers Are Great, Contacts Are Gold. Create a Free AI-Quiz With Lead Magnet to Share With Your Followers and Own Your Contacts!
Get Started

Format a file before importing a contact list into Constant Contact

SOLVED
Go to solution
DavidA161
Rookie
‎10-19-2023 04:27 PM
0 Votes
‎10-19-2023 04:27 PM

I am trying to upload a excel file with our contacts, but it keeps telling me I cannot upload an empty file. Please help.

Labels:
1 ACCEPTED SOLUTION
William_A
Administrator
Administrator
‎10-19-2023 05:29 PM
0 Votes
‎10-19-2023 05:29 PM

Hello @DavidA161 ,

 

Contact files will receive this error during upload when there are multiple sheets and the first one is completely blank. The contact import system will only be able to read and import from the first sheet of an XLS or CSV file. You'll need to remove these extra sheets so only the sheet you want to upload is first.

 

If you continue to have issues, please read through our article on properly formatting contact files prior to import, or call our general support for live assistance.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support

View solution in original post

1 REPLY 1
William_A
Administrator
Administrator
‎10-19-2023 05:29 PM
0 Votes
‎10-19-2023 05:29 PM

Hello @DavidA161 ,

 

Contact files will receive this error during upload when there are multiple sheets and the first one is completely blank. The contact import system will only be able to read and import from the first sheet of an XLS or CSV file. You'll need to remove these extra sheets so only the sheet you want to upload is first.

 

If you continue to have issues, please read through our article on properly formatting contact files prior to import, or call our general support for live assistance.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
  • Avatar

    Featured Article

    Why Picking the Right Fonts for Your Emails Matters

    When it comes to email marketing, design plays a huge role in grabbing attention and keeping your readers engaged.

    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
MAR 27
Revamp Your Email Marketing Using Metrics and Reporting
2PM - 3PM EST
Register now
Recommendations