top of page


Public·11 members

Dummy Data in Excel - How to Create and Use Sample Data

Excel Dummy Data Download: How to Get Sample Data for Testing and Training

If you are an Excel user, you might have encountered situations where you need some sample data to practice your skills, test your formulas, or create a dashboard. However, finding realistic and relevant data can be challenging, especially if you don't have access to real-world data sources. That's where Excel dummy data comes in handy.

excel dummy data download

What is Excel Dummy Data?

Excel dummy data is a set of random or simulated data that you can use in your Excel workbook for various purposes. It can be numeric, text, date, or any other type of data that you need. For example, you can use Excel dummy data to:

  • Practice pivot tables, VLOOKUPs, XLOOKUPs, Power Query automation, charts, and dashboards.

  • Feed into Power BI or other business intelligence tools.

  • Test spreadsheet solutions or macros.

  • Create example data for articles or videos.

  • Learn new Excel features or functions.

Why Do You Need Excel Dummy Data?

There are many benefits of using Excel dummy data for your projects. Some of them are:

  • You can save time and effort by not having to collect or create your own data.

  • You can avoid privacy or security issues by not using sensitive or confidential data.

  • You can experiment with different scenarios or parameters without affecting the original data.

  • You can increase your proficiency and confidence in Excel by practicing with various types of data.

How to Create Your Own Excel Dummy Data?

There are two main ways to create your own Excel dummy data: using Excel formulas or using a random data generator add-in.

Using Excel Formulas

You can use Excel formulas to generate random numbers, dates, text, or other types of data. For example, you can use the following formulas:

  • =RAND() to generate a random decimal number between 0 and 1.

  • =RANDBETWEEN(a,b) to generate a random integer number between a and b.

  • =DATE(year,month,day) to generate a date value based on the year, month, and day arguments.

  • =TEXT(value,format) to format a value as text based on the format argument.

You can also use the fill handle or the autofill feature to copy the formulas down or across the cells.

Using Random Data Generator Add-in

If you want more options and flexibility in creating your Excel dummy data, you can use a random data generator add-in. This is a tool that allows you to generate various types of data based on your specifications. For example, you can use the Random Data Generator add-in from Ablebits to generate:

  • Numbers with different formats and ranges.

  • Dates with different formats and intervals.

  • Text with different lengths and characters.

  • Booleans (TRUE or FALSE values).

  • Custom lists (such as names, countries, products, etc.).

You can also specify the number of rows and columns, the seed value, and the output location for your dummy data.

How to Download Excel Dummy Data from Online Sources?

If you don't want to create your own Excel dummy data, you can also download it from online sources. There are many websites that offer Excel dummy data for free download. Some of them are:


Contextures is a website that provides Excel tips, tutorials, and templates. It also offers various Excel sample data sets for training or testing purposes. You can find data sets for office supply orders, property insurance, food sales, work orders, safety, and more. The data sets are in CSV or XLSX formats and can be easily imported into Excel.

excel sample data for training or testing

excel data sets for pivot tables practice

excel data samples in csv format