CSV Tools CSV Tools

Sample Rows

Pick a random sample of rows from your CSV

CSV Input

Options

CSV Output

Sampled rows will appear here...

More Options

CSV Format

Input

Output

How to Use This Tool

This tool picks a random sample of rows from your CSV. Choose how many rows to sample by count or by percentage. It runs directly in your browser, so your data is never uploaded anywhere.

If your file has a header row, it stays at the top of the output automatically. Use the seed option for repeatable results, or the replacement option if you need the same row to appear more than once.

  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. Choose your sample size — Switch between Count and Percentage mode using the tabs. Set the number of rows or the percentage you want to sample. The tool shows the total rows in your file to help you decide.
  3. Get your output — Copy the sampled CSV to your clipboard or save it as a .csv file.

FAQ

4 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.
What is the difference between Count and Percentage mode?
Count mode lets you choose an exact number of rows to sample (e.g., 10 rows). Percentage mode lets you choose a proportion of the total (e.g., 50% of your rows). Both produce a random sample.
What does the seed option do?
When you enter a seed value, the sample becomes repeatable — the same seed with the same input always picks the same rows. Leave it empty for a different random sample each time.
What does 'with replacement' mean?
By default, each row can only appear once in the sample. With replacement turned on, the same row can be picked more than once, and the sample count is no longer limited by the number of rows in your file.

More Row Operations Tools

9 tools

Remove Duplicates

Find and eliminate duplicate rows

First N Rows

Extract the first N rows from your CSV

Last N Rows

Extract the last 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

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

Last N Rows

Extract the last 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

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