Sample orders workbook XLSX (250 rows, with formulas)
An Excel workbook with one sheet of 250 fictional orders: text, dates, numbers and a formula column that multiplies quantity by unit price.
Download
sample-orders.xlsx
20.3 KB20,820 bytes
Download XLSX sampleDirect download. No sign-up and no waiting.
- Type
- application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
- SHA-256
6fcdbc85d6a7ef5a79656b6f76015a753807f43ae4bd132c0ae8ec8868bf8731- Direct URL
https://sampletestfiles.com/downloads/samples/sample-orders.xlsx
Why test with this file
For testing spreadsheet import, formula evaluation, date conversion and frozen header rows.
| Sheets | 1 (Orders) |
|---|---|
| Data rows | 250 |
| Columns | 9 |
| Formulas | 250 (total = quantity × unit price) |
| Frozen panes | Header row |
| Macros | None |
What to check
After your application has processed sample-orders.xlsx, confirm that:
- 250 data rows are imported, with the header recognised.
- Order dates arrive as dates, not as serial numbers such as 45123.
- The total column matches quantity multiplied by unit price whether formulas are recalculated or cached values are read.
First bytes of the file
The first 64 bytes of sample-orders.xlsx as a hex dump: offset, bytes, then the same bytes as text. The XLSX signature is 50 4B 03 04.
00000000 50 4b 03 04 14 00 00 00 08 00 00 00 21 5c 19 27 |PK..........!\.'|
00000010 be 30 2f 01 00 00 96 03 00 00 13 00 00 00 5b 43 |.0/...........[C|
00000020 6f 6e 74 65 6e 74 5f 54 79 70 65 73 5d 2e 78 6d |ontent_Types].xm|
00000030 6c ad 93 cf 4e 02 31 10 c6 ef 3e 45 d3 2b d9 16 |l...N.1...>E.+..|Preview
XLSX files cannot be shown in a browser. Download the file and open it with Microsoft Excel.
Technical details
| File name | sample-orders.xlsx |
|---|---|
| Format | XLSX (Excel workbook (Office Open XML)) |
| Extension | .xlsx |
| MIME type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| Size | 20,820 bytes (20.3 KB) |
| Kind | Binary |
| Signature | 50 4B 03 04 |
| SHA-256 | 6fcdbc85d6a7ef5a79656b6f76015a753807f43ae4bd132c0ae8ec8868bf8731 |
| Created | 2026-10-10 |
| Validation | Exact size, signature bytes and structure checked when the file was generated |
| Preview | Not available for this format; details only |
| Source | Generated for this site; not copied from elsewhere |
| Licence | Free to use, modify and redistribute (terms) |
| Category | Spreadsheets |
Validated for expected format and integrity. As with any download, scan the file with your own security tools before opening it. How files are made and checked
Download from the command line and verify
Fetch the file with curl, then compare its checksum with the SHA-256 value above.
curl -o sample-orders.xlsx 'https://sampletestfiles.com/downloads/samples/sample-orders.xlsx'
sha256sum sample-orders.xlsx # Linux
shasum -a 256 sample-orders.xlsx # macOSOn Windows, run Get-FileHash sample-orders.xlsx -Algorithm SHA256 in PowerShell. A matching value proves that the download is complete and unaltered.
Where it fits
- File parser testing
Well-formed files and deliberate edge cases for testing code that reads CSV, JSON, XML, PDF and more.
- File upload testing
Test an upload form or endpoint with files of every size and type it should accept, and several it should refuse.