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.
Other data sets – Human Resources Credit Card Bank Transactions HR 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 |
Naice
eyy hazit, pls dont spell kak laaak dah
Great 👍 http://www.basikumatiya.ml
nice 😀
Thank you
Thank you so much! 🙂
if any one would like to exchange data ( millions of records ) get in touch skype: leadstoday@hotmail.com
Thank you so very very much
Thank you
Thanks for helping us
Many thanks (y)
God Bless you for this data
Thank you. This will be of huge help. God bless.
thanks
Very Cool!
you're awesome!
thanks for your hard work..
what is order_priority ?
C, H, L, M
Low, Medium, High, Critical
had the same question as wan.
thanks! thanks!
Hi,
Can I please get a dataset of up to 100,000 records and around 30 columns? I can see the files above only have about 14columns.
Regards
AFO
Thank You…
Thanks
Hi, can I use your dataset for my github testing project? I would like to add my portofolio using these dataset.
Yes. No conditions attached.
tttt
Thanks guysss… These files helped me a lot in tetsing
what is mean from "order priority"?
H-High, M-Medium, L-Low, C-Critical
nice
Kindly provide the same quantity of data asxlsx format
Thanks :v
thanks admin, so helpful
thanks
Many Thanks for providing useful tool/information.
Thanks again.
Great work , thanks for helping so many poeple.
thanks for being gaeee
thanks for sharing . I need this data for my learning purpose. I hope it will help me a lot.
Very Nice, Thanks for providing the data and help.
hi a new here but i hope ill be able to catch up on you guys. And if anyone needs my help am here for them though am new in this
hi am new here but i hope ill be able to catch up on you guys. And if anyone needs my help am here for them though am new in this
Thanks a lot, this is what i was looking for
Thanks
Wow thanks
Thank you, very much.
Buen día Administrador…
Excelentes contenidos y bases de prueba…. muy útiles para practicar análisis. Recomendaría que publicaran mas contenidos sobre POWER BI que es la herramienta líder de Microsoft para el análisis de información.
Thank you. Looking forward to contribute to posts related to Power BI in Q2-21.
Very helpful.Thank you.
lotta spam here admin
thx
it is awesome for practice
Is the Order_id unique in all the files?
Thank You Very Much
Thank you.
Thanks
Thanks a Lot.. This is really very big help… God Bless you
Learn how to use Excel and Google Sheets here: https://spreadsheetdaddy.com/
Thanks alot
I like this site it's a master piece! Glad I
found this on google.
I like this website it's a master piece! Glad I noticed this
on google.
Hello there! This post couldn't be written any better! Reading this post reminds me of my previous room mate! He always kept chatting about this. I will forward this write-up to him. Fairly certain he will have a good read. Thank you for sharing!
whoah this weblog is excellent i really like studying your posts. Keep up the great work! You know, many people are searching round for this information, you can help them greatly.
What currency does this sales data use?
Did anyone use pyspark for doing analysis or visualization or any ML algorithms? Need some help .
Thanks !
You are doing awesome work Thank you very much for providing the sample data.
Thanks
Thanks, but I am missing South America in Regions
Hi Author,
I have developed excel tool to summarize 50 million records of csv data. You can view / filter csv data before adding it to excel. It supports 20 columns of text and 20 columns of numerical values. If interested please reply and we can take it forward. Thank you
Thank you so much for the free dataset access
Thanks a Lot
Just wanna tell that this is very beneficial, Thanks for taking your time to write this.
You're the best! Very much appreciated.
Normally I do not learn post on blogs, but I would like
to say that this write-up very forced me to
check out and do so! Your writing taste has been amazed me.
Thanks, quite great article.
Thank you so much, it love it so much!