Downloads 18 – Sample CSV Files / Data Sets for Testing (till 5 Million Records) – Sales

<a href=Excel BI Analytics" />

Note – I have been approached for the permission to use data set by individuals / organizations. I just want to clarify one thing. Anything published on this is completely copyright free. You can use anything from this site without any obligation. You can even call the content from this site as your own. Hope, it clarifies. There is absolutely no need to ask for permission for use.

You can download sample csv files ranging from 100 records to 5000000 records. 5 Million records will cross 1 million limit of Excel. But 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 provided 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
2m Sales Records 2m Sales Records 5m Sales Records 5m Sales Records
zip, 78.80 MB 7z, 44.79 MB zip, 196.98 MB 7z, 111.96 MB