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.
Support Tips
"There's a multitude of ways to engage your audience through us using your social platforms - via ads, social post metrics, email links, and more! " - Will
See ArticleSupport Tips
"Target your most engaged contacts by creating a segment. Create a special offer or show your appreciation!" - Caitlin
See ArticleSupport Tips
"Greet new contacts with one or more automated Welcome Emails depending on their interests or your business goals." - Nick
See Article