Convert Days to Timestamp

This tool converts a list of numbers into full UTC timestamps, treating each one as a number of days since 1970-01-01 00:00:00 UTC. It supports decimals, so you can represent partial days like 1.25 for 1970-01-02 06:00:00.

Whether you’re decoding metrics, translating log timestamps, or converting exported data, the Convert Days to Timestamp tool gives you fast, accurate results without needing to write a single formula. You just paste in your list, and the output appears instantly.

Everything runs locally in your browser, with built-in options for trimming input, ignoring invalid entries, copying or exporting results, and importing from file formats like .txt, .csv, or .log.

Paste your input above or import a file below.
No file chosen
Supported file types: .txt, .csv, .tsv, .log, .json, .xml, .md, .ini, .yaml, .yml, .html, .htm, .css
Total items: 0
Options
Trim input lines
Ignore invalid values
Maximize output

How to Use:

  • Paste one number per line into the Input Days Since Epoch field.
  • Each number is interpreted as days after 1970-01-01 00:00:00 UTC.
  • Use the Trim input lines toggle to remove extra spacing (default: on).
  • Enable Ignore invalid values to skip negative or non-numeric lines.
  • Enable Maximize output to expand the output box for large datasets.
  • Output updates live as you type, or click Convert to refresh manually.
  • Click Copy Output to copy results the button briefly flashes “Copied!”.
  • Click Export to File to download the results as .txt.
  • Use Choose File to import values from supported formats.
  • Click Clear All to reset everything, including toggles and counters.

What Convert Days to Timestamp can do:

This tool helps you convert days-since-epoch into clear, readable UTC timestamps. A value of 0 becomes 1970-01-01 00:00:00. A value like 1.25 becomes 1970-01-02 06:00:00, since it’s one day and six hours past epoch.

The tool handles decimal values, large inputs, and invalid data safely. If a line includes not-a-number or a negative value like -5, the output shows Invalid, unless the ignore toggle is enabled.

Everything is formatted in UTC and padded for consistency, so it works well with Excel, APIs, logs, and audit files. It’s especially useful for decoding analytics exports, converting timestamps from systems that store relative time, or simplifying time math across tools.

Example:

Here’s how common input values convert into UTC timestamps:

Input:

0
1
1.25
30.5
365
1826
-5
not-a-number

Output:

1970-01-01 00:00:00
1970-01-02 00:00:00
1970-01-02 06:00:00
1970-01-31 12:00:00
1971-01-01 00:00:00
1975-01-01 00:00:00
Invalid
Invalid

Convert Days to Timestamp Table:

This table shows how 10 real-world day offsets convert to UTC timestamps. a backend system this gives you clarity in a clean, readable format.

DaysUTC TimestampDescription
01970-01-01 00:00:00Epoch start
11970-01-02 00:00:00Next day
1.251970-01-02 06:00:00One day and 6 hours
30.51970-01-31 12:00:00End of first month
3651971-01-01 00:00:00One year
7301971-12-31 00:00:00Two years
14611973-12-31 00:00:00Four years (includes leap day 1972)
18261975-12-31 00:00:00Five years
36531979-12-31 00:00:00Ten years
18262.52020-01-01 12:00:00Fifty years + 12 hours

Common Use Cases:

Use this tool when converting analytics timestamps, system logs, scheduled delays, or raw day offsets into full UTC datetime values. It’s perfect for making exported data readable, syncing systems, or simplifying time-based datasets.

Related Tools