Skip to content

Sample CSV Files

Download sample CSV files for spreadsheet imports, upload forms, parser checks, and data-pipeline tests. Choose fixed 10, 100, or 1,000 row examples, or inspect fixtures for quoted values, semicolon delimiters, UTF-8 BOM, and files without a header. Larger 10,000 and 100,000 row datasets are generated locally when requested. Every row uses fictional data, making the files suitable for repeatable demonstrations without including a real customer export.

Ready-made downloads

10 data rows

sample-10-rows.csv

A compact table with a header for a first import check.

440 B · Data records: 10

Download
Preview excerpt
id,name,email,active
1,Example User 1,user1@example.com,false
2,Example User 2,user2@example.com,true
3,Example User 3,user3@example.com,false
4,Example User 4,user4@example.com,true
5,Example User 5,user5@example.com,false

100 data rows

sample-100-rows.csv

A fixed fictional dataset for import and pagination tests.

4.4 KB · Data records: 100

Download
Preview excerpt
id,name,email,active
1,Example User 1,user1@example.com,false
2,Example User 2,user2@example.com,true
3,Example User 3,user3@example.com,false
4,Example User 4,user4@example.com,true
5,Example User 5,user5@example.com,false

1,000 data rows

sample-1000-rows.csv

A larger static table for repeatable pipeline checks.

47.2 KB · Data records: 1,000

Download
Preview excerpt
id,name,email,active
1,Example User 1,user1@example.com,false
2,Example User 2,user2@example.com,true
3,Example User 3,user3@example.com,false
4,Example User 4,user4@example.com,true
5,Example User 5,user5@example.com,false

Quoted and multiline fields

quoted-fields.csv

Commas, quotes, and embedded newlines for CSV-aware parsers.

179 B · Data records: 2

Download
Preview excerpt
id,name,email,notes
1,"Example, Ada",ada@example.com,"Said ""hello""
and continued on a new line."
2,"Example ""Bo""",bo@example.com,"Comma, quote "" and Unicode café 你好"

Semicolon delimiter

semicolon.csv

A semicolon-separated table for regional spreadsheet imports.

440 B · Data records: 10

Download
Preview excerpt
id;name;email;active
1;Example User 1;user1@example.com;false
2;Example User 2;user2@example.com;true
3;Example User 3;user3@example.com;false
4;Example User 4;user4@example.com;true
5;Example User 5;user5@example.com;false

UTF-8 with BOM

utf8-bom.csv

Multilingual CSV with a BOM for encoding-detection tests.

240 B · Data records: 5

Download
Preview excerpt
id,name,email,active
5,Example Café 你好,unicode@example.com,true
1,Example User 1,user1@example.com,false
2,Example User 2,user2@example.com,true
3,Example User 3,user3@example.com,false
4,Example User 4,user4@example.com,true

Without a header

no-header.csv

Data starts in the first record; configure import accordingly.

418 B · Data records: 10

Download
Preview excerpt
1,Example User 1,user1@example.com,false
2,Example User 2,user2@example.com,true
3,Example User 3,user3@example.com,false
4,Example User 4,user4@example.com,true
5,Example User 5,user5@example.com,false

Larger files, generated on demand

10,000 data rows

sample-10000-rows.csv

Generate a fictional table locally for larger import tests.

~501.7 KB · Data records: 10,000

Generated locally in your browser

100,000 data rows

sample-100000-rows.csv

Generate a large fictional table locally to check volume handling.

~5.3 MB · Data records: 100,000

Generated locally in your browser

Understand the sample files

Choose a fixture that matches the behavior you need to test.

A CSV is a table with conventions

A CSV record is a row of fields separated by a delimiter, commonly a comma. Many applications treat the first record as column names, but that is a convention rather than a universal requirement. The no-header fixture helps check whether an importer incorrectly drops the first data record. Before comparing row totals, decide whether your application counts the header. The record count displayed here describes data rows, not the number of physical newline characters.

Quoted fields need a real parser

The escaping example contains commas, quotation marks, and embedded line breaks inside fields. A field containing a delimiter or newline is enclosed in double quotes; an internal double quote is represented by two double quotes. Consequently, splitting the text at every comma or newline will misread this valid fixture. Use a CSV parser that understands quoting, and check the recovered field values rather than expecting one physical line to equal one table row.

Match encoding and delimiter settings

UTF-8 supports multilingual text. A UTF-8 BOM adds the bytes EF BB BF at the beginning and can help some spreadsheet software detect the encoding. An importer that fails to remove it may see an unexpected character in the first column name. The semicolon fixture supports tests for regional spreadsheet settings where commas may be decimal separators. Choose the delimiter explicitly during import if automatic detection selects the wrong table structure.

Scale tests from correctness to volume

Use a small fixed fixture to inspect column names, types, and quoting before generating many rows. The 10,000 and 100,000 row options exercise different workloads from the 10 row example; they are not evidence that a spreadsheet or server can accept every larger dataset. Generation and parsing both consume device memory. Measure actual byte size and elapsed time, and keep other variables constant when comparing performance results.

How to use these downloads

Start small, inspect the structure, then test larger inputs.

  1. 1

    Pick a representative sample

    Start with the row count or edge case relevant to your import. Review the card’s filename, bytes, and data-row count, then expand the preview. Choose escaping, semicolon, BOM, or no header deliberately, because a successful import with the simplest comma-separated file does not prove those other cases work.

  2. 2

    Import with explicit settings

    Download the file and select its encoding, delimiter, and header handling in the destination application. Treat identifier and postal-code columns as text when leading zeros matter. Confirm that dates and numbers were not silently reformatted by regional spreadsheet settings. Keep the original download unchanged so you can distinguish import behavior from an edited fixture.

  3. 3

    Check fields before increasing rows

    Compare the imported data-row total, column count, and representative cell values with the fixture. For the escaping example, verify the comma and newline remain inside their intended field. Only after those checks should you generate 10,000 or 100,000 rows to test progress indicators, timeouts, upload limits, and recovery from an interrupted operation.

Frequently asked questions

Answers about the supplied fixtures and their limits.

Common use cases

Practical ways to use this tool.

  • Verify that a no-header import retains the first record and that the same importer handles an explicit header correctly.
  • Use the quoting fixture as a regression input after changing a CSV reader, especially if the previous implementation split on commas.
  • Compare small and large imports while monitoring row totals, memory use, progress feedback, and the ability to retry safely.

Related tools

Explore another conversion or file tool.