Disclaimer - The datasets are generated through random logic in VBA. These are not real sales 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 "Sales" category.

Below are the fields which appear as part of these csv files as first line.

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.

The Excel containing Macro to generate these records can be downloaded from Country Sales Data Generator. The result data will be populated in Detail tab.


100 Sales Records 1000 Sales Records 5000 Sales Records 10000 Sales Records
zip, 5 KB zip, 39 KB zip, 181 KB zip, 358 KB
50000 Sales Records 100000 Sales Records 500000 Sales Records 500000 Sales Records
zip, 1.77 MB zip, 3.54 MB zip, 17.68 MB 7z, 11.10 MB
 1000000 Sales Records 1000000 Sales Records 1500000 Sales Records 1500000 Sales Records
 zip, 35.34 MB  7z, 22.20 MB  zip, 52.99 MB  7z, 33.30 MB