Export a UTC timestamp with a Z suffix
Turn the UTC time November 4, 2026 2:30:15 PM into the text 2026-11-04T14:30:15Z.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The real date and time, already in UTC. | November 4, 2026 2:30:15 PM |
| 2 | "yyyy-mm-dd""T""hh:mm:ss" | The pattern: date, a capital T, then 24-hour time. | "yyyy-mm-ddThh:mm:ss" |
| 3 | TEXT( … ) | Writes the date and time in that pattern as text. | "2026-11-04T14:30:15" |
| 4 | &"Z" | Adds Z, which marks the time as UTC. | "2026-11-04T14:30:15Z" |
The doubled quotes keep T as a plain letter. Z only labels the time; it doesn't convert it.
=TEXT(A8,"yyyy-mm-dd""T""hh:mm:ss")&"Z"How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own dates and times. Paste real UTC dates and times into the green column of the Template tab. The export text fills in by itself.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Check your times are already in UTC. Adding Z labels them as UTC; it doesn't convert local times.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Export a timestamp with milliseconds
11/4/2026 2:30:15.123 PM → 2026-11-04T14:30:15.123
Get the template →
Export a timestamp with a known offset
11/4/2026 2:30:15 PM, -05:00 → 2026-11-04T14:30:15-05:00
Get the template →
Export milliseconds with an offset
11/4/2026 14:30:15.123, -05:00 → 2026-11-04T14:30:15.123-05:00
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →