Filter by Date Range YAML Files Online

Filter YAML 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 YAML 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 (YAML)

- appointment_id: A-310
  clinic: Riverside
  appointment_at: '2026-03-31 16:45:00'
  outcome: attended
- appointment_id: A-311
  clinic: Riverside
  appointment_at: '2026-04-01 08:30:00'
  outcome: attended
- appointment_id: A-312
  clinic: Hillcrest
  appointment_at: '2026-04-17 13:00:00'
  outcome: no-show
- appointment_id: A-313
  clinic: Hillcrest
  appointment_at: '2026-04-30 17:15:00'
  outcome: attended
- appointment_id: A-314
  clinic: Riverside
  appointment_at: '2026-05-02 09:00:00'
  outcome: cancelled

Settings

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.

Frequently Asked Questions

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 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.

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.

YAML Viewer Online

View and inspect YAML files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.