Skip to main content

Online Excel Dataset Generator

Generate XLSX workbooks with customizable tabular rows, columns, field types, file counts, and sheet counts for spreadsheet testing.

Quick Options (Rows):
Field name Type Options
Also updates available contact fields
Field separator
Output size
Max 25
Max 10
Max 10

Quick use cases

Create spreadsheet fixtures for import and reporting tests. Test workflows that process multiple sheets or workbooks. Generate tabular sample data for Excel-compatible applications.

Common generator issues

Column types change when the workbook is opened or imported. Headers do not match the expected spreadsheet template. A target workflow expects a different sheet count or layout.

Generator feature notes

  • Each sheet contains tabular rows and columns.
  • Set the number of workbooks and sheets before generation.
  • The XLSX action generates and downloads the workbook directly.

Feature boundaries

Generate up to 5,000 rows per sheet. Use up to 25 columns, 10 files, and 10 sheets. Larger workbooks may require more browser memory and generation time.

Sample output structure

Sheet: Data
id | name | email
1 | John | john@example.com

Dataset generator FAQ

Can I generate multiple XLSX sheets?

Yes. Set the sheet count to generate up to 10 sheets in each workbook.

Can I generate multiple XLSX files?

Yes. The generator supports up to 10 workbook files in one run.

What structure does each sheet use?

Each sheet contains a header row followed by flat tabular data rows using the configured columns and value types.