Calculate Date Difference in NDJSON Files Online

What units can I calculate date differences in for a NDJSON file?

Days, hours, minutes, seconds, months, years, and weeks. The result is an integer — the number of complete units between the two dates. Fractional units are truncated, not rounded.

Do both columns need to be the same date format for the NDJSON date difference tool?

They should be compatible date or timestamp types. The tool casts text columns to TIMESTAMP automatically. If auto-detection fails, run the Date Parse tool on each column first to ensure they are proper timestamps before computing the difference.

Can I calculate the age in years of records in a NDJSON file from a birthdate column?

Yes. Choose the birthdate column as the start date and a fixed reference date (or another column) as the end date, then select years as the unit. The result column contains each record's age as an integer.

Is my data private?

Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.

What is the maximum file size?

The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.