How to Generate Random Data in Excel with RANDBETWEEN & ChatGPT!

Need fast, realistic data for your spreadsheets or projects? In this video, I’ll show you how to use Excel’s RANDBETWEEN function and ChatGPT to generate random and structured sample data — perfect for testing dashboards, templates, or financial models.

👉 In this video, you’ll learn:

How to use RANDBETWEEN() for random numbers

How to quickly create names, dates, and product info with ChatGPT

Tips for generating dynamic data sets in seconds

📊 Great for:

Sample sales data

Financial templates

Business dashboards

Academic projects

💾 Want to skip the setup? Grab ready-made Excel spreadsheets from my Etsy shop:
✔️ Personal Finance Tracker
✔️ Budget Tracker
✔️ Net Worth Tracker
and more!
🛒 Check them out here: www.etsy.com/shop/MasterSpreadsheetsCo

Prompts:
In an excel file, give me 250 entries with the following instructions: I would like the dates to occur all throughout the year 2024, with a slight increase in the summer months. I have two agents for the north west region: sarah green and michael mcdonald. I have three for the south west region: jose martinez, dominic solano and melanie Johnson. I have two for the midwest region: austin reyes and lydia rhines. The regions are north west, south west, and mid west. I would like the PO# to be 9 digits long, and start with US- followed by 6 digits. I would like the invoice number to be the same, however starting instead with either NW- or SW- or MW- depending on the region, followed by 6 digits. We offer 3 models: red, black, and green, priced at $3,500, $8,000, and $10,000 respectively. Make the quantity sold times the price equal the total price. Include some notes for some of the purchases as well.


In an excel file, give me 250 entries under these headers occurring throughout 2024. We have 5 sales agents, 3 regions, and models of red, black, and green. Each sale should be between $5,000-$25,