Large Sample CSV File (12,000 Rows) — Free Download
12,000 rows of synthetic card transactions (about 1 MB) — big enough to make a slow parser, an unpaginated table or an in-memory group-by actually show its limits.
Download the sample file
CSV · 12.000 rows · 971.2 KB · synthetic data, free for any use
Download CSV samplePreview
| txn_id | timestamp | account_id | merchant | category | amount | currency | country | status |
|---|---|---|---|---|---|---|---|---|
| TXN-0000001 | 2026-01-01T00:01:00Z | ACC-01301 | Amazon | Fuel | 716.47 | JPY | JP | settled |
| TXN-0000002 | 2026-01-01T00:05:00Z | ACC-00036 | IKEA | Subscriptions | 304.46 | EUR | DE | settled |
| TXN-0000003 | 2026-01-01T00:06:00Z | ACC-01228 | Delta | Groceries | 460.62 | EUR | DE | declined |
| TXN-0000004 | 2026-01-01T00:09:00Z | ACC-00893 | Amazon | Food & Drink | 273.95 | GBP | GB | settled |
| TXN-0000005 | 2026-01-01T00:15:00Z | ACC-00241 | Amazon | Groceries | 134.98 | GBP | GB | settled |
| TXN-0000006 | 2026-01-01T00:16:00Z | ACC-01325 | IKEA | Subscriptions | 917.93 | EUR | DE | settled |
Showing the first 6 of 12.000 rows.
Columns
| Column | Type | Description |
|---|---|---|
txn_id | string | Primary key, TXN-0000001… |
timestamp | datetime (ISO 8601) | Roughly one transaction every few minutes |
account_id | string | ~1,500 distinct accounts |
merchant | string | 12 well-known merchant names |
category | string | 8 spending categories |
amount | decimal | Transaction amount |
currency | string | USD, EUR, GBP, CAD, JPY |
country | string | Two-letter country code matching the currency |
status | string | settled (94%), pending, declined or refunded |
What makes this file useful
- At ~1 MB and 12,000 rows this is small enough to open anywhere but large enough to expose O(n²) mistakes and unpaginated UIs.
- currency and country always agree, so currency conversion tests have consistent inputs.
- account_id repeats about 8 times on average, so per-account aggregation produces real groups rather than mostly-singletons.
- Need something bigger? Concatenate the file to itself a few times, or use Batch Processor to multiply it.
Use cases
- Benchmark CSV parse time in your language or tool
- Test table pagination and virtual scrolling
- Run a group-by over ~1,500 accounts and check memory use
- Practise chunked / streaming reads instead of loading it all
Open it in a tool
Load this sample — or your own file — into a real tool. Everything runs client-side.
Related guides
More sample datasets
Frequently asked questions
How big is the file?
About 1 MB, 12,000 data rows plus a header.
Is 12,000 rows "large"?
Not for a database, but it is enough to surface performance problems in browser tables, spreadsheets on weak hardware, and naive algorithms. For multi-million-row testing, tile this file.
Will it open in Excel?
Yes, easily — Excel handles ~1M rows. The value here is testing code and UIs, not Excel's limit.
Turn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.
Follow HowToCSV on Google
Add us as a preferred source on Google Search so our latest CSV guides and tutorials surface more often in your Top stories.