SmartQueryTools

Extract Tail of YAML Files Online

Extract the last N rows from YAML files directly in your browser. Choose how many rows to keep and download the result — no upload required.

How to extract Tail of YAML files

  1. Drop your file onto the upload area. The total row count is shown and the first 200 rows are previewed.
  2. Enter how many rows to keep from the end in the Number of rows box. The default is 100.
  3. Click Extract Last Rows. The preview switches to the final rows of the file, in their original order.
  4. Click Download to save them in the same format you uploaded, with _tail added to the file name.

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 leisure centre appends every member check-in to a single export. The front desk manager only wants the two most recent visits to check a disputed entry.

Input (YAML)

- member_id: M-2031
  check_in_date: '2026-08-28'
  branch: Riverside
  minutes: 55
- member_id: M-1177
  check_in_date: '2026-08-29'
  branch: Old Town
  minutes: 40
- member_id: M-2031
  check_in_date: '2026-08-30'
  branch: Riverside
  minutes: 62
- member_id: M-0948
  check_in_date: '2026-08-31'
  branch: Riverside
  minutes: null
- member_id: M-1177
  check_in_date: '2026-09-01'
  branch: Old Town
  minutes: 35
- member_id: M-3310
  check_in_date: '2026-09-01'
  branch: Riverside
  minutes: 90

Settings

  • Number of rows: 2

Result

member_idcheck_in_datebranchminutes
M-11772026-09-01Old Town35
M-33102026-09-01Riverside90

The file has six rows, so the tool skips the first four and keeps rows five and six. They stay in file order, oldest first, rather than being reversed. The tool does not look at check_in_date at all. It only works because new check-ins were appended to the bottom of the file.

Frequently Asked Questions

Are the last rows returned newest first?

No. They keep the order they have in the file. The last row of the file is the last row of the result.

Does Tail sort by date before taking the last rows?

No. It uses file position only. To get the latest N records by a date column, sort by that column first and then take the tail, or use the Sort tool followed by Head.

What if N is larger than the number of rows?

You get the whole file. An empty or non-numeric value falls back to 100. 0 and negative numbers are treated as 1, so you always get at least one row.

Related Tools