SMS date and time format

Miracleleaguejc
Participant

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.

2 REPLIES 2
William_A
Moderator

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

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.

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.

  • 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