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

In Excel: November 4, 2026 2:30:15 PM becomes 2026-11-04T14:30:15Z.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The 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"
3TEXT( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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