Example data files

A plain text version of an Excel file, a CSV file is as barebones as it gets when storing structured data. No formatting, no formulas, and no images. Just data, in table form. CSV files are really easy to create and edit, and because they are just plain text they are small in file size. We have a bunch of different sample CSV files for you to download for free, and similarly to the Excel equivalent files we have CSV files with a small amount of data, 100 rows and 1000 rows.

JSON is the go-to format for APIs, config files, and data exchange. We have sample JSON files in different structures and sizes, from a simple flat object to nested data with 1000 records.

XML is still used heavily in enterprise systems, RSS feeds, and sitemaps. We have sample XML files with different structures including nested data, RSS 2.0 feeds, and valid XML sitemaps.

YAML is everywhere in DevOps and configuration. We have sample YAML files from simple key-value configs to realistic Docker Compose and GitHub Actions workflows.

TSV files use tabs instead of commas to separate columns. We have sample TSV files with 100 and 1000 rows of realistic user data. They open in any spreadsheet app or text editor.

NDJSON (or JSON Lines) puts one JSON object on each line. Great for log files and streaming. We have sample NDJSON files with 100 and 1000 lines of event data.

SQL files hold database commands and data. We have sample SQL files with CREATE TABLE statements, INSERT data, full database dumps, and example queries demonstrating JOINs, aggregations, and more.