Batch data / 04

Batch timestamp converter

Paste timestamp rows or drop a text or CSV file, review per-row errors, and download an annotated CSV in your browser.

0 converted · 0 failed

Convert lists without losing row order

Paste one value per line or load the first column of a local text or CSV file. Every row keeps its original input, detected unit, converted ISO result, and an error field. Invalid rows do not stop valid rows from converting.

File privacy and limits

The file is read with browser APIs and is not uploaded. The current limit is 2 MB and 10,000 timestamp rows to keep the page responsive. The preview shows up to 100 rows; the download includes the processed result set.

Spreadsheet safety

Open exported CSV files with care when untrusted source values begin with spreadsheet formula characters. This converter writes fixed result columns and does not execute source content.

How to use this tool

Paste one timestamp per line or drop a TXT or CSV file. For CSV, select the timestamp column and explicitly check the header option if the first row contains column names. No first row is silently discarded. Choose a fixed unit for a uniform source, or automatic detection for a genuinely mixed file, then press Convert.

Worked input and output

Input or settingExpected result
0 · s1970-01-01T00:00:00.000Z
-1 · s1969-12-31T23:59:59.000Z
1000 · ms1970-01-01T00:00:01.000Z

Checks before using the result

Interior empty rows remain errors with their original line numbers. A final newline terminates the preceding record. Downloads include source row numbers, original CSV columns, exact nanoseconds, ISO UTC, precision notes and errors. The preview shows 100 rows, but export includes all processed rows. The 2 MB and 10,000-row limits are enforced; larger jobs should be split. Check units before importing the results.

Frequently asked questions

Is my file uploaded to a server?

No. TXT and CSV files are read locally by your browser, and conversion plus download generation happen on the page.

How do I choose a timestamp in a multi-column CSV?

After loading the file, select the column that contains the timestamp. The tool does not guess among unrelated numeric fields.

Does an invalid row stop the whole file?

No. Each row is converted independently, so failed rows keep their input and error while valid rows remain exportable.

Tools / 01—06

More timestamp tools

Each route starts with a specific input and gives a specific answer.