Filter by Date Range CSV Files Online
Filter CSV files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.
How to filter by Date Range CSV files
- Drop your file onto the upload area. The first date or timestamp column is selected and the pickers are pre-filled with its earliest and latest dates.
- Check the Date column. If no date columns were detected, every column is listed and the one you pick is converted to a date when filtering.
- Set the Start date, the End date, or both. Both ends are inclusive. Leave one blank for an open-ended range.
- Watch the live count, such as "3 of 5 rows match this range (60%)", which updates as you change the dates.
- Click Filter by Date Range, check the preview, then download the matching rows in the same format.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A clinic manager needs every appointment booked in April 2026 across two sites for a monthly attendance report. The file stores the full appointment time.
Input (CSV)
appointment_id,clinic,appointment_at,outcome
A-310,Riverside,2026-03-31 16:45:00,attended
A-311,Riverside,2026-04-01 08:30:00,attended
A-312,Hillcrest,2026-04-17 13:00:00,no-show
A-313,Hillcrest,2026-04-30 17:15:00,attended
A-314,Riverside,2026-05-02 09:00:00,cancelledSettings
- Date column: appointment_at (TIMESTAMP)
- Start date: 2026-04-01
- End date: 2026-04-30
Result
| appointment_id | clinic | appointment_at | outcome |
|---|---|---|---|
| A-311 | Riverside | 2026-04-01 08:30:00 | attended |
| A-312 | Hillcrest | 2026-04-17 13:00:00 | no-show |
| A-313 | Hillcrest | 2026-04-30 17:15:00 | attended |
Timestamps are cut to their calendar date before comparing, so A-313 at 17:15 on 30 April is kept even though it is later in the day than midnight. A-310 on 31 March and A-314 on 2 May fall outside the range. The time of day is not changed in the output. The live count showed 3 of 5 rows (60%) before the filter ran.
Working with CSV files
The date column list depends on what the engine detects when it reads the CSV. ISO values like 2026-04-17 or 2026-04-17 13:00:00 become DATE or TIMESTAMP columns and are selected automatically, with the pickers pre-filled. Other layouts, such as 4/17/2026 or 17.04.2026, may be read as text, and where every day is 12 or less the order of day and month is ambiguous. Check the column type in the dropdown and the pre-filled range before you filter.
If no column is detected as a date, every column is listed and you can pick the text one. The filter converts it with a strict cast, which only accepts ISO-style dates. A value such as "17/04/2026" or "April 17" stops the run with a conversion error rather than being skipped. Run Parse Dates first to convert other layouts. Rows with an empty date are NULL and are never kept. The output CSV contains the matching lines with dates written in ISO form.
Frequently Asked Questions
Why does my CSV date filter fail with a conversion error?
The column was read as text and holds dates in a non-ISO layout such as DD/MM/YYYY. Convert it with Parse Dates, then filter the new date column.
Are rows with a blank date kept in the CSV output?
No. A blank date is NULL and does not fall inside any range, so those rows are dropped.
Are the start and end dates inclusive?
Yes, both. Timestamps are cut to their date first, so everything on the end date is kept, whatever the time of day.
Can I filter with only a start date or only an end date?
Yes. Leave either picker empty for an open-ended range. At least one date must be set before the filter button is enabled.
Can I filter by time of day, such as 09:00 to 17:00?
No. The pickers work in whole days. Use the SQL Query tool for time-of-day conditions.
Related Tools
Count Values in CSV Files Online
Group and count rows by any column in CSV files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
Aggregate CSV Files Online
Group and aggregate CSV files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Truncate Dates in CSV Files Online
Truncate date and timestamp columns in CSV 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.
Filter by Date Range Excel Files Online
Filter Excel files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.
Filter by Date Range Parquet Files Online
Filter Parquet files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.
Filter by Date Range JSON Files Online
Filter JSON files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.
CSV Viewer Online
View and inspect CSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert CSV to Parquet Online
Convert CSV files to Parquet format directly in your browser. No upload required — your data never leaves your device.