Join us today to capture potential customers and manage your contacts @ 2 PM ET

downsizing files

SOLVED
Go to solution
RobertS82798
Rookie
0 Votes

First crack at this created an Excel file that was > 2 MB. (ugh) Switched it to a .cxv which was much smaller, but got warned that I might lose data. I can't see the spreadsheet because the rows are so short. What's the best way to downsize.

1 ACCEPTED SOLUTION
William_A
Administrator
0 Votes

Hello @RobertS82798 ,

 

You don't need to see all the compressed info in a CSV in order to import it into the system. Having a bunch of extraneous information, including unnecessary formatting of cells, can result in extreme slowness and errors when trying to import that much contact data. 

 

Generally speaking, if you're still struggling to import your file, consider removing columns of info that you don't actually need for your Constant Contact accounts. Or consider splitting the list up into separate files so their sizes reduce. 

 

For more info and advice on properly formatting contact files prior to upload, I'd recommend checking out this article.


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

View solution in original post

1 REPLY 1
William_A
Administrator
0 Votes

Hello @RobertS82798 ,

 

You don't need to see all the compressed info in a CSV in order to import it into the system. Having a bunch of extraneous information, including unnecessary formatting of cells, can result in extreme slowness and errors when trying to import that much contact data. 

 

Generally speaking, if you're still struggling to import your file, consider removing columns of info that you don't actually need for your Constant Contact accounts. Or consider splitting the list up into separate files so their sizes reduce. 

 

For more info and advice on properly formatting contact files prior to upload, I'd recommend checking out this article.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
  • 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