Batch Unix Timestamp Converter
Convert a list of timestamps to dates in one go, entirely in your browser.
Batch converter
Paste timestamps above to convert them.
| Line | Input | Unit | UTC | Time zone | Note |
|---|
How to use this converter
- 1
Paste your timestamps. One per line. Blank lines are skipped, and a bad line does not stop the others.
- 2
Choose the unit and zone. Auto-detect reads each line separately; pick a unit to force one for all lines. Choose the output time zone.
- 3
Copy or download. Copy results as tab-separated text for a spreadsheet, or download a CSV. Both contain every row.
Example
The lines 1700000000, 1700000000123 and -86400 are read as seconds, milliseconds and seconds: 2023-11-14T22:13:20Z, 2023-11-14T22:13:20.123Z and 1969-12-31T00:00:00Z.
99999999999 is flagged as ambiguous: 5138 as seconds, but 1973-03-03T09:46:39.999Z as milliseconds.
How it is calculated
Each line is converted exactly with the same rules as the Unix Timestamp Converter: integers are exact, decimals are limited to the unit’s precision, negative values are dates before 1970, and the range is the years 1 to 9999. Everything runs locally, so the timestamps never leave your device.
Auto-detect. The unit is chosen per line from the size of the number: below 1011 seconds, below 1014 milliseconds, below 1017 microseconds, otherwise nanoseconds. Lines in the last decade below a boundary are marked ambiguous and show the other reading. Choosing a unit explicitly removes any guesswork.
Limits. Up to 10,000 lines are converted; the table shows the first 500 to stay fast, while copy and CSV contain everything. In the CSV, text that starts like a spreadsheet formula gets a leading apostrophe so opening the file cannot run it.
Questions
How do I convert a column from a spreadsheet?
Copy the column and paste it into the box; each cell becomes a line. Copy results gives tab-separated text that pastes back into columns.