Sample XLSX Generator
Generate a genuine Excel workbook in seconds — seven workbook types, real formulas Excel recalculates, real typed cells and an exact target file size. No placeholder spreadsheets. Runs entirely in your browser.
| A | B | C | D |
| 1 | 2 | 3 | 4 |
Quick Tips for the Right Test File
Features
The First Format Here That Calculates
Sample DOCX produces something meant to be read and edited as prose. This generator produces something meant to be calculated — cells that reference other cells, formulas that recompute the moment an input changes. That's not a cosmetic difference; it's the entire reason a spreadsheet exists as its own format instead of just being a very structured document. Formulas and Invoice / Budget both write real formula text into the file, alongside a correctly precomputed value, so the numbers are right immediately and stay right if you edit an input afterward.
Multiple Sheets pushes that further: its Summary sheet contains no raw data of its own at all, only formulas reading from the Data sheet through a genuine cross-sheet reference. That kind of workbook — one sheet computing entirely from another — is an extremely common real-world Excel pattern, and a fair number of spreadsheet-handling libraries only get tested against single, self-contained sheets that never have to resolve a reference across sheet boundaries.
Every formula here also ships with a correctly precomputed cached value alongside the formula text itself, mirroring exactly what real Excel does every time it saves — the cached value is what most spreadsheet libraries read by default unless they specifically opt into recalculating, so a formula cell with no cached value shows blank in a lot of tooling even though the formula itself is perfectly valid. Getting that pairing right is a small detail, but it's the difference between a file that merely looks correct in Excel and one that behaves correctly everywhere else too.
What This Tool Honestly Can't Do
The engine behind this generator is a genuinely capable, widely used open-source spreadsheet library — and its free edition has one specific, well-known limitation worth stating plainly rather than working around with a workaround that doesn't actually work: it doesn't write visual cell styling. Bold headers, colored fills, cell borders — all fully supported when reading an existing file, none of them supported when writing a new one in the free tier. Real formulas, real number formats and real data types all write correctly; visual styling specifically does not, and no setting in this tool changes that.
That's why headers throughout this generator are set apart by capitalization and row position instead of bold or color, and why the FAQ calls this out directly rather than shipping a tool that quietly produces plain-looking output without explaining why.
Types That Aren't Just Text Wearing a Number Format
A spreadsheet cell that displays "$1,999.50" could be a genuine number with a currency format applied, or it could be the literal text string "$1,999.50" typed in — visually identical, structurally completely different, and only one of them supports being summed, averaged or sorted numerically. Mixed Data Types exists to make that distinction impossible to miss: a real number, a real date stored as Excel's date serial format, a real boolean, a percentage stored as its true fractional value and displayed with a percent sign, and — just as deliberately — a zero-padded code kept as text specifically so its leading zeros survive, since forcing that one into a number would silently strip them.
Any tool that reads a spreadsheet by its actual cell types rather than by eyeballing the displayed text needs a file that gets this distinction right to test against honestly, and it's a surprisingly easy thing for a hand-built test file to get wrong.
Who Actually Needs a Real Test XLSX
Backend developers validating an upload pipeline's MIME-type and parsing logic need a genuine Office Open XML spreadsheet package, since a renamed CSV fails a real content-sniffing check immediately. Developers building or testing a spreadsheet-import feature — reading rows into a database, mapping columns to fields — need real typed cells and, ideally, a file that also exercises formulas and multiple sheets, since production spreadsheets from real users are rarely as simple as one flat table. Data engineers load-testing a bulk-import path can push Large Dataset toward its 500-row ceiling for a quick, realistic volume check without assembling a real dataset by hand.
Format-conversion tool builders — anything turning a spreadsheet into a PDF, a CSV, or an HTML table — need a source file that actually contains the edge cases their converter has to handle correctly: a formula that needs evaluating rather than just copying, a date that needs reformatting rather than passing through as a raw number, a second sheet that either needs converting too or deliberately dropping. A single flat table of strings tests almost none of that.
QA teams covering a spreadsheet-import feature end-to-end benefit from working through more than one workbook type in the same test pass — a viewer or parser that handles Simple Table correctly can still fail on its first real formula, its first cross-sheet reference, or its first non-string cell type, and each of those needs its own dedicated type from this generator to actually get exercised.
Where This Tool Isn't the Right Pick
If a test specifically needs visual cell styling — bold headers, colored fills, cell borders — this generator won't produce it, for the reasons already covered above; no amount of padding or a bigger Custom target changes that. If the goal is a structured but non-editable, print-ready document instead of a calculating one, Sample PDF File is the better fit. And if you already have a real spreadsheet or PDF and need it converted rather than a new sample generated, Excel to PDF and PDF to Excel handle that conversion directly.