This article provides steps to format dates using Google Sheets for importing them as user properties using CSV files

Supported Format using Import from CSV option

  • Mailmodo recognizes and stores values in YYYY-MM-DD format for the DateTime properties uploaded via CSV. Values in any other format will not be stored
Please refer to this article if you are looking to import date properties via API and Integrations


Formatting using Google Sheets

Step 1: Select the cells you want to reformat

Step 2: Select Format > Number >Custom date and time

Step 3: In the ensuing pop-up, select the date in YYYY-MM-DD format and click on Apply


The dates will be changed to the YYYY-MM-DD format which is recognized by Mailmodo and the CSV can now be used to import the date values as user properties


Formatting using MS Excel

Step 1: Select the cells you want to reformat


Step 2: Select Format drop down > More Number Formats...


Step 3: In the ensuing pop-up,  select Date and click on Date and select format YYYY-MM-DD under Type and click Ok


The dates will be changed to the YYYY-MM-DD format which is recognized by Mailmodo and the CSV can now be used to import the date values as user properties