downsizing files

RobertS82798
Participant

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 REPLY 1
William_A
Moderator

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Anyone can be a marketer! Visit our Blog & Resources page to brush up on the latest tips and tricks.
  • Support Tips

    Reporting Metrics

    "Authenticating your emails is the best way to ensure your emails achieve maximum deliverability. If you have your own domain, setting up self-authentication is especially important! " - Will

    See Article
    Avatar
  • Support Tips

    Call-To-Action Links

    "Target your most engaged contacts by creating a segment. Create a special offer or show your appreciation!" - Caitlin

    See Article
    Avatar
  • Support Tips

    Read Before You Send a Test Email

    "Did you know? You can send unlimited test emails to your verified email address, but only 50 in a 24-hour period to non-verified email addresses." - Nick

    See Article
    Avatar