application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Excel Spreadsheet (XLSX) Common
The modern Microsoft Excel spreadsheet format — a ZIP archive containing XML worksheet data, formulas, and formatting.
What it's for
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet identifies modern Microsoft Excel spreadsheets (.xlsx), part of the same Office Open XML family as DOCX and PPTX, and following the same underlying design: a ZIP archive containing XML files describing worksheets, cell data, formulas, formatting, and any embedded charts or images. Unlike CSV's simple flat-text approach, XLSX preserves rich spreadsheet features — multiple sheets, cell formatting, formulas, charts, conditional formatting — making it the right choice whenever you need more than raw tabular data.
Format & syntax
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
No parameters. Like DOCX, this is genuinely a ZIP archive internally, containing separate XML files for workbook structure, individual worksheets, shared strings, and styles — programmatic generation typically goes through a dedicated spreadsheet library rather than hand-constructing this XML structure directly.
How it's used in practice
- Data export with formatting/multiple sheets needs — when a plain CSV export isn't sufficient because you need multiple related sheets, formulas, formatting, or charts, XLSX is the natural choice for "download as Excel" features.
- Financial models and reports — spreadsheet-based financial modeling, budgets, and reports that rely on Excel's formula capabilities are naturally distributed as XLSX to preserve those calculations rather than flattening to static values.
- Bulk data import/export in business applications — many business and admin tools support XLSX import/export specifically because end users are more comfortable working in Excel than with raw CSV, especially for data requiring some structure or formatting.
- Template-based document generation — some workflows generate XLSX files from a pre-built template (preserving specific formatting/formulas) and populating it with dynamic data, rather than generating the spreadsheet entirely from scratch.
Common mistakes & gotchas
- Confusing XLSX with the legacy .xls format — like DOCX vs. the older .doc, legacy Excel files (
.xls, pre-2007) use a completely different MIME type (application/vnd.ms-excel) and binary internal format — not interchangeable with modern XLSX, and code should handle both if legacy file support matters. - Choosing XLSX when CSV would be simpler and more appropriate — if you don't actually need formulas, multiple sheets, or rich formatting, CSV is a lighter-weight, more universally compatible choice for pure tabular data export — XLSX adds real complexity (both in generation and in the resulting file) that's only worth it when you need its specific capabilities.
- Memory issues generating very large XLSX files — building large spreadsheets (many rows/sheets) in memory before writing can cause performance and memory issues; many spreadsheet libraries offer streaming/chunked writing modes specifically to handle large exports more efficiently.
- Formula compatibility issues across different generation libraries — not all programmatic XLSX-generation libraries support the full range of Excel formula functions equally well; testing generated formulas actually work correctly when opened in real Excel (rather than just assuming library support) is worth doing for formula-heavy generated spreadsheets.
Comparison & FAQ
| Type | Purpose | Key difference from XLSX |
|---|---|---|
| text/csv | Simple flat tabular data | No support for formulas, multiple sheets, or formatting — much simpler but far less capable than XLSX |
| application/vnd.ms-excel | Legacy binary Excel format (.xls) | Older, pre-2007 binary format, not XML/ZIP-based, not directly interchangeable with XLSX |
Should I export data as CSV or XLSX?
If you only need raw tabular data with no formulas, multiple sheets, or rich formatting, CSV is simpler and more universally compatible. If you need any of those additional capabilities, XLSX is the right choice despite its added complexity.
What's the difference between .xls and .xlsx MIME types?
They're different formats entirely — legacy .xls uses application/vnd.ms-excel (an older binary format), while modern .xlsx uses the OOXML-specific type shown here. Both need separate handling if your application needs to support older Excel files.
Can I open an XLSX file's internal structure like a DOCX?
Yes — like all Office Open XML formats, XLSX is internally a ZIP archive of XML files (worksheet data, styles, shared strings), which you can inspect by renaming the file to .zip and extracting it.
Why is my server-generated XLSX file slow or using excessive memory?
Likely building the entire spreadsheet in memory before writing rather than using a streaming/chunked write approach — for large exports, check whether your spreadsheet library offers a streaming mode specifically designed to handle this more efficiently.