Instagram comment timestamps and time zones: what the export gives you
Timing questions come up constantly: did the entry come in before the deadline, when does the audience comment, how fast did people react. The answer is one column, posted_at_utc, and a few formulas.
Updated Nov 17, 2026 · 6 min read
What the column contains
Each row has a posted_at_utc value in the form 2026-11-01 14:05:09: year, month, day, then hour, minute and second on a 24-hour clock. The “utc” in the name is literal. The time is Coordinated Universal Time, not the time zone of the person who commented, the account owner or the person who exported. There is no time zone suffix and no offset, so a file you receive from someone else reads the same for everyone.
That is deliberate. A single reference time means two people in different countries who open the same file see the same values, and an export made in summer and one made in winter are directly comparable. The cost is that you convert once, to the zone you care about.
Convert to your time zone
Dates in spreadsheets are numbers where one day equals 1, so an hour is 1/24. In a new column next to posted_at_utc (column F in the CSV and Excel file), for a zone five hours behind UTC:
=F2-5/24
This works the same in Excel and Google Sheets. If the result looks like a number such as 46327.58, the cell is only formatted wrong: format the column as date and time. If the formula returns an error or the original cells are left-aligned, the values arrived as text. That is common in the Excel file and in some CSV imports. Convert them first:
=VALUE(F2)-5/24
Use a positive number for zones ahead of UTC, such as +2/24. For half-hour zones use fractions like 5.5/24.
Daylight saving is the catch. A fixed offset is right for part of the year only. If your zone changes its clocks, put the offset in its own cell and reference it, and use a different value for comments before and after the change: =VALUE(F2)+IF(F2<DATE(2026,11,1),-4,-5)/24 is the shape of it. Check the change date for your zone and year before you rely on it.
Questions the timestamp answers
- Was this entry on time? Convert the contest deadline to UTC and compare it with the column. If a giveaway closed at 9 pm in your local time, convert that moment to UTC, remembering whether daylight saving applied on that date, instead of comparing against the local clock. The results page also has a date range filter; compare a few rows near the boundary in the file to confirm the cut-off is where you expect it.
- When does my audience comment? With your converted column in G:
=HOUR(G2)gives the hour, and a pivot table with the hour in Rows and the count ofcomment_idin Values shows the shape of the day. - Which weekday?
=TEXT(G2,"dddd")returns the weekday name in English locales. - How fast did people react? Instagram’s own post time is not a column in the file, so take it from the post and enter it in a cell. Then
=(G2-$J$1)*24gives hours since posting for each comment, where J1 holds the post time converted to the same zone. - When did a conversation happen? Sort by timestamp and read the replies in order; see comment order in an export.
The timestamp is a snapshot of the time posted, not of the export
The value is when the comment was posted according to Instagram. It is not when you fetched it, and it does not change if you export again. The JSON export also carries a fetched_at field for the post as a whole, which tells you when the snapshot was taken. Record it if you are doing research or an audit; see notes for researchers.
Edits are a general caveat: if a comment text is changed after posting, you get the version that was public when the post was fetched. The file is a picture of that moment, and it stays downloadable for 30 days.
Charting comments over time
To see a post’s comment curve, use the date and hour of the converted column. In a helper column, =INT(G2)+HOUR(G2)/24 rounds each comment down to its hour. Make a pivot table with that column in Rows and the count of comment_id in Values, and insert a line chart. A sharp spike followed by a long tail often goes with a post that was pushed to a new audience; a steady drip is a post people find over time. Treat these as descriptions, not diagnoses: how Instagram distributed the post is not visible in the file.
For the other fields in the export, see the glossary of comment terms, or go straight to the tool. Up to 200 comments are free.
FAQ
What time zone are the timestamps in?
UTC. The column is called posted_at_utc and has no offset, so convert it to your own time zone with a formula such as =F2-5/24.
Why does my spreadsheet show the timestamp as text?
Some imports keep it as text. Convert it with =VALUE(F2) and format the result as date and time.
Does the timestamp change when I export again?
No. It is the time the comment was posted, not the time of the export.
Is the time of the post itself in the file?
No. Each row has the time of its comment. Take the post time from Instagram if you need time since posting.
How do I account for daylight saving time?
A fixed offset is wrong for part of the year. Keep the offset in a cell, and use different values before and after your zone’s clock change.