Skip to content
fileshape

File format

Excel XLSX files: reading and converting

Fileshape reads and writes Excel (.xlsx) (.xlsx, .xlsm, MIME type application/vnd.openxmlformats-officedocument.spreadsheetml.sheet). Conversion runs in your browser.

An .xlsx file is a zipped collection of XML documents: one per sheet plus shared strings, styles and workbook metadata. Values are stored separately from their display format, so the number 45658 might be shown as 01/01/2025 because of a date format, and a formula cell stores both the formula and its last calculated value.

Fileshape reads workbooks with SheetJS in your browser. It lists every sheet so you can choose one, uses each cell's displayed text, takes formula results rather than formulas, and detects the real header row when reports have titles above the table. When writing .xlsx it creates a single sheet with every value as text, so codes keep their leading zeros.

Quirks

  • Dates are numbers with a date format; without the format they look like 45658.
  • Merged cells hold their value in the top-left cell only.
  • The legacy .xls format can be read but not written.

Guides