Contacts

What format should I use to import date property values into HubSpot?

Last updated: January 5, 2017

Available For:

Marketing: Basic, Pro, Enterprise
Sales: N/A

When importing values to a Date Picker property using the basic (default) import, the date values must be formatted as mm/dd/yyyy to be passed properly into HubSpot. For example, 10/08/2014 represents October 8, 2014.

However, you can use the advanced options menu in the import process to choose a format for date properties that you have on your import (Note: all date properties in a single CSV file must be in the same format).

  • After you begin your import and have selected your CSV file, click Upload to move onto the Import details screen.
  • Within the Advanced Options section, locate Default format for date properties and choose the desired date format from the dropdown menu for this particular import.
Select date format
  • Using the October 8, 2014 example noted above, your options are:
    • mm/dd/yyyy (10/08/2014)
    • dd/mm/yyyy (08/10/2014)
    • yyyy-mm-dd (2014-10-08)

Please note: At this time, it is not possible to import time stamps into a Date Picker property.