2 MB XLSX sample file
An XLSX file of exactly 2,097,152 bytes. It is a valid Excel workbook (Office Open XML) file, generated for this site and checked with an independent parser. Use it wherever you need a 2 MB sample, test or dummy XLSX file.
Download
sample-xlsx-2mb.xlsx
2 MB2,097,152 bytes
Download 2 MB XLSXDirect download. No sign-up and no waiting.
- Type
- application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
- SHA-256
e5d9fddc1a91457baf7a5047e2aa114f30d9b448dfce1028435e18c43d3b8499- Direct URL
https://sampletestfiles.com/downloads/xlsx/sample-xlsx-2mb.xlsx
What is in this file
One worksheet with a bold, frozen header row and 30,684 rows of fictional orders: text, dates, numbers and a formula in every row. 4,571 bytes of text in the workbook description property bring the file to the exact size.
| Sheets | 1 (Orders) |
|---|---|
| Data rows | 30,684 |
| Columns | 9 |
| Formulas | 30,684 (total = quantity × unit price) |
| Frozen panes | Header row |
| Macros | None |
| Container | ZIP (Office Open XML) |
First bytes of the file
The first 64 bytes of sample-xlsx-2mb.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 in an application that reads XLSX, such as Microsoft Excel.
Where 2 MB matters
A 2,097,152-byte file: exactly the default upload limit of PHP, and twice the default of nginx and Spring Boot. These are the default limits a file of this size is useful for testing:
| System | Limit | Note |
|---|---|---|
| PHP | 2 MB per uploaded file by default (upload_max_filesize) | A file of exactly 2 MB is accepted; one byte more is refused. |
| nginx | 1 MB by default (client_max_body_size) | Rejected with 413 Request Entity Too Large. |
| Spring Boot multipart | 1 MB per file by default (max-file-size) | Rejected unless the property is raised. |
| Django | 2.5 MB in memory by default | 2 MB is held in memory; the 5 MB sample is streamed to a temporary file. |
| Vercel Functions | 4.5 MB request body | Accepted, including as base64 at about 2.8 MB. |
Use this file for
- Finding out whether a 1 MB default has been raised
- Checking date and number conversion
- Verifying formula handling
Testing notes for XLSX
- Reading a large workbook with a DOM-style library can use many times the file size in memory. Test with the 5 MB and 10 MB samples and prefer streaming readers.
- Importers that read only cached values and importers that recalculate formulas can disagree. The samples include a formula in every row.
Technical details
| File name | sample-xlsx-2mb.xlsx |
|---|---|
| Format | XLSX (Excel workbook (Office Open XML)) |
| Extension | .xlsx |
| MIME type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| Size | 2,097,152 bytes (2 MB) |
| Kind | Binary |
| Signature | 50 4B 03 04 |
| SHA-256 | e5d9fddc1a91457baf7a5047e2aa114f30d9b448dfce1028435e18c43d3b8499 |
| Created | 2026-10-10 |
| Validation | Exact size, signature bytes and structure checked when the file was generated |
| Preview | Not available for this file; 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-xlsx-2mb.xlsx 'https://sampletestfiles.com/downloads/xlsx/sample-xlsx-2mb.xlsx'
sha256sum sample-xlsx-2mb.xlsx # Linux
shasum -a 256 sample-xlsx-2mb.xlsx # macOSOn Windows, run Get-FileHash sample-xlsx-2mb.xlsx -Algorithm SHA256 in PowerShell. A matching value proves that the download is complete and unaltered.
Related files
Questions about this file
- Is this file exactly 2 MB?
- Yes. It is 2,097,152 bytes, which is 2 MB in the binary units that operating systems and server limits use (1 KB = 1,024 bytes).
- What is inside the 2 MB XLSX file?
- One worksheet with a bold, frozen header row and 30,684 rows of fictional orders: text, dates, numbers and a formula in every row. 4,571 bytes of text in the workbook description property bring the file to the exact size.
- Do the workbooks contain macros?
- No. They are plain .xlsx files with one worksheet, a frozen header row and simple multiplication formulas.