Calculate Date Difference in CSV Files Online
Calculate the difference between two date or timestamp columns in CSV files directly in your browser. Output in days, months, years, hours, minutes, or seconds — no upload required.
About this tool
Calculate the difference between two date or timestamp columns in a CSV file and output the result in days, hours, minutes, months, or years. Useful for computing durations, ages, lead times, or time-to-event metrics. Handles text date columns automatically. Everything runs in your browser — no upload needed.
Frequently Asked Questions
What units can I calculate date differences in for a CSV 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 CSV 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 CSV 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.
Related Tools
Merge CSV Files Online
Merge and concatenate multiple CSV files into one, directly in your browser.
Trim Whitespace in CSV Files Online
Trim leading and trailing whitespace from all text columns in CSV files, directly in your browser. No upload required.
Fill Empty Values in CSV Files Online
Fill empty and null values in CSV files with a custom replacement value, directly in your browser.
Transpose CSV Files Online
Transpose CSV files — flip rows and columns — directly in your browser. No upload, no server.
Change Delimiter in CSV Files Online
Change the delimiter in CSV files — switch from comma to pipe, semicolon, tab, or any custom character — in your browser.