Disclaimer - The datasets are generated through random logic in VBA. These are not real credit card data and should not be used for any other purpose other than testing.
You can download sample csv files ranging from 100 records to 1500000 records. 1.5 Million records will cross 1 million limit of Excel. But 1.5 Million Records are useful for Power Query / Power Pivot. These csv files contain data in various formats like Text and Numbers which should satisfy your need for testing.
This data set can be categorized under "Credit Card" category.
The data generated follow all known rules for credit cards.
Below are the fields which appear as part of these csv files as first line.
The macro which is used to generate this data can be downloaded from Random Credit Card Generator. The result data will be populated in Credit Cards tab.
All files are provides in zip format to reduce the size of csv file. Larges ones are also provided in 7z format apart from zip format to gain further reduction in size
|100 CC Records||1000 CC Records||5000 CC Records||10000 CC Records|
|zip, 4 KB||zip, 32 KB||zip, 154 KB||zip, 307 KB|
|50000 CC Records||100000 CC Records||500000 CC Records||500000 CC Records|
|zip, 1.53 MB||zip, 3.04 MB||zip, 15.25||7z, 11.64 MB|
|1000000 CC Records||1000000 CC Records||1500000 CC Records||1500000 CC Records|
|zip, 30.42 MB||7z, 23.29 MB||zip, 45.58 MB||7z, 34.92 MB|