Truncate Dates in Excel Files Online
Truncate date and timestamp columns in Excel files to a chosen precision — year, quarter, month, week, day, hour, or minute — directly in your browser. Rounds timestamps down to the start of each period. No upload required.
About this tool
Round every timestamp in a Excel file down to the start of a chosen time period — year, quarter, month, week, day, hour, or minute. This is the standard date_trunc operation used in SQL for time-series bucketing and GROUP BY aggregation. Common uses include grouping events into monthly or weekly buckets, aligning sensor readings to hour boundaries, and stripping time components before joining on date. The tool casts text columns automatically, replaces or appends the result, and runs entirely in your browser.
Frequently Asked Questions
What does truncating a date to month mean in a Excel file?
It sets the timestamp to midnight on the first day of that month. For example, 2024-03-15 09:45:22 becomes 2024-03-01 00:00:00. The date_trunc function rounds down, never up.
Can I truncate a text date column in a Excel file?
Yes. The tool automatically casts text columns to TIMESTAMP before truncating using TRY_CAST. If any values cannot be parsed as dates, those rows will return NULL in the output. Use the Date Parse tool first if you need to standardise the format.
What is the difference between date truncation and date formatting in a Excel file?
Truncation changes the underlying date value — it rounds it down to the nearest period. Formatting only changes how the date is displayed as text without altering the value. Use truncation when you want to group timestamps into buckets for aggregation or filtering.
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
Coalesce Columns in Excel Files Online
Fill null values in Excel files from other columns — return the first non-null value across up to 8 columns in priority order. Add the result as a new column. Runs entirely in your browser.
Add UUID Column to Excel Files Online
Add a UUID column to Excel files directly in your browser. Generate random UUIDv4 or time-ordered UUIDv7 identifiers for every row. Choose the column name and position — no upload required.
Pad Column in Excel Files Online
Left-pad or right-pad a column in Excel files to a fixed width directly in your browser. Zero-pad numeric codes, pad product IDs to a fixed length, or right-pad text fields — no upload required.
Compute Percentiles for Excel Files Online
Compute percentiles, median, MAD, mode, and kurtosis for numeric columns in Excel files directly in your browser. Optionally group by a category column. Results download as CSV — no upload required.
Find Arg Max / Min in Excel Files Online
Find the value of one column at the row where another column is maximum or minimum in Excel files — directly in your browser. Optionally group by a category to get per-group results. No upload required.