Parse Dates in Excel Files Online
Parse and convert date columns in Excel 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 Excel 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 Excel 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 Excel 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 Excel 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
Search Text in Excel Files Online
Search for text across all string columns in Excel files directly in your browser. Filter rows to only those containing your search term and download the results — no upload required.
Get Top N Rows from Excel Files Online
Extract the top N rows per group from Excel files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.
Add Percent of Total to Excel Files Online
Add a percentage-of-total column to Excel files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.
Parse URL Column in Excel Files Online
Parse URL columns in Excel files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.
Add Lag / Lead Column to Excel Files Online
Add a LAG or LEAD column to Excel files to shift any column forward or backward by N rows. See previous day's sales, next value in a sequence, or any time-shifted comparison — runs entirely in your browser.