I am trying to upload my contact list with the consent date and time. I am using Google Sheets to gather contact information and can't get the format in a form that can be uploaded. The form I have is . I've tried using the format command in Sheets but can't get it in an acceptable format. Any help is appreciated.
Hello @Miracleleaguejc ,
If Google Sheets can't give you the consent dates in a proper CSV / XLS type format, then you'll likely need to manually add those into a spreadsheet program so it can be uploaded. Otherwise, I'd advise reaching out to Google's support to see if there's a more streamlines or viable way of getting this info into an applicable spreadsheet format.
Way too many lines to manually change. I did find a solution that worked. I created a new column beside the google sheets column containing the consent date. In the first cell of the new column I entered the following command to convert the date information to text information in the proper format. =TEXT ( $B2, "yyyy-m-dd" ). I then just copied down the column by clicking and dragging the formula down the column. I successfully uploaded the CSV file once that was done. Thanks.
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 HereFeatured Article
Using Sections while designing your marketing email not only increases your own efficiency but helps you to deliver a more friendly, organized message. Check out some of the key benefits of using sections in email.
See ArticleFeatured Thread
If you listen to music while you work, share your playlist below so we can be inspired and maybe find some new music!
View threadFeatured Thread
Master email marketing fundamentals and transform your business.
Join challenge