Datasets
Excel (XLSX) Dataset Generator
Generate Excel (XLSX) Dataset
1
Choose Dataset Type
Select the type of data you want to generate2
Select Users Fields
6 selected
ID
First Name
Last Name
Username
Email
Phone
Gender
Date of Birth
Address
City
State
Country
Zip Code
Column order (drag to reorder):
ID
First Name
Last Name
Email
Username
Phone
3
Generate Users Dataset
Choose how many users records to generateQuick presets:
Number of Records
Maximum 10,000 records per generationName of the Excel worksheet
XLS
Download Ready-Made Excel Files
Pre-generated files — no setup needed, instant downloadInstant Download
Fields: ID, First Name, Last Name, Email, Username, Phone
Tool features
4 features
Multiple Dataset Types
Generate Excel (XLSX) data for users, customers, companies, products, orders, employees, and books with realistic fake data.
Customizable Fields
Select which fields to include in your Excel dataset. Choose from standard fields or add custom fields as needed.
Instant Download
Download ready-made Excel files with preset record counts (10 to 200,000 records) or generate custom datasets.
Preview & Copy
Preview generated data before downloading. Copy sample records to clipboard. Customize sheet name and column widths.
What is Excel sample data & how it works
Excel (XLSX) is a spreadsheet workbook format that keeps columns, headers and cell types, and opens directly in Microsoft Excel, Google Sheets, LibreOffice and Numbers. It is the easiest way to hand realistic sample data to people who work in spreadsheets.
Realistic sample data lets you test imports, UIs, reports and performance without touching production data or personal information. Download a ready-made Excel dataset of users, customers, companies, products, orders, employees or books, or generate your own in the browser with the fields and record count you need. Every value is fake, created with Faker.
Ready-made datasets
Pre-built files from 10 up to 200,000 records, ready to download.
Custom generator
Pick the fields and up to 10,000 records; generated locally in your browser.
Synthetic data
Realistic but fake values, safe to share and to use in tests.
How to use this tool
1
Pick a dataset type
Choose users, customers, companies, products, orders, employees or books.
2
Choose the fields
Select the columns you need, such as names, emails, addresses, prices or dates.
3
Set the size
Pick a record count up to 10,000 and generate, then check the preview.
4
Download
Save the Excel file, or grab a larger ready-made dataset from the download section.
Related tools
4 tools
CSV Datasets
Generate sample CSV data with customizable columns, rows, and data types
JSON Datasets
Generate sample JSON data for testing and development with customizable structures
XML Datasets
Generate sample XML data structures for testing purposes with nested elements
Random String Generator
Generate random strings with customizable length, character sets, and patterns
Frequently asked questions
5 Q&A
The custom generator creates up to 10,000 records in your browser. Ready-made files go up to 200,000 records for load and performance testing.
It is ideal for spreadsheet training, testing Excel import features, and demos for non-technical users.
Yes. XLSX is the standard Office Open XML format supported by Excel, Google Sheets, LibreOffice Calc and Apple Numbers.
In Python use
pandas.read_excel('users.xlsx') (with openpyxl installed); in Node.js use the xlsx (SheetJS) package.