How to use this office tool
- Upload a spreadsheet, select its sheet, and identify the date column.
- Enter an inclusive start date and end date.
- Process the rows, review unmatched or invalid-date counts, and download the filtered XLSX file.
Filter Excel by Date Range
Keep spreadsheet rows whose selected date falls within an inclusive start and end date, then export the filtered table.
Input and options
Local browser processingAd space
What this tool does
The filter interprets Excel serial dates, JavaScript Date cells, and common ISO-like date text, then keeps dates inside the chosen range.
Parsed date ≥ start AND parsed date ≤ end → keep row
Ambiguous text such as 03/04/2026 may be interpreted differently across locales; ISO YYYY-MM-DD is safer.
Supported formats and limits
XLSX and XLS workbooks are read with SheetJS. CSV and TSV are supported where listed. Each input file is limited to 25 MB, previews show at most 20 rows and 12 columns, and advanced Excel objects are not guaranteed to survive export.
| Processing | Inside this browser |
|---|---|
| Output | New XLSX file |
| Excel engine | Stored values; no full formula recalculation |
Tips for better results
- Confirm the workbook's date convention before filtering.
- Use ISO dates in text-based CSV files.
- Review the invalid-date count so malformed entries are not silently mistaken for out-of-range dates.
FAQ
Are the start and end dates included in the Excel filter?
Yes. The range is inclusive of both boundary dates.
Can the tool read Excel serial date numbers?
Yes. Numeric Excel date serials are converted using the workbook date system supported by the parser.
What happens to rows with invalid dates?
They are excluded from the filtered output and counted separately.
Can I filter date-and-time values by calendar date?
Yes. Comparisons normalize valid values to their calendar date for the selected range.
Why should I avoid ambiguous slash-formatted dates?
A value such as 03/04/2026 can mean March 4 or April 3. ISO-formatted dates reduce that uncertainty.
Related office tools
Privacy and output notes
| Uploads | None |
|---|---|
| Preview | Limited to protect browser performance |
| Download | Created only after successful processing |