Extract Tail of Excel Files Online
Extract the last N rows from Excel files directly in your browser. Choose how many rows to keep and download the result — no upload required.
How to extract Tail of Excel files
- Drop your file onto the upload area. The total row count is shown and the first 200 rows are previewed.
- Enter how many rows to keep from the end in the Number of rows box. The default is 100.
- Click Extract Last Rows. The preview switches to the final rows of the file, in their original order.
- 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 (Excel)
Excel workbook, first sheet (Sheet1)
| member_id | check_in_date | branch | minutes |
|---|---|---|---|
| M-2031 | 2026-08-28 | Riverside | 55 |
| M-1177 | 2026-08-29 | Old Town | 40 |
| M-2031 | 2026-08-30 | Riverside | 62 |
| M-0948 | 2026-08-31 | Riverside | NULL |
| M-1177 | 2026-09-01 | Old Town | 35 |
| M-3310 | 2026-09-01 | Riverside | 90 |
Settings
- Number of rows: 2
Result
| member_id | check_in_date | branch | minutes |
|---|---|---|---|
| M-1177 | 2026-09-01 | Old Town | 35 |
| M-3310 | 2026-09-01 | Riverside | 90 |
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.
Working with Excel files
The first sheet is used. Watch out for the end of the sheet. If cells below your data were ever formatted or edited, Excel's used range can run past the last real record. Those extra rows are read as empty rows, and they will be the first thing a tail returns.
Totals and notes rows at the bottom of a report sheet are also just rows to this tool. For a typical monthly workbook, the last row is often a SUM line. Formulas are read as their saved results, so that line comes through as numbers. The downloaded .xlsx has one sheet, named Sheet1, containing values only. Styling and formulas are not reproduced, and hidden rows are read like any other row. The row count shown after loading is the best check. If it is larger than the number of records you expect, the sheet has empty or extra rows at the bottom, and the tail will pick those up first.
Frequently Asked Questions
Why is the tail of my Excel file blank?
The sheet's used range extends below your data, so the last rows are empty. In Excel, delete the empty rows under your data and save, or remove blank rows with the Filter tool before taking the tail.
Does the Excel tail keep my totals row?
If the totals row is the last row on the sheet, yes. It is treated like any other row, and the formula results are kept as plain values.
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
Sort Excel Files Online
Sort Excel files by any column, ascending or descending, directly in your browser.
Filter Excel Files Online
Filter rows in Excel files by column value, directly in your browser. Your data stays on your device.
Extract Head of Excel Files Online
Extract the first N rows from Excel files directly in your browser. Choose how many rows to keep and download the result — no upload required.
Extract Tail of CSV Files Online
Extract the last N rows from CSV files directly in your browser. Choose how many rows to keep and download the result — no upload required.
Extract Tail of Parquet Files Online
Extract the last N rows from Parquet files directly in your browser. Choose how many rows to keep and download the result — no upload required.
Extract Tail of JSON Files Online
Extract the last N rows from JSON files directly in your browser. Choose how many rows to keep and download the result — no upload required.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.