Parse Dates in JSON Files Online
Parse and convert date columns in JSON files between formats and timezones directly in your browser. Supports ISO 8601, US/EU dates, Unix timestamps, and custom patterns — no upload required.
About this tool
Parse date and timestamp strings in a JSON file and convert them between formats and timezones. Handles ISO 8601, US/EU dates, Unix epoch, and custom patterns. All processing stays in your browser.
Frequently Asked Questions
What date formats does the JSON date parser support?
Auto-detection handles ISO 8601 and standard text dates. You can also parse Unix epoch (seconds or milliseconds), US dates (MM/DD/YYYY), EU dates (DD/MM/YYYY), or any custom pattern using strptime syntax.
Can I convert between timezones in a JSON file?
Yes. Select the source timezone your dates are stored in and the target timezone you want to convert to. The tool uses AT TIME ZONE for accurate conversion.
What happens if a date cannot be parsed in a JSON file?
TRY_CAST is used for safe parsing — unparseable values become null rather than causing an error. Check the result preview for any nulls before downloading.
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
Extract Tail of JSON Files Online
Extract the last N rows from JSON files directly in your browser. Choose how many rows to keep and download the result — no upload required.
Add Row Numbers to JSON Files Online
Add a row number index column to JSON files directly in your browser. Set the column name and starting number — no upload required.
Validate JSON Files Online
Validate JSON file structure in your browser. Check null counts, distinct values, and data types for every column — no upload required.
Flatten JSON Files Online
Flatten nested JSON structures in JSON files into a flat table directly in your browser. Nested objects are expanded into prefixed columns — no upload required.
Count Values in JSON Files Online
Group and count rows by any column in JSON files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.