CSV Tools CSV Tools

Last N Rows

Extract the last N rows from your CSV

CSV Input

Options

CSV Output

Last N rows will appear here...

More Options

CSV Format

Input

How to Use This Tool

This tool keeps only the last few rows of your CSV file. Just set how many rows you need from the end and the tool does the rest. It runs directly in your browser, so your data is never uploaded anywhere.

If your file has a header row, it will be kept at the top of the output automatically. The row count only applies to your data rows.

  1. Provide your CSV — Paste CSV text into the input area, drop a CSV file onto the File tab, or enter a URL on the URL tab.
  2. Set the row count — Enter how many rows you want to keep from the bottom. The default is 10. The tool shows the total number of rows in your file to help you decide.
  3. Get your output — Copy the result to your clipboard or save it as a .csv file.

FAQ

3 questions
Does this tool upload my data?
No. It runs entirely in your browser using JavaScript. Your CSV data is never sent to a server.
Does the header row count against the row count?
No. The header row is always preserved in the output and does not count against the row count. If you request 5 rows from a CSV with a header, you get the header plus the last 5 data rows.
Can I request more rows than my file has?
The row count is automatically limited to the number of rows in your file, so you'll always get a valid result.

More Row Operations Tools

9 tools

Remove Duplicates

Find and eliminate duplicate rows

Sample Rows

Pick a random sample of rows from your CSV

First N Rows

Extract the first N rows from your CSV

Slice Rows

Extract a range of rows by start and end position

Add Row Numbers

Add a sequential row number column to your CSV

Reverse Rows

Reverse the order of rows in your CSV

Shuffle Rows

Randomly reorder all rows in your CSV

Filter Rows

Soon

Keep only rows that match your criteria

Sort CSV

Soon

Sort rows by any column, ascending or descending

More CSV Tools

47 tools

CSV to JSON

Convert CSV files to clean, structured JSON

Remove Duplicates

Find and eliminate duplicate rows

Sample Rows

Pick a random sample of rows from your CSV

CSV to SQL

Generate SQL INSERT statements from CSV data

First N Rows

Extract the first N rows from your CSV

CSV to XML

Transform CSV into well-formed XML documents

Slice Rows

Extract a range of rows by start and end position

Add Row Numbers

Add a sequential row number column to your CSV

CSV to JSON Lines

Convert CSV rows into newline-delimited JSON (JSONL/NDJSON)

CSV to YAML

Transform CSV data into clean, readable YAML documents

Reverse Rows

Reverse the order of rows in your CSV

CSV to TSV

Convert comma-separated values to tab-separated format

Shuffle Rows

Randomly reorder all rows in your CSV

CSV to HTML

Generate HTML tables from CSV data for easy web embedding

CSV to Markdown

Convert CSV data into GitHub-flavored Markdown tables

CSV to YNAB

Convert CSV bank statements into YNAB-compatible import format

CSV to Fixed Width

Convert CSV data into fixed-width column format

CSV Viewer

Soon

View and explore CSV files in a sortable table

Filter Rows

Soon

Keep only rows that match your criteria

Merge CSVs

Soon

Combine multiple CSV files into one

Column Stats

Soon

Get min, max, mean, and distribution per column

JSON to CSV

Soon

Convert JSON arrays to downloadable CSV

Sort CSV

Soon

Sort rows by any column, ascending or descending

Split CSV

Soon

Break large CSVs into smaller chunks

CSV Editor

Soon

Edit cells, add rows, and fix data inline

CSV to Excel

Soon

Export CSV data to .xlsx spreadsheets

Data Profiler

Soon

Automatic data type detection and quality report

Excel to CSV

Soon

Import .xlsx files and convert to CSV

Row Counter

Soon

Quick count of rows, columns, and empty cells

TSV to JSON

Soon

Convert tab-separated data into structured JSON output

CSV to QBO

Soon

Convert CSV bank transactions into QuickBooks Online format

CSV to vCard

Soon

Transform CSV contact lists into vCard (.vcf) files

CSV to QIF

Soon

Convert CSV financial data into Quicken Interchange Format

CSV to VCF

Soon

Export CSV contacts as VCF files for email and phone import

CSV to TXT

Soon

Convert CSV data into plain text with customizable formatting

CSV to IIF

Soon

Convert CSV transactions into Intuit Interchange Format for QuickBooks

CSV to KML

Soon

Generate KML geographic data files from CSV coordinates

CSV to Base64

Soon

Encode CSV data as a Base64 string for safe transport

CSV to SPSS

Soon

Convert CSV datasets into SPSS-compatible format for statistical analysis

CSV to SAS

Soon

Transform CSV data into SAS dataset format

CSV to Stata

Soon

Convert CSV data into Stata .dta format for econometric analysis

CSV to ORC

Soon

Convert CSV into Optimized Row Columnar format for big data

CSV to Feather

Soon

Convert CSV into Apache Arrow Feather format for fast analytics

CSV to Parquet

Soon

Convert CSV into columnar Parquet format for efficient storage

CSV to LaTeX

Soon

Generate LaTeX table markup from CSV data

CSV to Xero

Soon

Convert CSV bank statements into Xero-compatible import format

CSV to OFX

Soon

Convert CSV financial data into Open Financial Exchange format