All Collections
People
FAQ
How to correctly define a contact's time zone when importing from a CSV file?
How to correctly define a contact's time zone when importing from a CSV file?

Learn to set prospects' time zones correctly by following ISO 3166 standards in your CSV import

Reply Team avatar
Written by Reply Team
Updated over a week ago

To ensure the system accurately assigns the correct time zone to contacts during a CSV import, please adhere to the following guidelines:

Country Column:

  • Mandatory: This field cannot be left blank.

  • Format: The country name must either be spelled out in full (e.g., "France") or presented using its ISO 3166-1 alpha-2 abbreviation (e.g., "FR").

State Column:

  • Conditional Requirement: This field can be left blank only if the City column is populated.

  • Format: State names should be provided in full (e.g., "California") or as their ISO 3166-2 abbreviation (e.g., "CA").

City Column:

  • Conditional Requirement: This field can be left blank only if the State column is filled.

  • Format: City names must be spelled out in full (e.g., "New York").

If the system cannot determine the time zone, it applies the user's time zone to the prospect.

Important: All entries must conform to ISO 3166 standards, the international benchmark for country codes and their subdivisions. This ensures that names are standardized and eliminates the use of non-standard or arbitrary terms.

Did this answer your question?