Solved: Format a file before importing a contact list into... - Constant Contact Community

DavidA161 · ‎10-19-2023

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

William_A · ‎10-19-2023

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

William_A · ‎10-19-2023

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

Format a file before importing a contact list into Constant Contact

The Power of Direct Subscriber Feedback: Measuring Customer Satisfaction

The Unintentional Humor of Spam Emails

How to Create Images of Multi-Page PDFs

Just Getting Started?

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.