All Collections
People
FAQ
How to correctly define a prospect's time zone when importing from a CSV file?
How to correctly define a prospect's time zone when importing from a CSV file?
Reply Team avatar
Written by Reply Team
Updated over a week ago

If you want the system to correctly determine the prospects' time zone during CSV import, make sure the following criteria are met:

The Country column:

  • Cannot be blank;

  • The country name should be written in full (i.e. France) or as an abbreviation (i.e. FR).

The State column:

  • Can be blank only if the City column has a value;

  • The state name should be written in full (i.e. California) or as an abbreviation (i.e. CA).

The City column:

  • Can be blank only if the State column has a value;

  • The city name should be written in full (i.e. New York).

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

Important: all names must comply with ISO 3166, the international standard for country codes and codes for their subdivisions. This means that all names must be standardized and cannot be arbitrary.

Did this answer your question?