How to convert your dates to ISO format in one click?

When you create an event from an Excel or Google Sheets file, it must contain date/time information in ISO format (a numerical representation of date and time that meets an international standard).

The ISO format is structured as 2023-07-24T13:00:00Z:

• Date format: YYYY-MM-DD
• Time format: HH:MM:SSZ
• "T" is a separator that allows computer systems to distinguish the date and time parts, which must be included in your file
• "Z" corresponds to UTC time (time according to geographical zone)

E.g.: in France, during summer time the Z parameter must be replaced by +02:00 and during winter time +01:00.

🗓️ Convert your dates to ISO format

We know it can be tedious to enter a large number of events in a spreadsheet while respecting this format. Here is a tip to simplify your event management:

1. Enter a start date and time and an end date in a standard date format in your spreadsheet using this format: DD/MM/YYYY (e.g.: 06/03/2026) or DD/MM/YYYY HH:MM (e.g.: 06/03/2026 20:00).
2. Create a custom date and time formula:

• Go to the "Format" tab, then click on "Number"
• Click on "Custom date and time"
• Create a template for date and time in ISO format

3. Select the cells with the dates to convert and apply your formula:
   • Go to the "Format" tab, then click on "Number"
   • Select the format you just created

The dates and times in your cells automatically adopt the new format.