SMS date and time format

0 Votes

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.

0 Votes

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.

William A
Community & Social Media Support
0 Votes

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.

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
Aug 07
Constant Contact Community Walkthrough and Demo
2:00 PM - 3:00 PM EST
Jul 25
Webinar: Master Your Digital Marketing Metrics
2:00 PM - 3:00 PM EST