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
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
JUN 27
Boost Your Email Results with Segmentation & Personalization
2PM - 3PM EST
JUL 10
Getting Started with the Constant Contact Community
2PM - 3PM EST